APPS.BEN_DM_UTILITY dependencies on BEN_DM_PHASE_ITEMS

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

562: END update_migrations;
563: --
564: -- ------------------------- update_phase_items ----------------------
565: -- Description: Updates the status of the phase item in the
566: -- ben_dm_phase_items table. If the status is to be set to C or E then
567: -- the update status is cascaded up to the parent phase.
568: --
569: --
570: -- Input Parameters

Line 596: FROM ben_dm_phase_items

592:
593: -- find parent table id
594: CURSOR csr_parent_id IS
595: SELECT phase_id
596: FROM ben_dm_phase_items
597: WHERE phase_item_id = p_id;
598:
599:
600: --

Line 619: UPDATE ben_dm_phase_items

615: l_end_time := sysdate;
616: END IF;
617:
618: -- update the status for this row
619: UPDATE ben_dm_phase_items
620: SET status = p_new_status,
621: start_time = NVL(l_start_time, start_time),
622: end_time = NVL(l_end_time, end_time)
623: WHERE phase_item_id = p_id;

Line 652: -- the status of all the child rows in the ben_dm_phase_items is

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: --
655: --
656: -- Input Parameters

Line 672: -- parent of ben_dm_phase_items

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);
676: l_complete VARCHAR2(30);

Line 683: FROM ben_dm_phase_items

679:
680: -- search child table for all complete
681: CURSOR csr_child_table_complete IS
682: SELECT status
683: FROM ben_dm_phase_items
684: WHERE ((phase_id = p_id)
685: AND (status <> 'C'));
686:
687: -- find parent table id

Line 866: FROM ben_dm_phase_items phi,

862: l_phase_id NUMBER;
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)

Line 919: -- ben_dm_phase_items table are deleted and the status of the

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: --
923: -- Input Parameters

Line 958: DELETE FROM ben_dm_phase_items

954: LOOP
955: FETCH csr_c1 INTO l_phase_id;
956: EXIT WHEN csr_c1%NOTFOUND;
957: -- delete all entries in hr_dm_phase_items
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

Line 988: -- Description: All entries in the ben_dm_phase_items table for the generator

984: --
985:
986: --
987: -- ---------------------------- rollback_generator -------------------------
988: -- Description: All entries in the ben_dm_phase_items table for the generator
989: -- phase are reset to NS.
990: --
991: --
992: -- Input Parameters

Line 1008: FROM ben_dm_phase_items phi,

1004: --
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)

Line 1069: -- Description: All entries in the ben_dm_phase_items table for the upload

1065: -- ------------------------------------------------------------------------
1066:
1067: --
1068: -- ---------------------------- rollback_upload -------------------------
1069: -- Description: All entries in the ben_dm_phase_items table for the upload
1070: -- phase are reset to NS.
1071: --
1072: --
1073: -- Input Parameters

Line 1089: FROM ben_dm_phase_items phi,

1085: --
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)