APPS.HXC_RDB_PROCESS dependencies on FND_REQUEST

Line 37: FND_REQUEST.SUBMIT_REQUEST(application => 'PER'

33:
34: IF p_application = 'PAY'
35: THEN
36: l_request_id :=
37: FND_REQUEST.SUBMIT_REQUEST(application => 'PER'
38: ,program => 'PYTSHPRI'
39: ,description => NULL
40: ,sub_request => FALSE
41: ,argument1 => FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')

Line 106: FND_REQUEST.SET_ORG_ID(FND_PROFILE.VALUE('ORG_ID'));

102: END IF;
103:
104: IF p_application = 'PA'
105: THEN
106: FND_REQUEST.SET_ORG_ID(FND_PROFILE.VALUE('ORG_ID'));
107: l_request_id :=
108: FND_REQUEST.SUBMIT_REQUEST(application => 'PA'
109: ,program => 'PAXTRTRX'
110: ,description => NULL

Line 108: FND_REQUEST.SUBMIT_REQUEST(application => 'PA'

104: IF p_application = 'PA'
105: THEN
106: FND_REQUEST.SET_ORG_ID(FND_PROFILE.VALUE('ORG_ID'));
107: l_request_id :=
108: FND_REQUEST.SUBMIT_REQUEST(application => 'PA'
109: ,program => 'PAXTRTRX'
110: ,description => NULL
111: ,sub_request => FALSE
112: ,argument1 => 'ORACLE TIME AND LABOR'

Line 210: AND rdb.request_id = fnd.request_id

206: ROWIDTOCHAR(rdb.rowid)
207: FROM hxc_rdb_processes rdb,
208: fnd_concurrent_requests fnd
209: WHERE rdb.ret_user_id = FND_GLOBAL.user_id
210: AND rdb.request_id = fnd.request_id
211: AND fnd.requested_by = rdb.ret_user_id
212: AND rdb.phase <> 'C';
213:
214: TYPE VARCHARTABLE IS TABLE OF VARCHAR2(50);

Line 211: AND fnd.requested_by = rdb.ret_user_id

207: FROM hxc_rdb_processes rdb,
208: fnd_concurrent_requests fnd
209: WHERE rdb.ret_user_id = FND_GLOBAL.user_id
210: AND rdb.request_id = fnd.request_id
211: AND fnd.requested_by = rdb.ret_user_id
212: AND rdb.phase <> 'C';
213:
214: TYPE VARCHARTABLE IS TABLE OF VARCHAR2(50);
215: TYPE DATETABLE IS TABLE OF DATE;