APPS.HR_DM_UPLOAD dependencies on HR_DM_PHASE_ITEMS

Line 87: -- hr_dm_phase_items table for the upload phase. It spawns the slave process

83: /*---------------------------- PUBLIC ROUTINES ------------------------------*/
84:
85: -- ------------------------- main ------------------------
86: -- Description: This is the upload phase slave. It reads an item from the
87: -- hr_dm_phase_items table for the upload phase. It spawns the slave process
88: -- to start data pump which in turns spawns multiple processes to process
89: -- a batch or group of table. If the group is uploaded succesfully, then the
90: -- above process is repeated for an unprocessed batch to be uploaded from
91: -- hr_dm_phase_items table. When all the upload batches are finished in

Line 91: -- hr_dm_phase_items table. When all the upload batches are finished in

87: -- hr_dm_phase_items table for the upload phase. It spawns the slave process
88: -- to start data pump which in turns spawns multiple processes to process
89: -- a batch or group of table. If the group is uploaded succesfully, then the
90: -- above process is repeated for an unprocessed batch to be uploaded from
91: -- hr_dm_phase_items table. When all the upload batches are finished in
92: -- hr_dm_phase_items table then the processing is stopped.
93: --
94: --
95: -- Input Parameters

Line 92: -- hr_dm_phase_items table then the processing is stopped.

88: -- to start data pump which in turns spawns multiple processes to process
89: -- a batch or group of table. If the group is uploaded succesfully, then the
90: -- above process is repeated for an unprocessed batch to be uploaded from
91: -- hr_dm_phase_items table. When all the upload batches are finished in
92: -- hr_dm_phase_items table then the processing is stopped.
93: --
94: --
95: -- Input Parameters
96: -- p_migration_id - of current migration

Line 150: FROM hr_dm_phase_items pi,

146: CURSOR csr_get_pi IS
147: SELECT pi.phase_item_id,
148: pi.status,
149: pi.batch_id
150: FROM hr_dm_phase_items pi,
151: hr_dm_application_groups apg
152: WHERE pi.status = 'NS'
153: AND pi.phase_id = l_phase_id
154: AND pi.group_id = apg.group_id

Line 163: hr_dm_phase_items pi

159: CURSOR csr_req_id IS
160: SELECT req.request_id,
161: pi.batch_id
162: FROM hr_dm_migration_requests req,
163: hr_dm_phase_items pi
164: WHERE pi.phase_item_id = l_phase_item_id
165: and pi.phase_item_id = req.phase_item_id;
166:
167: