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);
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:
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;
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