DBA Data[Home] [Help]

APPS.JA_CN_PS_SI_EXPORT_PKG dependencies on FND_LOOKUP_VALUES

Line 290: lv_gle_req_phase fnd_lookup_values.meaning%TYPE;

286: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
287: lv_error_status BOOLEAN;
288:
289: ln_reqid_gle NUMBER;
290: lv_gle_req_phase fnd_lookup_values.meaning%TYPE;
291: lv_gle_req_status fnd_lookup_values.meaning%TYPE;
292: lv_gle_req_status_code fnd_lookup_values.lookup_code%TYPE;
293:
294: lv_error_flag VARCHAR2(1);

Line 291: lv_gle_req_status fnd_lookup_values.meaning%TYPE;

287: lv_error_status BOOLEAN;
288:
289: ln_reqid_gle NUMBER;
290: lv_gle_req_phase fnd_lookup_values.meaning%TYPE;
291: lv_gle_req_status fnd_lookup_values.meaning%TYPE;
292: lv_gle_req_status_code fnd_lookup_values.lookup_code%TYPE;
293:
294: lv_error_flag VARCHAR2(1);
295:

Line 292: lv_gle_req_status_code fnd_lookup_values.lookup_code%TYPE;

288:
289: ln_reqid_gle NUMBER;
290: lv_gle_req_phase fnd_lookup_values.meaning%TYPE;
291: lv_gle_req_status fnd_lookup_values.meaning%TYPE;
292: lv_gle_req_status_code fnd_lookup_values.lookup_code%TYPE;
293:
294: lv_error_flag VARCHAR2(1);
295:
296: ln_waiting_interval NUMBER :=10;

Line 375: fnd_lookup_values

371: lookup_code
372: INTO
373: lv_gle_req_status_code
374: FROM
375: fnd_lookup_values
376: WHERE lookup_type = 'CP_STATUS_CODE'
377: AND view_application_id=0
378: AND security_group_id=0
379: AND meaning=lv_gle_req_status