DBA Data[Home] [Help]

APPS.JA_CN_SI_EXPORT_PROG dependencies on FND_LOOKUP_VALUES

Line 252: lv_gle_req_phase fnd_lookup_values.meaning%TYPE;

248: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
249: lv_error_status BOOLEAN;
250:
251: ln_reqid_gle NUMBER;
252: lv_gle_req_phase fnd_lookup_values.meaning%TYPE;
253: lv_gle_req_status fnd_lookup_values.meaning%TYPE;
254: lv_gle_req_status_code fnd_lookup_values.lookup_code%TYPE;
255:
256: lv_error_flag VARCHAR2(1);

Line 253: lv_gle_req_status fnd_lookup_values.meaning%TYPE;

249: lv_error_status BOOLEAN;
250:
251: ln_reqid_gle NUMBER;
252: lv_gle_req_phase fnd_lookup_values.meaning%TYPE;
253: lv_gle_req_status fnd_lookup_values.meaning%TYPE;
254: lv_gle_req_status_code fnd_lookup_values.lookup_code%TYPE;
255:
256: lv_error_flag VARCHAR2(1);
257:

Line 254: lv_gle_req_status_code fnd_lookup_values.lookup_code%TYPE;

250:
251: ln_reqid_gle NUMBER;
252: lv_gle_req_phase fnd_lookup_values.meaning%TYPE;
253: lv_gle_req_status fnd_lookup_values.meaning%TYPE;
254: lv_gle_req_status_code fnd_lookup_values.lookup_code%TYPE;
255:
256: lv_error_flag VARCHAR2(1);
257:
258: ln_waiting_interval NUMBER :=10;

Line 342: fnd_lookup_values

338: lookup_code
339: INTO
340: lv_gle_req_status_code
341: FROM
342: fnd_lookup_values
343: WHERE lookup_type = 'CP_STATUS_CODE'
344: AND view_application_id=0
345: AND security_group_id=0
346: AND meaning=lv_gle_req_status