DBA Data[Home] [Help]

APPS.XLA_DESCRIPTIONS_PKG dependencies on XLA_DESC_PRIORITIES

Line 84: FROM xla_desc_priorities

80:
81: CURSOR c_description_priorities
82: IS
83: SELECT description_prio_id
84: FROM xla_desc_priorities
85: WHERE application_id = p_application_id
86: AND amb_context_code = p_amb_context_code
87: AND description_type_code = p_description_type_code
88: AND description_code = p_description_code;

Line 128: FROM xla_desc_priorities

124: END LOOP;
125: CLOSE c_description_priorities;
126:
127: DELETE
128: FROM xla_desc_priorities
129: WHERE application_id = p_application_id
130: AND amb_context_code = p_amb_context_code
131: AND description_type_code = p_description_type_code
132: AND description_code = p_description_code;

Line 203: FROM xla_desc_priorities

199:
200: CURSOR c_description_priorities
201: IS
202: SELECT description_prio_id, user_sequence
203: FROM xla_desc_priorities
204: WHERE application_id = p_application_id
205: AND amb_context_code = p_amb_context_code
206: AND description_type_code = p_old_description_type_code
207: AND description_code = p_old_description_code;

Line 292: SELECT xla_desc_priorities_s.nextval

288: FETCH c_description_priorities
289: INTO l_description_priority;
290: EXIT WHEN c_description_priorities%notfound;
291:
292: SELECT xla_desc_priorities_s.nextval
293: INTO l_new_description_prio_id
294: FROM DUAL;
295:
296: INSERT INTO xla_desc_priorities

Line 296: INSERT INTO xla_desc_priorities

292: SELECT xla_desc_priorities_s.nextval
293: INTO l_new_description_prio_id
294: FROM DUAL;
295:
296: INSERT INTO xla_desc_priorities
297: (description_prio_id
298: ,application_id
299: ,amb_context_code
300: ,description_type_code

Line 1382: FROM xla_desc_priorities

1378:
1379: CURSOR c_description_priorities
1380: IS
1381: SELECT description_prio_id, user_sequence
1382: FROM xla_desc_priorities
1383: WHERE application_id = p_application_id
1384: AND amb_context_code = p_amb_context_code
1385: AND description_type_code = p_old_description_type_code
1386: AND description_code = p_old_description_code;