Form Personalization : Calling PL/SQL Procedure

Requirement is just like to insert item details in custom table along with in base table MTL_SYSTEM_ITEMS_B.

Table :

CREATE TABLE TEST_ITEM_TBL
(
   ITEM          VARCHAR2 (100),
   DESCRIPTION   VARCHAR2 (100)
);

Procedure:

CREATE OR REPLACE PROCEDURE TEST_ITEM_PROC (P_ITEM VARCHAR2, P_DESC VARCHAR2)
IS
   V_ITEM   VARCHAR2 (100);
BEGIN
   BEGIN
      SELECT ITEM
        INTO V_ITEM
        FROM TEST_ITEM_TBL
       WHERE ITEM = P_ITEM;
   EXCEPTION
      WHEN OTHERS
      THEN
         V_ITEM := NULL;
   END;

   IF V_ITEM IS NULL
   THEN
      INSERT INTO TEST_ITEM_TBL (ITEM, DESCRIPTION)
           VALUES (P_ITEM, P_DESC);
   END IF;

   COMMIT;
END TEST_ITEM_PROC;

Navigation: Inventory Vision Operations --> Items --> Master Items

Navigation: Help --> Diagnostics --> Custom Code --> Personalize

Continue>>>