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

Line 119: lv_gle_req_phase fnd_lookup_values.meaning%TYPE;

115: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
116: lv_error_status BOOLEAN;
117:
118: ln_reqid_gle NUMBER;
119: lv_gle_req_phase fnd_lookup_values.meaning%TYPE;
120: lv_gle_req_status fnd_lookup_values.meaning%TYPE;
121: lv_gle_req_status_code fnd_lookup_values.lookup_code%TYPE;
122:
123: lv_error_flag VARCHAR2(1);

Line 120: lv_gle_req_status fnd_lookup_values.meaning%TYPE;

116: lv_error_status BOOLEAN;
117:
118: ln_reqid_gle NUMBER;
119: lv_gle_req_phase fnd_lookup_values.meaning%TYPE;
120: lv_gle_req_status fnd_lookup_values.meaning%TYPE;
121: lv_gle_req_status_code fnd_lookup_values.lookup_code%TYPE;
122:
123: lv_error_flag VARCHAR2(1);
124: ln_waiting_interval NUMBER := 10;

Line 121: lv_gle_req_status_code fnd_lookup_values.lookup_code%TYPE;

117:
118: ln_reqid_gle NUMBER;
119: lv_gle_req_phase fnd_lookup_values.meaning%TYPE;
120: lv_gle_req_status fnd_lookup_values.meaning%TYPE;
121: lv_gle_req_status_code fnd_lookup_values.lookup_code%TYPE;
122:
123: lv_error_flag VARCHAR2(1);
124: ln_waiting_interval NUMBER := 10;
125: lv_dev_phase VARCHAR2(100);

Line 137: lv_comb_req_phase fnd_lookup_values.meaning%TYPE;

133: lv_chg_req_status VARCHAR2(100);
134:
135: ln_convert_reqid NUMBER;
136: ln_reqid_comb NUMBER;
137: lv_comb_req_phase fnd_lookup_values.meaning%TYPE;
138: lv_comb_req_status fnd_lookup_values.meaning%TYPE;
139: lv_comb_req_status_code fnd_lookup_values.lookup_code%TYPE;
140: lv_output_file_name VARCHAR2(100);
141: lv_accounting_date VARCHAR2(30) := pv_accounting_date;

Line 138: lv_comb_req_status fnd_lookup_values.meaning%TYPE;

134:
135: ln_convert_reqid NUMBER;
136: ln_reqid_comb NUMBER;
137: lv_comb_req_phase fnd_lookup_values.meaning%TYPE;
138: lv_comb_req_status fnd_lookup_values.meaning%TYPE;
139: lv_comb_req_status_code fnd_lookup_values.lookup_code%TYPE;
140: lv_output_file_name VARCHAR2(100);
141: lv_accounting_date VARCHAR2(30) := pv_accounting_date;
142: lv_period_from VARCHAR2(20) := pv_period_from;

Line 139: lv_comb_req_status_code fnd_lookup_values.lookup_code%TYPE;

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

Line 348: FROM fnd_lookup_values

344:
345: --To get lookup code for current status
346: SELECT lookup_code
347: INTO lv_gle_req_status_code
348: FROM fnd_lookup_values
349: WHERE lookup_type = 'CP_STATUS_CODE'
350: AND view_application_id = 0
351: AND security_group_id = 0
352: AND meaning = lv_gle_req_status

Line 428: FROM fnd_lookup_values

424:
425: --To get lookup code for current status
426: SELECT lookup_code
427: INTO lv_comb_req_status_code
428: FROM fnd_lookup_values
429: WHERE lookup_type = 'CP_STATUS_CODE'
430: AND view_application_id = 0
431: AND security_group_id = 0
432: AND meaning = lv_comb_req_status --Fixing bug 9547791