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_GL_EXPORT_REPORT_PROG dependencies on FND_LOOKUP_VALUES

Line 123: lv_gle_req_phase fnd_lookup_values.meaning%TYPE;

119: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
120: lv_error_status BOOLEAN;
121:
122: ln_reqid_gle NUMBER;
123: lv_gle_req_phase fnd_lookup_values.meaning%TYPE;
124: lv_gle_req_status fnd_lookup_values.meaning%TYPE;
125: lv_gle_req_status_code fnd_lookup_values.lookup_code%TYPE;
126:
127: lv_error_flag VARCHAR2(1);

Line 124: lv_gle_req_status fnd_lookup_values.meaning%TYPE;

120: lv_error_status BOOLEAN;
121:
122: ln_reqid_gle NUMBER;
123: lv_gle_req_phase fnd_lookup_values.meaning%TYPE;
124: lv_gle_req_status fnd_lookup_values.meaning%TYPE;
125: lv_gle_req_status_code fnd_lookup_values.lookup_code%TYPE;
126:
127: lv_error_flag VARCHAR2(1);
128: ln_waiting_interval NUMBER :=10;

Line 125: lv_gle_req_status_code fnd_lookup_values.lookup_code%TYPE;

121:
122: ln_reqid_gle NUMBER;
123: lv_gle_req_phase fnd_lookup_values.meaning%TYPE;
124: lv_gle_req_status fnd_lookup_values.meaning%TYPE;
125: lv_gle_req_status_code fnd_lookup_values.lookup_code%TYPE;
126:
127: lv_error_flag VARCHAR2(1);
128: ln_waiting_interval NUMBER :=10;
129: lv_dev_phase VARCHAR2(100);

Line 141: lv_comb_req_phase fnd_lookup_values.meaning%TYPE;

137: lv_chg_req_status VARCHAR2(100);
138:
139: ln_convert_reqid NUMBER;
140: ln_reqid_comb NUMBER;
141: lv_comb_req_phase fnd_lookup_values.meaning%TYPE;
142: lv_comb_req_status fnd_lookup_values.meaning%TYPE;
143: lv_comb_req_status_code fnd_lookup_values.lookup_code%TYPE;
144: lv_output_file_name VARCHAR2(100);
145: lv_accounting_date VARCHAR2(30) := pv_accounting_date;

Line 142: lv_comb_req_status fnd_lookup_values.meaning%TYPE;

138:
139: ln_convert_reqid NUMBER;
140: ln_reqid_comb NUMBER;
141: lv_comb_req_phase fnd_lookup_values.meaning%TYPE;
142: lv_comb_req_status fnd_lookup_values.meaning%TYPE;
143: lv_comb_req_status_code fnd_lookup_values.lookup_code%TYPE;
144: lv_output_file_name VARCHAR2(100);
145: lv_accounting_date VARCHAR2(30) := pv_accounting_date;
146: lv_period_from VARCHAR2(20):= pv_period_from;

Line 143: lv_comb_req_status_code fnd_lookup_values.lookup_code%TYPE;

139: ln_convert_reqid NUMBER;
140: ln_reqid_comb NUMBER;
141: lv_comb_req_phase fnd_lookup_values.meaning%TYPE;
142: lv_comb_req_status fnd_lookup_values.meaning%TYPE;
143: lv_comb_req_status_code fnd_lookup_values.lookup_code%TYPE;
144: lv_output_file_name VARCHAR2(100);
145: lv_accounting_date VARCHAR2(30) := pv_accounting_date;
146: lv_period_from VARCHAR2(20):= pv_period_from;
147: lv_period_to VARCHAR2(20):= pv_period_to;

Line 335: fnd_lookup_values

331: lookup_code
332: INTO
333: lv_gle_req_status_code
334: FROM
335: fnd_lookup_values
336: WHERE lookup_type = 'CP_STATUS_CODE'
337: AND view_application_id=0
338: AND security_group_id=0
339: AND meaning=lv_gle_req_status

Line 424: fnd_lookup_values

420: lookup_code
421: INTO
422: lv_comb_req_status_code
423: FROM
424: fnd_lookup_values
425: WHERE lookup_type = 'CP_STATUS_CODE'
426: AND view_application_id=0
427: AND security_group_id=0
428: AND meaning=lv_comb_req_status --Fixing bug 9547791