eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JA_CN_APAR_EXPORT_PROG dependencies on FND_LOOKUP_VALUES

Line 236: lv_pre_phase fnd_lookup_values.meaning%TYPE;

232: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
233: lv_error_status BOOLEAN;
234:
235: ln_reqid_pre NUMBER;
236: lv_pre_phase fnd_lookup_values.meaning%TYPE;
237: lv_pre_status fnd_lookup_values.meaning%TYPE;
238: lv_pre_status_code fnd_lookup_values.lookup_code%TYPE;
239:
240: lv_error_flag VARCHAR2(1);

Line 237: lv_pre_status fnd_lookup_values.meaning%TYPE;

233: lv_error_status BOOLEAN;
234:
235: ln_reqid_pre NUMBER;
236: lv_pre_phase fnd_lookup_values.meaning%TYPE;
237: lv_pre_status fnd_lookup_values.meaning%TYPE;
238: lv_pre_status_code fnd_lookup_values.lookup_code%TYPE;
239:
240: lv_error_flag VARCHAR2(1);
241: ln_waiting_interval NUMBER :=10;

Line 238: lv_pre_status_code fnd_lookup_values.lookup_code%TYPE;

234:
235: ln_reqid_pre NUMBER;
236: lv_pre_phase fnd_lookup_values.meaning%TYPE;
237: lv_pre_status fnd_lookup_values.meaning%TYPE;
238: lv_pre_status_code fnd_lookup_values.lookup_code%TYPE;
239:
240: lv_error_flag VARCHAR2(1);
241: ln_waiting_interval NUMBER :=10;
242: lv_message VARCHAR2(1000);

Line 243: lv_dev_phase fnd_lookup_values.meaning%TYPE;

239:
240: lv_error_flag VARCHAR2(1);
241: ln_waiting_interval NUMBER :=10;
242: lv_message VARCHAR2(1000);
243: lv_dev_phase fnd_lookup_values.meaning%TYPE;
244: lv_dev_status fnd_lookup_values.meaning%TYPE;
245:
246: lv_output_file_name VARCHAR2(100);
247: ln_reqid_cvt NUMBER;

Line 244: lv_dev_status fnd_lookup_values.meaning%TYPE;

240: lv_error_flag VARCHAR2(1);
241: ln_waiting_interval NUMBER :=10;
242: lv_message VARCHAR2(1000);
243: lv_dev_phase fnd_lookup_values.meaning%TYPE;
244: lv_dev_status fnd_lookup_values.meaning%TYPE;
245:
246: lv_output_file_name VARCHAR2(100);
247: ln_reqid_cvt NUMBER;
248: lv_cvt_req_status fnd_lookup_values.meaning%TYPE;

Line 248: lv_cvt_req_status fnd_lookup_values.meaning%TYPE;

244: lv_dev_status fnd_lookup_values.meaning%TYPE;
245:
246: lv_output_file_name VARCHAR2(100);
247: ln_reqid_cvt NUMBER;
248: lv_cvt_req_status fnd_lookup_values.meaning%TYPE;
249:
250: ln_reqid_chg NUMBER;
251: lv_chg_req_status fnd_lookup_values.meaning%TYPE;
252:

Line 251: lv_chg_req_status fnd_lookup_values.meaning%TYPE;

247: ln_reqid_cvt NUMBER;
248: lv_cvt_req_status fnd_lookup_values.meaning%TYPE;
249:
250: ln_reqid_chg NUMBER;
251: lv_chg_req_status fnd_lookup_values.meaning%TYPE;
252:
253: ln_reqid_apv NUMBER;
254: lv_apv_req_phase fnd_lookup_values.meaning%TYPE;
255: lv_apv_req_status fnd_lookup_values.meaning%TYPE;

Line 254: lv_apv_req_phase fnd_lookup_values.meaning%TYPE;

250: ln_reqid_chg NUMBER;
251: lv_chg_req_status fnd_lookup_values.meaning%TYPE;
252:
253: ln_reqid_apv NUMBER;
254: lv_apv_req_phase fnd_lookup_values.meaning%TYPE;
255: lv_apv_req_status fnd_lookup_values.meaning%TYPE;
256: lv_apv_req_status_code fnd_lookup_values.lookup_code%TYPE;
257: lb_xml_layout BOOLEAN;
258:

