1 PACKAGE IBE_INV_Database_Trigger_PVT AUTHID CURRENT_USER AS
2 /* $Header: IBEVIDTS.pls 120.0 2005/05/30 02:25:15 appldev noship $ */
3
4 PROCEDURE MTL_Categories_B_Deleted(
5 p_old_category_id IN NUMBER
6 );
7
8
9 PROCEDURE MTL_Item_Categories_Inserted(
10 p_new_inventory_item_id IN NUMBER,
11 p_new_organization_id IN NUMBER,
12 p_new_category_set_id IN NUMBER,
13 p_new_category_id IN NUMBER
14 );
15
16
17 PROCEDURE MTL_Item_Categories_Deleted(
18 p_old_inventory_item_id IN NUMBER,
19 p_old_organization_id IN NUMBER,
20 p_old_category_set_id IN NUMBER,
21 p_old_category_id IN NUMBER
22 );
23
24
25 PROCEDURE MTL_Item_Categories_Updated(
26 p_old_inventory_item_id IN NUMBER,
27 p_old_organization_id IN NUMBER,
28 p_old_category_set_id IN NUMBER,
29 p_old_category_id IN NUMBER,
30 p_new_inventory_item_id IN NUMBER,
31 p_new_organization_id IN NUMBER,
32 p_new_category_set_id IN NUMBER,
33 p_new_category_id IN NUMBER
34 );
35
36
37 PROCEDURE MTL_System_Items_B_Deleted(
38 p_old_inventory_item_id IN NUMBER,
39 p_old_organization_id IN NUMBER
40 );
41
42
43 PROCEDURE MTL_System_Items_B_Updated(
44 p_old_inventory_item_id IN NUMBER,
45 p_old_organization_id IN NUMBER,
46 p_old_web_status IN VARCHAR2,
47 p_new_web_status IN VARCHAR2
48 );
49
50 PROCEDURE MTL_System_Items_TL_Inserted(
51 p_new_inventory_item_id IN NUMBER ,
52 p_new_organization_id IN NUMBER ,
53 p_new_language IN VARCHAR2,
54 p_new_description IN VARCHAR2,
55 p_new_long_description IN VARCHAR2
56 );
57
58
59 PROCEDURE MTL_System_Items_TL_Deleted(
60 p_old_inventory_item_id IN NUMBER ,
61 p_old_organization_id IN NUMBER ,
62 p_old_language IN VARCHAR2
63 );
64
65
66 PROCEDURE MTL_System_Items_TL_Updated(
67 p_old_inventory_item_id IN NUMBER ,
68 p_old_organization_id IN NUMBER ,
69 p_old_language IN VARCHAR2,
70 p_old_description IN VARCHAR2,
71 p_old_long_description IN VARCHAR2,
72 p_new_language IN VARCHAR2,
73 p_new_description IN VARCHAR2,
74 p_new_long_description IN VARCHAR2
75 );
76
77 END IBE_INV_Database_Trigger_PVT;