APPS.GHR_ELT_TO_BEN_PKG dependencies on GHR_MTS_TEMP

Line 38: FROM GHR_MTS_TEMP

34: AND hoi.org_information_context = 'GHR_US_ORG_INFORMATION';
35:
36: CURSOR c_completion_status(c_session_id NUMBER) IS
37: SELECT max(completion_status) max_status
38: FROM GHR_MTS_TEMP
39: WHERE session_id = c_session_id;
40:
41: -- Declaration of Local variables
42: l_batch_size NUMBER;

Line 119: INSERT INTO GHR_MTS_TEMP(session_id, batch_no, pa_request_id, action_type)

115: l_batch_no := l_batch_no + 1;
116: l_batch_counter := 0;
117: END IF;
118: -- Insert values into the table
119: INSERT INTO GHR_MTS_TEMP(session_id, batch_no, pa_request_id, action_type)
120: VALUES(l_session_id,l_batch_no,l_c_per_records.person_id, NULL);
121: l_batch_counter := l_batch_counter + 1;
122: END IF;
123: END LOOP;

Line 195: DELETE FROM GHR_MTS_TEMP

191: --
192: END IF;
193:
194: -- Delete the temporary table data.
195: DELETE FROM GHR_MTS_TEMP
196: WHERE session_id = l_session_id;
197:
198: COMMIT;
199:

Line 204: DELETE FROM GHR_MTS_TEMP

200: EXCEPTION
201: WHEN OTHERS THEN
202: p_retcode := 1;
203: p_errbuf := SQLERRM;
204: DELETE FROM GHR_MTS_TEMP
205: WHERE session_id = l_session_id;
206: COMMIT;
207: END EXECUTE_CONV_MT;
208:

Line 251: FROM GHR_MTS_TEMP

247: -- Cursor to pick person records of Federal Persons
248: CURSOR c_batch_persons(c_session_id IN NUMBER,
249: c_batch_no IN NUMBER) IS
250: SELECT pa_request_id person_id, batch_no
251: FROM GHR_MTS_TEMP
252: WHERE session_id = c_session_id
253: AND batch_no = c_batch_no;
254:
255: CURSOR c_sessionid is

Line 587: UPDATE GHR_MTS_TEMP

583: p_errbuf := 'Process Completed Successfully';
584: END IF;
585:
586: -- Update the completion status.
587: UPDATE GHR_MTS_TEMP
588: SET completion_status = p_retcode
589: WHERE session_id = p_session_id
590: AND batch_no = p_batch_no;
591: