290: lv_period_from VARCHAR2(100);
291: lv_period_to VARCHAR2(100);
292:
293: ln_reqid_gle NUMBER;
294: lv_gle_req_phase fnd_lookup_values.meaning%TYPE;
295: lv_gle_req_status fnd_lookup_values.meaning%TYPE;
296: lv_gle_req_status_code fnd_lookup_values.lookup_code%TYPE;
297:
298: lv_error_flag VARCHAR2(1);
291: lv_period_to VARCHAR2(100);
292:
293: ln_reqid_gle NUMBER;
294: lv_gle_req_phase fnd_lookup_values.meaning%TYPE;
295: lv_gle_req_status fnd_lookup_values.meaning%TYPE;
296: lv_gle_req_status_code fnd_lookup_values.lookup_code%TYPE;
297:
298: lv_error_flag VARCHAR2(1);
299:
292:
293: ln_reqid_gle NUMBER;
294: lv_gle_req_phase fnd_lookup_values.meaning%TYPE;
295: lv_gle_req_status fnd_lookup_values.meaning%TYPE;
296: lv_gle_req_status_code fnd_lookup_values.lookup_code%TYPE;
297:
298: lv_error_flag VARCHAR2(1);
299:
300: ln_waiting_interval NUMBER :=10;
446: lookup_code
447: INTO
448: lv_gle_req_status_code
449: FROM
450: fnd_lookup_values
451: WHERE lookup_type = 'CP_STATUS_CODE'
452: AND view_application_id=0
453: AND security_group_id=0
454: AND meaning=lv_gle_req_status