APPS.GHR_PROC_FUT_MT dependencies on GHR_MTS_TEMP

Line 119: FROM GHR_MTS_TEMP

115: WHERE pa_request_id = a.pa_request_id);
116:
117: CURSOR c_completion_status(c_session_id NUMBER) IS
118: SELECT max(completion_status) max_status
119: FROM GHR_MTS_TEMP
120: WHERE session_id = c_session_id;
121:
122: -- Declaration of Local variables
123: l_person_id per_all_people.person_id%type;

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

219: END IF;
220: --Bug#3726290 Add the separation Business Rule here.
221:
222: -- Insert values into the table
223: INSERT INTO GHR_MTS_TEMP(session_id, batch_no, pa_request_id, action_type)
224: VALUES(l_session_id,l_batch_no,l_c_futr_actions.pa_request_id, 'FUTURE');
225: l_person_id := l_c_futr_actions.person_id;
226: l_effective_date := l_c_futr_actions.effective_date;
227: l_batch_counter := l_batch_counter + 1;

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

320: l_batch_no := l_batch_no + 1;
321: l_batch_counter := 0;
322: END IF;
323: -- Insert values into the table
324: INSERT INTO GHR_MTS_TEMP(session_id, batch_no, pa_request_id, action_type)
325: VALUES(l_session_id,l_batch_no,l_c_futr_actions.pa_request_id, 'FUTURE');
326: l_person_id := l_c_futr_actions.person_id;
327: l_effective_date := l_c_futr_actions.effective_date;
328: l_batch_counter := l_batch_counter + 1;

Line 470: DELETE FROM GHR_MTS_TEMP

466: fnd_profile.put('PER_BUSINESS_GROUP_ID',l_curr_business_group_id);
467: end if;
468:
469: -- Delete the temporary table data.
470: DELETE FROM GHR_MTS_TEMP
471: WHERE session_id = l_session_id;
472:
473: COMMIT;
474:

Line 479: DELETE FROM GHR_MTS_TEMP

475: EXCEPTION
476: WHEN OTHERS THEN
477: p_retcode := 1;
478: p_errbuf := SQLERRM;
479: DELETE FROM GHR_MTS_TEMP
480: WHERE session_id = l_session_id;
481: COMMIT;
482:
483: END EXECUTE_MT;

Line 502: FROM GHR_MTS_TEMP

498: IS
499: CURSOR c_batch_mts(c_session_id IN NUMBER,
500: c_batch_no IN NUMBER) IS
501: SELECT pa_request_id, batch_no
502: FROM GHR_MTS_TEMP
503: WHERE session_id = c_session_id
504: AND batch_no = c_batch_no;
505:
506: CURSOR c_get_req(c_pa_request_id IN ghr_pa_requests.pa_request_id%type) IS

Line 837: UPDATE GHR_MTS_TEMP

833: p_retcode := 0;
834: END IF;
835:
836: -- Update the completion status.
837: UPDATE GHR_MTS_TEMP
838: SET completion_status = p_retcode
839: WHERE session_id = p_session_id
840: AND batch_no = p_batch_no;
841: