Advanced Pricing - EBS (MOSC)

MOSC Banner

Trigger on table qp_list_lines not fetching data

Hi All,

Please share some ideas,

Why trigger on table qp_list_lines is not fetching data?

CREATE OR REPLACE TRIGGER xx_price_line_tgr

   AFTER INSERT

   ON qp_list_lines

   FOR EACH ROW

DECLARE

   l_return_err     VARCHAR2 (240);

   v_priceline_id   NUMBER;

BEGIN

   BEGIN

      SELECT list_line_id

        INTO v_priceline_id

        FROM qp_list_lines_v

       WHERE 1 = 1 AND list_line_id = :NEW.list_line_id;

      INSERT INTO sample_table

                  (attribute1, attribute2

                  )

           VALUES ('Price Line ID', v_priceline_id

                  );

   EXCEPTION

      WHEN OTHERS

      THEN

         l_return_err := 'others:' || 'S' || ':' || SUBSTRB (SQLERRM, 1, 55);

         INSERT INTO sample_table

                     (attribute1, attribute2, attribute3,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center