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 248: FROM GHR_MTS_TEMP

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

Line 580: UPDATE GHR_MTS_TEMP

576: p_errbuf := 'Process Completed Successfully';
577: END IF;
578:
579: -- Update the completion status.
580: UPDATE GHR_MTS_TEMP
581: SET completion_status = p_retcode
582: WHERE session_id = p_session_id
583: AND batch_no = p_batch_no;
584: