DBA Data[Home] [Help]

APPS.BEN_DM_MASTER dependencies on HR_DM_PHASE_RULES

Line 1043: -- The next phase to be process is found using the hr_dm_phase_rules table

1039: --
1040: -- The initialization code is called to set up various details (see the
1041: -- controller_init procedure).
1042: --
1043: -- The next phase to be process is found using the hr_dm_phase_rules table
1044: -- and the appropriate single or multi-threaded code is called.
1045: --
1046: -- If a multi-threaded process has spawned slaves then the main controller
1047: -- exits (to enable it to be awoken later). Otherwise it runs the next

Line 1105: FROM hr_dm_phase_rules

1101: l_db_loc VARCHAR2(30);
1102:
1103: CURSOR csr_phase_rule IS
1104: SELECT phase_name, next_phase, database_location
1105: FROM hr_dm_phase_rules
1106: WHERE ((migration_type = 'SP')
1107: AND (previous_phase = l_search_phase))
1108: AND database_location like l_db_loc;
1109:

Line 1112: FROM hr_dm_phase_rules

1108: AND database_location like l_db_loc;
1109:
1110: CURSOR csr_paused_phase_rule IS
1111: SELECT previous_phase, next_phase
1112: FROM hr_dm_phase_rules
1113: WHERE ((migration_type = 'SP')
1114: AND (phase_name = l_request_data));
1115:
1116: CURSOR csr_mig_status IS