APPS.BEN_DM_INIT dependencies on BEN_DM_PHASE_ITEMS

Line 54: -- into the ben_dm_phase_items.

50: --
51:
52: -- ------------------------- populate_pi_table_g ------------------------
53: -- Description: The phase items for the generator phase are seeded
54: -- into the ben_dm_phase_items.
55: --
56: --
57: -- Input Parameters
58: -- r_migration_data - record containing migration information

Line 147: INSERT INTO ben_dm_phase_items (PHASE_ITEM_ID,

143: LOOP
144: FETCH csr_select_pi INTO l_table_name;
145: EXIT WHEN csr_select_pi%NOTFOUND;
146:
147: INSERT INTO ben_dm_phase_items (PHASE_ITEM_ID,
148: PHASE_ID,
149: GROUP_ORDER,
150: TABLE_NAME,
151: STATUS,

Line 159: SELECT ben_dm_phase_items_s.nextval,

155: CREATION_DATE,
156: LAST_UPDATED_BY,
157: LAST_UPDATE_DATE,
158: LAST_UPDATE_LOGIN)
159: SELECT ben_dm_phase_items_s.nextval,
160: l_phase_id,
161: NULL,
162: l_table_name,
163: 'NS',

Line 173: (SELECT NULL FROM ben_dm_phase_items

169: SYSDATE,
170: NULL
171: FROM dual
172: WHERE NOT EXISTS
173: (SELECT NULL FROM ben_dm_phase_items
174: WHERE ((phase_id = l_phase_id)
175: AND (table_name = l_table_name)));
176:
177: COMMIT;

Line 202: -- into the ben_dm_phase_items. An entry is made for each group that is

198: --
199: --
200: -- ------------------------- populate_pi_table_dp ------------------------
201: -- Description: The phase items for the download phase are seeded
202: -- into the ben_dm_phase_items. An entry is made for each group that is
203: -- applicable for the current migration.
204: --
205: --
206: --

Line 250: INSERT INTO ben_dm_phase_items (PHASE_ITEM_ID,

246: LOOP
247: FETCH csr_select_pi INTO l_input_file_id, l_group_order;
248: EXIT WHEN csr_select_pi%NOTFOUND;
249:
250: INSERT INTO ben_dm_phase_items (PHASE_ITEM_ID,
251: PHASE_ID,
252: GROUP_ORDER,
253: TABLE_NAME,
254: INPUT_FILE_ID,

Line 263: SELECT ben_dm_phase_items_s.nextval,

259: CREATION_DATE,
260: LAST_UPDATED_BY,
261: LAST_UPDATE_DATE,
262: LAST_UPDATE_LOGIN)
263: SELECT ben_dm_phase_items_s.nextval,
264: l_phase_id,
265: l_group_order,
266: NULL,
267: l_input_file_id,

Line 278: (SELECT NULL FROM ben_dm_phase_items

274: SYSDATE,
275: NULL
276: FROM dual
277: WHERE NOT EXISTS
278: (SELECT NULL FROM ben_dm_phase_items
279: WHERE ((phase_id = l_phase_id)
280: AND (input_file_id = l_input_file_id)));
281:
282: COMMIT;

Line 309: -- into the ben_dm_phase_items. An entry is made for each group that is

305: --
306:
307: -- ------------------------- populate_pi_table_up ------------------------
308: -- Description: The phase items for the upload phase are seeded
309: -- into the ben_dm_phase_items. An entry is made for each group that is
310: -- applicable for the current migration.
311: --
312: -- Input Parameters
313: -- r_migration_data - record containing migration information

Line 353: INSERT INTO ben_dm_phase_items (PHASE_ITEM_ID,

349: LOOP
350: FETCH csr_select_pi INTO l_group_order;
351: EXIT WHEN csr_select_pi%NOTFOUND;
352:
353: INSERT INTO ben_dm_phase_items (PHASE_ITEM_ID,
354: PHASE_ID,
355: GROUP_ORDER,
356: TABLE_NAME,
357: STATUS,

Line 365: SELECT ben_dm_phase_items_s.nextval,

361: CREATION_DATE,
362: LAST_UPDATED_BY,
363: LAST_UPDATE_DATE,
364: LAST_UPDATE_LOGIN)
365: SELECT ben_dm_phase_items_s.nextval,
366: l_phase_id,
367: l_group_order,
368: NULL,
369: 'NS',

Line 379: (SELECT NULL FROM ben_dm_phase_items

375: SYSDATE,
376: NULL
377: FROM dual
378: WHERE NOT EXISTS
379: (SELECT NULL FROM ben_dm_phase_items
380: WHERE ((phase_id = l_phase_id)
381: AND (group_order = l_group_order)));
382:
383: COMMIT;