eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBE_INV_DATABASE_TRIGGER_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 4


PROCEDURE MTL_Categories_B_Deleted(
   p_old_category_id IN NUMBER
)
IS
BEGIN
   -- 1. Update the table IBE_DSP_OBJ_LGL_CTNT
   IBE_LogicalContent_GRP.Delete_Category(
         p_category_id => p_old_category_id);

Line: 14


   IBE_TPLCategory_GRP.Delete_Category(
         p_category_id => p_old_category_id);

Line: 18


   IBE_Prod_Relation_PVT.Category_Deleted(
         p_category_id => p_old_category_id);

Line: 20


END MTL_Categories_B_Deleted;

Line: 23


PROCEDURE MTL_Item_Categories_Inserted(
   p_new_inventory_item_id IN NUMBER,
   p_new_organization_id   IN NUMBER,
   p_new_category_set_id   IN NUMBER,
   p_new_category_id       IN NUMBER
)
IS
BEGIN
   -- 1. Update IBE_CT_RELATED_ITEMS table
   IBE_Prod_Relation_PVT.Item_Category_Inserted(
         p_category_id       => p_new_category_id      ,
         p_inventory_item_id => p_new_inventory_item_id ,
	    p_organization_id   => p_new_organization_id);  --Bug 2922902

Line: 38


   IBE_Search_PVT.Item_Category_Inserted(
         new_category_id       => p_new_category_id      ,
         new_category_set_id   => p_new_category_set_id  ,
         new_inventory_item_id => p_new_inventory_item_id,
         new_organization_id   => p_new_organization_id  );

Line: 43


END MTL_Item_Categories_Inserted;

Line: 46


PROCEDURE MTL_Item_Categories_Deleted(
   p_old_inventory_item_id IN NUMBER,
   p_old_organization_id   IN NUMBER,
   p_old_category_set_id   IN NUMBER,
   p_old_category_id       IN NUMBER
)
IS
BEGIN
   -- 1. Update IBE_CT_IMEDIA_SEARCH table
   IBE_Prod_Relation_PVT.Item_Category_Deleted(
         p_category_id       => p_old_category_id      ,
         p_inventory_item_id => p_old_inventory_item_id,
	    p_organization_id   => p_old_organization_id); --Bug 2922902

Line: 61


   IBE_Search_PVT.Item_Category_Deleted(
         old_category_id       => p_old_category_id      ,
         old_category_set_id   => p_old_category_set_id  ,
         old_inventory_item_id => p_old_inventory_item_id,
         old_organization_id   => p_old_organization_id   );

Line: 66


END MTL_Item_Categories_Deleted;

Line: 69


PROCEDURE MTL_Item_Categories_Updated(
   p_old_inventory_item_id IN NUMBER,
   p_old_organization_id   IN NUMBER,
   p_old_category_set_id   IN NUMBER,
   p_old_category_id       IN NUMBER,
   p_new_inventory_item_id IN NUMBER,
   p_new_organization_id   IN NUMBER,
   p_new_category_set_id   IN NUMBER,
   p_new_category_id       IN NUMBER
)
IS
BEGIN
   -- 1. Update IBE_CT_IMEDIA_SEARCH table
   IBE_Search_PVT.Item_Category_Updated(
         old_category_id       => p_old_category_id      ,
         old_category_set_id   => p_old_category_set_id  ,
         old_inventory_item_id => p_old_inventory_item_id,
         old_organization_id   => p_old_organization_id  ,
         new_category_id       => p_new_category_id      ,
         new_category_set_id   => p_new_category_set_id  ,
         new_inventory_item_id => p_new_inventory_item_id,
         new_organization_id   => p_new_organization_id  );

Line: 91


END MTL_Item_Categories_Updated;

Line: 94


PROCEDURE MTL_System_Items_B_Deleted(
   p_old_inventory_item_id IN NUMBER,
   p_old_organization_id   IN NUMBER
)
IS
BEGIN
   -- 1. Update IBE_CT_RELATED_ITEMS table
   IBE_Prod_Relation_PVT.Item_Deleted(
         p_inventory_item_id => p_old_inventory_item_id,
         p_organization_id   => p_old_organization_id  );