Line 255: lv_apv_req_status fnd_lookup_values.meaning%TYPE;

251: lv_chg_req_status fnd_lookup_values.meaning%TYPE;
252:
253: ln_reqid_apv NUMBER;
254: lv_apv_req_phase fnd_lookup_values.meaning%TYPE;
255: lv_apv_req_status fnd_lookup_values.meaning%TYPE;
256: lv_apv_req_status_code fnd_lookup_values.lookup_code%TYPE;
257: lb_xml_layout BOOLEAN;
258:
259: ln_reqid_arv NUMBER;

Line 256: lv_apv_req_status_code fnd_lookup_values.lookup_code%TYPE;

252:
253: ln_reqid_apv NUMBER;
254: lv_apv_req_phase fnd_lookup_values.meaning%TYPE;
255: lv_apv_req_status fnd_lookup_values.meaning%TYPE;
256: lv_apv_req_status_code fnd_lookup_values.lookup_code%TYPE;
257: lb_xml_layout BOOLEAN;
258:
259: ln_reqid_arv NUMBER;
260: lv_arv_req_phase fnd_lookup_values.meaning%TYPE;

Line 260: lv_arv_req_phase fnd_lookup_values.meaning%TYPE;

256: lv_apv_req_status_code fnd_lookup_values.lookup_code%TYPE;
257: lb_xml_layout BOOLEAN;
258:
259: ln_reqid_arv NUMBER;
260: lv_arv_req_phase fnd_lookup_values.meaning%TYPE;
261: lv_arv_req_status fnd_lookup_values.meaning%TYPE;
262: lv_arv_req_status_code fnd_lookup_values.lookup_code%TYPE;
263:
264: lv_period_from VARCHAR2(20):= pv_period_from;

Line 261: lv_arv_req_status fnd_lookup_values.meaning%TYPE;

257: lb_xml_layout BOOLEAN;
258:
259: ln_reqid_arv NUMBER;
260: lv_arv_req_phase fnd_lookup_values.meaning%TYPE;
261: lv_arv_req_status fnd_lookup_values.meaning%TYPE;
262: lv_arv_req_status_code fnd_lookup_values.lookup_code%TYPE;
263:
264: lv_period_from VARCHAR2(20):= pv_period_from;
265: lv_period_to VARCHAR2(20):= pv_period_to;

Line 262: lv_arv_req_status_code fnd_lookup_values.lookup_code%TYPE;

258:
259: ln_reqid_arv NUMBER;
260: lv_arv_req_phase fnd_lookup_values.meaning%TYPE;
261: lv_arv_req_status fnd_lookup_values.meaning%TYPE;
262: lv_arv_req_status_code fnd_lookup_values.lookup_code%TYPE;
263:
264: lv_period_from VARCHAR2(20):= pv_period_from;
265: lv_period_to VARCHAR2(20):= pv_period_to;
266:

Line 383: fnd_lookup_values

379: lookup_code
380: INTO
381: lv_pre_status_code
382: FROM
383: fnd_lookup_values
384: WHERE lookup_type = 'CP_STATUS_CODE'
385: AND view_application_id=0
386: AND security_group_id=0
387: AND meaning=lv_pre_status

Line 462: fnd_lookup_values

458: lookup_code
459: INTO
460: lv_apv_req_status_code
461: FROM
462: fnd_lookup_values
463: WHERE lookup_type = 'CP_STATUS_CODE'
464: AND view_application_id=0
465: AND security_group_id=0
466: AND meaning=lv_apv_req_status

Line 512: fnd_lookup_values

508: lookup_code
509: INTO
510: lv_arv_req_status_code
511: FROM
512: fnd_lookup_values
513: WHERE lookup_type = 'CP_STATUS_CODE'
514: AND view_application_id=0
515: AND security_group_id=0
516: AND meaning=lv_arv_req_status