APPS.BEN_DM_UTILITY dependencies on BEN_DM_PHASES

Line 133: FROM ben_dm_phases

129: l_phase_status VARCHAR2(30);
130:
131: CURSOR csr_status IS
132: SELECT status
133: FROM ben_dm_phases
134: WHERE ((migration_id = p_migration_id)
135: AND (phase_name = p_phase));
136:
137: --

Line 204: FROM ben_dm_phases

200: l_phase_id NUMBER;
201:
202: CURSOR csr_phase IS
203: SELECT phase_id
204: FROM ben_dm_phases
205: WHERE ((migration_id = p_migration_id)
206: AND (phase_name = p_phase));
207:
208: --

Line 474: -- ben_dm_phases are checked to ensure that they have completed.

470:
471: -- ------------------------- update_migrations ------------------------
472: -- Description: Updates the status of the migration in the ben_dm_migrations
473: -- table. If the status is to be set to C then all child entries in
474: -- ben_dm_phases are checked to ensure that they have completed.
475: --
476: --
477: -- Input Parameters
478: -- p_new_status - new status code

Line 493: -- parent of ben_dm_phases

489: --
490: PROCEDURE update_migrations (p_new_status IN VARCHAR2, p_id IN NUMBER) IS
491: --
492: -- table is ben_dm_migrations
493: -- parent of ben_dm_phases
494: -- child of (none)
495:
496: l_parent_table_id NUMBER(9);
497: l_complete VARCHAR2(30);

Line 503: FROM ben_dm_phases

499:
500: -- search child table for all complete
501: CURSOR csr_child_table_complete IS
502: SELECT status
503: FROM ben_dm_phases
504: WHERE ((migration_id = p_id)
505: AND (status <> 'C'));
506:
507: --

Line 650: -- ben_dm_phases table. If the status is to be set to C or E then

646: END update_phase_items;
647: --
648: -- ------------------------- update_phases ----------------------
649: -- Description: Updates the status of the phase in the
650: -- ben_dm_phases table. If the status is to be set to C or E then
651: -- the update status is cascaded up to the parent phase. For a C,
652: -- the status of all the child rows in the ben_dm_phase_items is
653: -- checked.
654: --

Line 671: -- table is ben_dm_phases

667:
668: --
669: PROCEDURE update_phases (p_new_status IN VARCHAR2, p_id IN NUMBER) IS
670: --
671: -- table is ben_dm_phases
672: -- parent of ben_dm_phase_items
673: -- child of ben_dm_migrations
674:
675: l_parent_table_id NUMBER(9);

Line 690: FROM ben_dm_phases

686:
687: -- find parent table id
688: CURSOR csr_parent_id IS
689: SELECT migration_id
690: FROM ben_dm_phases
691: WHERE phase_id = p_id;
692:
693:
694: --

Line 712: UPDATE ben_dm_phases

708:
709: -- non-complete
710: IF (l_new_status IN('S', 'NS', 'E')) THEN
711: -- update the status for this row
712: UPDATE ben_dm_phases
713: SET status = l_new_status,
714: start_time = NVL(l_start_time, start_time)
715: WHERE phase_id = p_id;
716: COMMIT;

Line 729: UPDATE ben_dm_phases

725:
726: IF (csr_child_table_complete%NOTFOUND) THEN
727: -- update the status for this row since no child rows
728: -- are incomplete
729: UPDATE ben_dm_phases
730: SET status = l_new_status,
731: end_time = sysdate
732: WHERE phase_id = p_id;
733: COMMIT;

Line 867: ben_dm_phases ph

863:
864: CURSOR csr_c1 IS
865: SELECT phi.phase_item_id, group_order
866: FROM ben_dm_phase_items phi,
867: ben_dm_phases ph
868: WHERE (ph.migration_id = p_migration_id)
869: AND (ph.phase_name = 'DP')
870: AND (phi.phase_id = ph.phase_id)
871: AND (phi.status IN ('S', 'E'));

Line 918: -- Description: All entries in the ben_dm_phases and the

914: END rollback_download_master;
915: --
916:
917: -- ---------------------- rollback_init ------------------------
918: -- Description: All entries in the ben_dm_phases and the
919: -- ben_dm_phase_items table are deleted and the status of the
920: -- migration is reset to NS.
921: --
922: --

Line 940: FROM ben_dm_phases ph

936: l_phase_id NUMBER;
937:
938: CURSOR csr_c1 IS
939: SELECT ph.phase_id
940: FROM ben_dm_phases ph
941: WHERE (ph.migration_id = p_migration_id)
942: AND (ph.phase_name = 'I')
943: AND (ph.status IN ('S', 'E'));
944:

Line 962: DELETE FROM ben_dm_phases

958: DELETE FROM ben_dm_phase_items
959: WHERE phase_id = l_phase_id;
960:
961: -- delete information from hr_dm_phases
962: DELETE FROM ben_dm_phases
963: WHERE phase_id = l_phase_id;
964:
965: END LOOP;
966: CLOSE csr_c1;

Line 1009: ben_dm_phases ph

1005:
1006: CURSOR csr_c1 IS
1007: SELECT phi.phase_item_id
1008: FROM ben_dm_phase_items phi,
1009: ben_dm_phases ph
1010: WHERE (ph.migration_id = p_migration_id)
1011: AND (ph.phase_name = 'G')
1012: AND (phi.phase_id = ph.phase_id)
1013: AND (phi.status IN ('S', 'E'));

Line 1090: ben_dm_phases ph

1086:
1087: CURSOR csr_c1 IS
1088: SELECT phi.phase_item_id
1089: FROM ben_dm_phase_items phi,
1090: ben_dm_phases ph
1091: WHERE (ph.migration_id = p_migration_id)
1092: AND (ph.phase_name = 'UP')
1093: AND (phi.phase_id = ph.phase_id)
1094: AND (phi.status IN ('S', 'E'));