Line: 106


   IBE_DSP_Section_Item_PVT.Delete_Section_Items_For_Item(
         p_inventory_item_id => p_old_inventory_item_id,
         p_organization_id   => p_old_organization_id  );

Line: 111


   IBE_Search_PVT.Item_Deleted(
         old_inventory_item_id => p_old_inventory_item_id,
         old_organization_id   => p_old_organization_id  );

Line: 116


   IBE_LogicalContent_GRP.Delete_Item(
         p_item_id => p_old_inventory_item_id);

Line: 119


END MTL_System_Items_B_Deleted;

Line: 122


PROCEDURE MTL_System_Items_B_Updated(
   p_old_inventory_item_id IN NUMBER,
   p_old_organization_id   IN NUMBER,
   p_old_web_status        IN VARCHAR2,
   p_new_web_status        IN VARCHAR2
 )
IS
BEGIN

   IF (p_old_web_status <> 'DISABLED' AND p_old_web_status IS NOT NULL) AND
      (p_new_web_status = 'DISABLED' OR p_new_web_status IS NULL) THEN
      -- 1. Update IBE_CT_RELATED_ITEMS table
      IBE_Prod_Relation_PVT.Item_Deleted(
            p_inventory_item_id => p_old_inventory_item_id,
            p_organization_id   => p_old_organization_id  );

Line: 139


      IBE_DSP_Section_Item_PVT.Delete_Section_Items_For_Item(
            p_inventory_item_id => p_old_inventory_item_id,
            p_organization_id   => p_old_organization_id  );

Line: 145


   IBE_Search_PVT.Item_Updated(
         old_inventory_item_id => p_old_inventory_item_id,
         old_organization_id   => p_old_organization_id ,
         old_web_status        => p_old_web_status,
         new_web_status        => p_new_web_status
                              );

Line: 153


END MTL_System_Items_B_Updated;

Line: 156


PROCEDURE MTL_System_Items_TL_Inserted(
   p_new_inventory_item_id IN NUMBER  ,
   p_new_organization_id   IN NUMBER  ,
   p_new_language          IN VARCHAR2,
   p_new_description       IN VARCHAR2,
   p_new_long_description  IN VARCHAR2
)
IS
BEGIN
   -- 1. Update IBE_CT_IMEDIA_SEARCH table
   IBE_Search_PVT.ItemTL_Inserted(
         new_inventory_item_id => p_new_inventory_item_id,
         new_organization_id   => p_new_organization_id  ,
         new_language          => p_new_language         ,
         new_description       => p_new_description      ,
         new_long_description  => p_new_long_description );

Line: 172


END MTL_System_Items_TL_Inserted;

Line: 175


PROCEDURE MTL_System_Items_TL_Deleted(
   p_old_inventory_item_id IN NUMBER  ,
   p_old_organization_id   IN NUMBER  ,
   p_old_language          IN VARCHAR2
)
IS
BEGIN
   -- 1. Update IBE_CT_IMEDIA_SEARCH table
   IBE_Search_PVT.ItemTL_Deleted(
         old_inventory_item_id => p_old_inventory_item_id,
         old_organization_id   => p_old_organization_id  ,
         old_language          => p_old_language         );

Line: 187


END MTL_System_Items_TL_Deleted;

Line: 190


PROCEDURE MTL_System_Items_TL_Updated(
   p_old_inventory_item_id IN NUMBER  ,
   p_old_organization_id   IN NUMBER  ,
   p_old_language          IN VARCHAR2,
   p_old_description       IN VARCHAR2,
   p_old_long_description  IN VARCHAR2,
   p_new_language          IN VARCHAR2,
   p_new_description       IN VARCHAR2,
   p_new_long_description  IN VARCHAR2
)
IS
BEGIN
   -- 1. Update IBE_CT_IMEDIA_SEARCH table
   IBE_Search_PVT.ItemTL_Updated(
         old_inventory_item_id => p_old_inventory_item_id,
         old_organization_id   => p_old_organization_id  ,
         old_language          => p_old_language         ,
         new_language          => p_new_language         ,
         new_description       => p_new_description      ,
         new_long_description  => p_new_long_description );

Line: 210


END MTL_System_Items_TL_Updated;