DBA Data[Home] [Help]

APPS.JA_CN_PS_GL_EXPORT_PROG dependencies on FND_LOOKUP_VALUES

Line 305: lv_gle_req_phase fnd_lookup_values.meaning%TYPE;

301: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
302: lv_error_status BOOLEAN;
303:
304: ln_reqid_gle NUMBER;
305: lv_gle_req_phase fnd_lookup_values.meaning%TYPE;
306: lv_gle_req_status fnd_lookup_values.meaning%TYPE;
307: lv_gle_req_status_code fnd_lookup_values.lookup_code%TYPE;
308:
309: lv_error_flag VARCHAR2(1);

Line 306: lv_gle_req_status fnd_lookup_values.meaning%TYPE;

302: lv_error_status BOOLEAN;
303:
304: ln_reqid_gle NUMBER;
305: lv_gle_req_phase fnd_lookup_values.meaning%TYPE;
306: lv_gle_req_status fnd_lookup_values.meaning%TYPE;
307: lv_gle_req_status_code fnd_lookup_values.lookup_code%TYPE;
308:
309: lv_error_flag VARCHAR2(1);
310: ln_waiting_interval NUMBER :=10;

Line 307: lv_gle_req_status_code fnd_lookup_values.lookup_code%TYPE;

303:
304: ln_reqid_gle NUMBER;
305: lv_gle_req_phase fnd_lookup_values.meaning%TYPE;
306: lv_gle_req_status fnd_lookup_values.meaning%TYPE;
307: lv_gle_req_status_code fnd_lookup_values.lookup_code%TYPE;
308:
309: lv_error_flag VARCHAR2(1);
310: ln_waiting_interval NUMBER :=10;
311: lv_dev_phase VARCHAR2(100);

Line 323: lv_comb_req_phase fnd_lookup_values.meaning%TYPE;

319: lv_chg_req_status VARCHAR2(100);
320:
321: ln_convert_reqid NUMBER;
322: ln_reqid_comb NUMBER;
323: lv_comb_req_phase fnd_lookup_values.meaning%TYPE;
324: lv_comb_req_status fnd_lookup_values.meaning%TYPE;
325: lv_comb_req_status_code fnd_lookup_values.lookup_code%TYPE;
326: lv_output_file_name VARCHAR2(100);
327: lv_period_from VARCHAR2(20):= pv_period_from;

Line 324: lv_comb_req_status fnd_lookup_values.meaning%TYPE;

320:
321: ln_convert_reqid NUMBER;
322: ln_reqid_comb NUMBER;
323: lv_comb_req_phase fnd_lookup_values.meaning%TYPE;
324: lv_comb_req_status fnd_lookup_values.meaning%TYPE;
325: lv_comb_req_status_code fnd_lookup_values.lookup_code%TYPE;
326: lv_output_file_name VARCHAR2(100);
327: lv_period_from VARCHAR2(20):= pv_period_from;
328: lv_period_to VARCHAR2(20):= pv_period_to;

Line 325: lv_comb_req_status_code fnd_lookup_values.lookup_code%TYPE;

321: ln_convert_reqid NUMBER;
322: ln_reqid_comb NUMBER;
323: lv_comb_req_phase fnd_lookup_values.meaning%TYPE;
324: lv_comb_req_status fnd_lookup_values.meaning%TYPE;
325: lv_comb_req_status_code fnd_lookup_values.lookup_code%TYPE;
326: lv_output_file_name VARCHAR2(100);
327: lv_period_from VARCHAR2(20):= pv_period_from;
328: lv_period_to VARCHAR2(20):= pv_period_to;
329: lv_accounting_date VARCHAR2(30) := NULL;

Line 510: fnd_lookup_values

506: lookup_code
507: INTO
508: lv_gle_req_status_code
509: FROM
510: fnd_lookup_values
511: WHERE lookup_type = 'CP_STATUS_CODE'
512: AND view_application_id=0
513: AND security_group_id=0
514: AND meaning=lv_gle_req_status

Line 584: fnd_lookup_values

580: lookup_code
581: INTO
582: lv_comb_req_status_code
583: FROM
584: fnd_lookup_values
585: WHERE lookup_type = 'CP_STATUS_CODE'
586: AND view_application_id=0
587: AND security_group_id=0
588: AND meaning=lv_comb_req_status --Fixing bug 9547791