APPS.JA_CN_FSG_XML_BANK_PKG dependencies on FND_LOOKUP_VALUES

Line 130: lv_fsg_req_phase fnd_lookup_values.meaning%TYPE;

126:
127: req_id NUMBER;
128: rep_run_type rg_report_content_sets.report_run_type%TYPE;
129: L_COMPANY_NAME VARCHAR2(100) :=X_BSV;
130: lv_fsg_req_phase fnd_lookup_values.meaning%TYPE;
131: lv_fsg_req_status fnd_lookup_values.meaning%TYPE;
132: lv_fsg_req_status_code fnd_lookup_values.lookup_code%TYPE;
133: ln_waiting_interval number:=10;
134: lv_dev_phase VARCHAR2(100);

Line 131: lv_fsg_req_status fnd_lookup_values.meaning%TYPE;

127: req_id NUMBER;
128: rep_run_type rg_report_content_sets.report_run_type%TYPE;
129: L_COMPANY_NAME VARCHAR2(100) :=X_BSV;
130: lv_fsg_req_phase fnd_lookup_values.meaning%TYPE;
131: lv_fsg_req_status fnd_lookup_values.meaning%TYPE;
132: lv_fsg_req_status_code fnd_lookup_values.lookup_code%TYPE;
133: ln_waiting_interval number:=10;
134: lv_dev_phase VARCHAR2(100);
135: lv_dev_status VARCHAR2(100);

Line 132: lv_fsg_req_status_code fnd_lookup_values.lookup_code%TYPE;

128: rep_run_type rg_report_content_sets.report_run_type%TYPE;
129: L_COMPANY_NAME VARCHAR2(100) :=X_BSV;
130: lv_fsg_req_phase fnd_lookup_values.meaning%TYPE;
131: lv_fsg_req_status fnd_lookup_values.meaning%TYPE;
132: lv_fsg_req_status_code fnd_lookup_values.lookup_code%TYPE;
133: ln_waiting_interval number:=10;
134: lv_dev_phase VARCHAR2(100);
135: lv_dev_status VARCHAR2(100);
136: lv_message VARCHAR2(1000);

Line 339: FROM fnd_lookup_values

335: message => lv_message);
336:
337: SELECT lookup_code
338: INTO lv_fsg_req_status_code
339: FROM fnd_lookup_values
340: WHERE lookup_type = 'CP_STATUS_CODE'
341: AND view_application_id = 0
342: AND security_group_id = 0
343: AND meaning = lv_fsg_req_status

Line 942: lv_convert_req_phase fnd_lookup_values.meaning%TYPE;

938: lv_message VARCHAR2(1000);
939:
940: ln_reqid_convert NUMBER;
941:
942: lv_convert_req_phase fnd_lookup_values.meaning%TYPE;
943: lv_convert_req_status fnd_lookup_values.meaning%TYPE;
944: lv_convert_req_status_code fnd_lookup_values.lookup_code%TYPE;
945:
946: BEGIN

Line 943: lv_convert_req_status fnd_lookup_values.meaning%TYPE;

939:
940: ln_reqid_convert NUMBER;
941:
942: lv_convert_req_phase fnd_lookup_values.meaning%TYPE;
943: lv_convert_req_status fnd_lookup_values.meaning%TYPE;
944: lv_convert_req_status_code fnd_lookup_values.lookup_code%TYPE;
945:
946: BEGIN
947: FND_FILE.PUT_LINE(FND_FILE.LOG, 'FSG Begin:');

Line 944: lv_convert_req_status_code fnd_lookup_values.lookup_code%TYPE;

940: ln_reqid_convert NUMBER;
941:
942: lv_convert_req_phase fnd_lookup_values.meaning%TYPE;
943: lv_convert_req_status fnd_lookup_values.meaning%TYPE;
944: lv_convert_req_status_code fnd_lookup_values.lookup_code%TYPE;
945:
946: BEGIN
947: FND_FILE.PUT_LINE(FND_FILE.LOG, 'FSG Begin:');
948: --log for debug

Line 1602: FROM fnd_lookup_values

1598: message => lv_message) THEN
1599: --To get lookup code for current status
1600: SELECT lookup_code
1601: INTO lv_convert_req_status_code
1602: FROM fnd_lookup_values
1603: WHERE lookup_type = 'CP_STATUS_CODE'
1604: AND view_application_id = 0
1605: AND security_group_id = 0
1606: AND meaning = lv_convert_req_status