DBA Data[Home] [Help]

APPS.AP_CONC_PROG_PKG dependencies on FND_CONCURRENT

Line 57: X_call_status := FND_CONCURRENT.GET_REQUEST_STATUS(X_request_id,

53: -- FALSE if request is PENDING, RUNNING or INACTIVE
54: --
55: X_debug_info := 'Get payment batch concurrent request status';
56:
57: X_call_status := FND_CONCURRENT.GET_REQUEST_STATUS(X_request_id,
58: '',
59: '',
60: X_translated_phase,
61: X_translated_status,

Line 134: FROM fnd_concurrent_requests

130: -- Declare cursor to check concurrent program requests
131: --
132: CURSOR requests_cursor IS
133: SELECT request_id
134: FROM fnd_concurrent_requests
135: WHERE program_application_id = X_application_id
136: AND concurrent_program_id = X_program_id;
137:
138: BEGIN

Line 149: FROM fnd_concurrent_programs FCP, fnd_application FA

145: SELECT FCP.concurrent_program_id,
146: FCP.application_id
147: INTO X_program_id,
148: X_application_id
149: FROM fnd_concurrent_programs FCP, fnd_application FA
150: WHERE FA.application_short_name = X_application_name
151: AND FA.application_id = FCP.application_id
152: AND FCP.concurrent_program_name = X_program_name;
153:

Line 169: X_call_status := FND_CONCURRENT.GET_REQUEST_STATUS(X_request_id,

165: -- if request is PENDING or RUNNING
166: --
167: X_debug_info := 'Get concurrent request status';
168:
169: X_call_status := FND_CONCURRENT.GET_REQUEST_STATUS(X_request_id,
170: '',
171: '',
172: X_translated_phase,
173: X_translated_status,

Line 233: FROM fnd_concurrent_programs

229: X_debug_info := 'Get execution method code';
230:
231: SELECT execution_method_code
232: INTO X_execution_method
233: FROM fnd_concurrent_programs
234: WHERE application_id = 200
235: AND concurrent_program_name = X_program_name;
236:
237: EXCEPTION

Line 273: FROM fnd_concurrent_programs_vl

269: X_debug_info := 'Get SRS flag value';
270:
271: SELECT srs_flag
272: INTO X_srs_flag
273: FROM fnd_concurrent_programs_vl
274: WHERE application_id = 200
275: AND concurrent_program_name = X_program_name;
276:
277: EXCEPTION