[Home] [Help]
PACKAGE BODY: APPS.IBE_INV_DATABASE_TRIGGER_PVT
Source
1 PACKAGE BODY IBE_INV_Database_Trigger_PVT AS
2 /* $Header: IBEVIDTB.pls 115.8 2003/05/05 03:44:54 ljanakir ship $ */
3
4 PROCEDURE MTL_Categories_B_Deleted(
5 p_old_category_id IN NUMBER
6 )
7 IS
8 BEGIN
9 -- 1. Update the table IBE_DSP_OBJ_LGL_CTNT
10 IBE_LogicalContent_GRP.Delete_Category(
11 p_category_id => p_old_category_id);
12
13 -- 2. Update the table IBE_DSP_TPL_CTG
14 IBE_TPLCategory_GRP.Delete_Category(
15 p_category_id => p_old_category_id);
16
17 -- 3. Update the table IBE_CT_RELATION_RULES
18 IBE_Prod_Relation_PVT.Category_Deleted(
19 p_category_id => p_old_category_id);
20 END MTL_Categories_B_Deleted;
21
22
23 PROCEDURE MTL_Item_Categories_Inserted(
24 p_new_inventory_item_id IN NUMBER,
25 p_new_organization_id IN NUMBER,
26 p_new_category_set_id IN NUMBER,
27 p_new_category_id IN NUMBER
28 )
29 IS
30 BEGIN
31 -- 1. Update IBE_CT_RELATED_ITEMS table
32 IBE_Prod_Relation_PVT.Item_Category_Inserted(
33 p_category_id => p_new_category_id ,
34 p_inventory_item_id => p_new_inventory_item_id ,
35 p_organization_id => p_new_organization_id); --Bug 2922902
36
37 -- 2. Update IBE_CT_IMEDIA_SEARCH table
38 IBE_Search_PVT.Item_Category_Inserted(
39 new_category_id => p_new_category_id ,
40 new_category_set_id => p_new_category_set_id ,
41 new_inventory_item_id => p_new_inventory_item_id,
42 new_organization_id => p_new_organization_id );
43 END MTL_Item_Categories_Inserted;
44
45
46 PROCEDURE MTL_Item_Categories_Deleted(
47 p_old_inventory_item_id IN NUMBER,
48 p_old_organization_id IN NUMBER,
49 p_old_category_set_id IN NUMBER,
50 p_old_category_id IN NUMBER
51 )
52 IS
53 BEGIN
54 -- 1. Update IBE_CT_IMEDIA_SEARCH table
55 IBE_Prod_Relation_PVT.Item_Category_Deleted(
56 p_category_id => p_old_category_id ,
57 p_inventory_item_id => p_old_inventory_item_id,
58 p_organization_id => p_old_organization_id); --Bug 2922902
59
60 -- 2. Update IBE_CT_IMEDIA_SEARCH table
61 IBE_Search_PVT.Item_Category_Deleted(
62 old_category_id => p_old_category_id ,
63 old_category_set_id => p_old_category_set_id ,
64 old_inventory_item_id => p_old_inventory_item_id,
65 old_organization_id => p_old_organization_id );
66 END MTL_Item_Categories_Deleted;
67
68
69 PROCEDURE MTL_Item_Categories_Updated(
70 p_old_inventory_item_id IN NUMBER,
71 p_old_organization_id IN NUMBER,
72 p_old_category_set_id IN NUMBER,
73 p_old_category_id IN NUMBER,
74 p_new_inventory_item_id IN NUMBER,
75 p_new_organization_id IN NUMBER,
76 p_new_category_set_id IN NUMBER,
77 p_new_category_id IN NUMBER
78 )
79 IS
80 BEGIN
81 -- 1. Update IBE_CT_IMEDIA_SEARCH table
82 IBE_Search_PVT.Item_Category_Updated(
83 old_category_id => p_old_category_id ,
84 old_category_set_id => p_old_category_set_id ,
85 old_inventory_item_id => p_old_inventory_item_id,
86 old_organization_id => p_old_organization_id ,
87 new_category_id => p_new_category_id ,
88 new_category_set_id => p_new_category_set_id ,
89 new_inventory_item_id => p_new_inventory_item_id,
90 new_organization_id => p_new_organization_id );
91 END MTL_Item_Categories_Updated;
92
93
94 PROCEDURE MTL_System_Items_B_Deleted(
95 p_old_inventory_item_id IN NUMBER,
96 p_old_organization_id IN NUMBER
97 )
98 IS
99 BEGIN
100 -- 1. Update IBE_CT_RELATED_ITEMS table
101 IBE_Prod_Relation_PVT.Item_Deleted(
102 p_inventory_item_id => p_old_inventory_item_id,
103 p_organization_id => p_old_organization_id );
104
105 -- 2. Update section-items tables
106 IBE_DSP_Section_Item_PVT.Delete_Section_Items_For_Item(
107 p_inventory_item_id => p_old_inventory_item_id,
108 p_organization_id => p_old_organization_id );
109
110 -- 3. Update IBE_CT_IMEDIA_SEARCH table
111 IBE_Search_PVT.Item_Deleted(
112 old_inventory_item_id => p_old_inventory_item_id,
113 old_organization_id => p_old_organization_id );
114
115 -- 4. Update IBE_DSP_OBJ_LGL_CTNT table
116 IBE_LogicalContent_GRP.Delete_Item(
117 p_item_id => p_old_inventory_item_id);
118
119 END MTL_System_Items_B_Deleted;
120
121
122 PROCEDURE MTL_System_Items_B_Updated(
123 p_old_inventory_item_id IN NUMBER,
124 p_old_organization_id IN NUMBER,
125 p_old_web_status IN VARCHAR2,
126 p_new_web_status IN VARCHAR2
127 )
128 IS
129 BEGIN
130
131 IF (p_old_web_status <> 'DISABLED' AND p_old_web_status IS NOT NULL) AND
132 (p_new_web_status = 'DISABLED' OR p_new_web_status IS NULL) THEN
133 -- 1. Update IBE_CT_RELATED_ITEMS table
134 IBE_Prod_Relation_PVT.Item_Deleted(
135 p_inventory_item_id => p_old_inventory_item_id,
136 p_organization_id => p_old_organization_id );
137
138 -- 2. Update section-items tables
139 IBE_DSP_Section_Item_PVT.Delete_Section_Items_For_Item(
140 p_inventory_item_id => p_old_inventory_item_id,
141 p_organization_id => p_old_organization_id );
142 END IF;
143
144 -- 3. Update search table
145 IBE_Search_PVT.Item_Updated(
146 old_inventory_item_id => p_old_inventory_item_id,
147 old_organization_id => p_old_organization_id ,
148 old_web_status => p_old_web_status,
149 new_web_status => p_new_web_status
150 );
151
152
153 END MTL_System_Items_B_Updated;
154
155
156 PROCEDURE MTL_System_Items_TL_Inserted(
157 p_new_inventory_item_id IN NUMBER ,
158 p_new_organization_id IN NUMBER ,
159 p_new_language IN VARCHAR2,
160 p_new_description IN VARCHAR2,
161 p_new_long_description IN VARCHAR2
162 )
163 IS
164 BEGIN
165 -- 1. Update IBE_CT_IMEDIA_SEARCH table
166 IBE_Search_PVT.ItemTL_Inserted(
167 new_inventory_item_id => p_new_inventory_item_id,
168 new_organization_id => p_new_organization_id ,
169 new_language => p_new_language ,
170 new_description => p_new_description ,
171 new_long_description => p_new_long_description );
172 END MTL_System_Items_TL_Inserted;
173
174
175 PROCEDURE MTL_System_Items_TL_Deleted(
176 p_old_inventory_item_id IN NUMBER ,
177 p_old_organization_id IN NUMBER ,
178 p_old_language IN VARCHAR2
179 )
180 IS
181 BEGIN
182 -- 1. Update IBE_CT_IMEDIA_SEARCH table
183 IBE_Search_PVT.ItemTL_Deleted(
184 old_inventory_item_id => p_old_inventory_item_id,
185 old_organization_id => p_old_organization_id ,
186 old_language => p_old_language );
187 END MTL_System_Items_TL_Deleted;
188
189
190 PROCEDURE MTL_System_Items_TL_Updated(
191 p_old_inventory_item_id IN NUMBER ,
192 p_old_organization_id IN NUMBER ,
193 p_old_language IN VARCHAR2,
194 p_old_description IN VARCHAR2,
195 p_old_long_description IN VARCHAR2,
196 p_new_language IN VARCHAR2,
197 p_new_description IN VARCHAR2,
198 p_new_long_description IN VARCHAR2
199 )
200 IS
201 BEGIN
202 -- 1. Update IBE_CT_IMEDIA_SEARCH table
203 IBE_Search_PVT.ItemTL_Updated(
204 old_inventory_item_id => p_old_inventory_item_id,
205 old_organization_id => p_old_organization_id ,
206 old_language => p_old_language ,
207 new_language => p_new_language ,
208 new_description => p_new_description ,
209 new_long_description => p_new_long_description );
210 END MTL_System_Items_TL_Updated;
211
212 END IBE_INV_Database_Trigger_PVT;