APPS.AR_BPA_SHUTTLE_PKG dependencies on AR_BPA_AREA_ITEMS

Line 18: update AR_BPA_AREA_ITEMS

14: l_user_id number := -1;
15: begin
16:
17: IF (p_dml_operation = 'UPDATE') THEN
18: update AR_BPA_AREA_ITEMS
19: set DISPLAY_SEQUENCE = P_DISPLAY_SEQUENCE,
20: PARENT_AREA_CODE = P_NEW_PARENT_AREA_CODE,
21: LAST_UPDATE_DATE = sysdate,
22: LAST_UPDATED_BY = l_user_id,

Line 29: insert into AR_BPA_AREA_ITEMS (

25: and PARENT_AREA_CODE = P_AREA_CODE
26: AND ITEM_ID = P_ITEM_ID;
27:
28: if (sql%notfound) then
29: insert into AR_BPA_AREA_ITEMS (
30: AREA_ITEM_ID,
31: TEMPLATE_ID,
32: PARENT_AREA_CODE,
33: SECONDARY_APP_ID,

Line 45: ar_bpa_area_items_s.nextval,

41: LAST_UPDATED_BY,
42: LAST_UPDATE_DATE,
43: LAST_UPDATE_LOGIN
44: ) SELECT
45: ar_bpa_area_items_s.nextval,
46: P_TEMPLATE_ID,
47: P_AREA_CODE,
48: P_SECONDARY_APP_ID,
49: P_DISPLAY_LEVEL ,

Line 63: DELETE FROM AR_BPA_AREA_ITEMS

59: from ar_bpa_items_b item
60: where item.item_id = p_item_id;
61: end if;
62: ELSIF (p_dml_operation = 'DELETE') THEN
63: DELETE FROM AR_BPA_AREA_ITEMS
64: where TEMPLATE_ID = P_TEMPLATE_ID
65: and PARENT_AREA_CODE = P_AREA_CODE
66: AND ITEM_ID = decode(P_ITEM_ID,0,item_id,P_ITEM_ID);
67: END IF;

Line 90: FROM ar_bpa_area_items

86: l_user_id number := -1;
87: CURSOR c_existing_items IS
88: SELECT
89: ITEM_ID
90: FROM ar_bpa_area_items
91: where template_id = P_TEMPLATE_ID
92: AND parent_area_code = P_AREA_CODE;
93:
94: l_translate_flag varchar2(1) := 'N';

Line 131: DELETE FROM AR_BPA_AREA_ITEMS

127: end loop;
128:
129: if (found = false)
130: then
131: DELETE FROM AR_BPA_AREA_ITEMS
132: where TEMPLATE_ID = P_TEMPLATE_ID
133: and PARENT_AREA_CODE = P_AREA_CODE
134: AND ITEM_ID = crec.item_id;
135: end if;

Line 140: update AR_BPA_AREA_ITEMS

136: END LOOP; -- crec
137:
138: FOR i IN 1..p_item_id_list.count
139: LOOP
140: update AR_BPA_AREA_ITEMS
141: set DISPLAY_SEQUENCE = i,
142: PARENT_AREA_CODE = P_NEW_PARENT_AREA_CODE,
143: LAST_UPDATE_DATE = sysdate,
144: LAST_UPDATED_BY = l_user_id,

Line 151: insert into AR_BPA_AREA_ITEMS (

147: and PARENT_AREA_CODE = P_AREA_CODE
148: AND ITEM_ID = to_number(p_item_id_list(i));
149:
150: if (sql%notfound) then
151: insert into AR_BPA_AREA_ITEMS (
152: AREA_ITEM_ID,
153: TEMPLATE_ID,
154: PARENT_AREA_CODE,
155: SECONDARY_APP_ID,

Line 167: ar_bpa_area_items_s.nextval,

163: LAST_UPDATED_BY,
164: LAST_UPDATE_DATE,
165: LAST_UPDATE_LOGIN
166: ) SELECT
167: ar_bpa_area_items_s.nextval,
168: P_TEMPLATE_ID,
169: P_AREA_CODE,
170: P_SECONDARY_APP_ID,
171: P_DISPLAY_LEVEL ,

Line 193: DELETE FROM AR_BPA_AREA_ITEMS

189:
190: IF (p_dml_operation = 'DELETE') THEN
191: FOR i IN 1..p_item_id_list.count
192: LOOP
193: DELETE FROM AR_BPA_AREA_ITEMS
194: where TEMPLATE_ID = P_TEMPLATE_ID
195: and PARENT_AREA_CODE = P_AREA_CODE
196: AND ITEM_ID = to_number(p_item_id_list(i));
197: ar_bpa_utils_pkg.debug ('i= '||to_char(i)||', item id = '||p_item_id_list(i)||' Deleted.');