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 229: INSERT INTO GHR_MTS_TEMP(session_id, batch_no, pa_request_id, action_type)

225: END IF;
226: --Bug#3726290 Add the separation Business Rule here.
227:
228: -- Insert values into the table
229: INSERT INTO GHR_MTS_TEMP(session_id, batch_no, pa_request_id, action_type)
230: VALUES(l_session_id,l_batch_no,l_c_futr_actions.pa_request_id, 'FUTURE');
231: l_person_id := l_c_futr_actions.person_id;
232: l_effective_date := l_c_futr_actions.effective_date;
233: l_batch_counter := l_batch_counter + 1;

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

332: l_batch_no := l_batch_no + 1;
333: l_batch_counter := 0;
334: END IF;
335: -- Insert values into the table
336: INSERT INTO GHR_MTS_TEMP(session_id, batch_no, pa_request_id, action_type)
337: VALUES(l_session_id,l_batch_no,l_c_futr_actions.pa_request_id, 'FUTURE');
338: l_person_id := l_c_futr_actions.person_id;
339: l_effective_date := l_c_futr_actions.effective_date;
340: l_batch_counter := l_batch_counter + 1;

Line 484: DELETE FROM GHR_MTS_TEMP

480: fnd_profile.put('PER_BUSINESS_GROUP_ID',l_curr_business_group_id);
481: end if;
482:
483: -- Delete the temporary table data.
484: DELETE FROM GHR_MTS_TEMP
485: WHERE session_id = l_session_id;
486:
487: COMMIT;
488:

Line 493: DELETE FROM GHR_MTS_TEMP

489: EXCEPTION
490: WHEN OTHERS THEN
491: p_retcode := 1;
492: p_errbuf := SQLERRM;
493: DELETE FROM GHR_MTS_TEMP
494: WHERE session_id = l_session_id;
495: COMMIT;
496:
497: END EXECUTE_MT;

Line 516: FROM GHR_MTS_TEMP

512: IS
513: CURSOR c_batch_mts(c_session_id IN NUMBER,
514: c_batch_no IN NUMBER) IS
515: SELECT pa_request_id, batch_no
516: FROM GHR_MTS_TEMP
517: WHERE session_id = c_session_id
518: AND batch_no = c_batch_no;
519:
520: CURSOR c_get_req(c_pa_request_id IN ghr_pa_requests.pa_request_id%type) IS

Line 859: UPDATE GHR_MTS_TEMP

855: p_retcode := 0;
856: END IF;
857:
858: -- Update the completion status.
859: UPDATE GHR_MTS_TEMP
860: SET completion_status = p_retcode
861: WHERE session_id = p_session_id
862: AND batch_no = p_batch_no;
863: