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

Line 222: lv_gle_req_phase fnd_lookup_values.meaning%TYPE;

218: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
219: lv_error_status BOOLEAN;
220:
221: ln_reqid_gle NUMBER;
222: lv_gle_req_phase fnd_lookup_values.meaning%TYPE;
223: lv_gle_req_status fnd_lookup_values.meaning%TYPE;
224: lv_gle_req_status_code fnd_lookup_values.lookup_code%TYPE;
225:
226: lv_error_flag VARCHAR2(1);

Line 223: lv_gle_req_status fnd_lookup_values.meaning%TYPE;

219: lv_error_status BOOLEAN;
220:
221: ln_reqid_gle NUMBER;
222: lv_gle_req_phase fnd_lookup_values.meaning%TYPE;
223: lv_gle_req_status fnd_lookup_values.meaning%TYPE;
224: lv_gle_req_status_code fnd_lookup_values.lookup_code%TYPE;
225:
226: lv_error_flag VARCHAR2(1);
227: ln_waiting_interval NUMBER := 10;

Line 224: lv_gle_req_status_code fnd_lookup_values.lookup_code%TYPE;

220:
221: ln_reqid_gle NUMBER;
222: lv_gle_req_phase fnd_lookup_values.meaning%TYPE;
223: lv_gle_req_status fnd_lookup_values.meaning%TYPE;
224: lv_gle_req_status_code fnd_lookup_values.lookup_code%TYPE;
225:
226: lv_error_flag VARCHAR2(1);
227: ln_waiting_interval NUMBER := 10;
228: lv_dev_phase VARCHAR2(100);

Line 330: FROM fnd_lookup_values

326: message => lv_message) THEN
327: --To get lookup code for current status
328: SELECT lookup_code
329: INTO lv_gle_req_status_code
330: FROM fnd_lookup_values
331: WHERE lookup_type = 'CP_STATUS_CODE'
332: AND view_application_id = 0
333: AND security_group_id = 0
334: AND meaning = lv_gle_req_status