eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JA_CN_PS_FSG_XML_SUBMIT_PROG dependencies on FND_LOOKUP_VALUES

Line 135: lv_fsg_req_phase fnd_lookup_values.meaning%TYPE;

131: lv_dev_status VARCHAR2(100);
132: lv_message VARCHAR2(1000);
133: lb_xml_layout BOOLEAN;
134:
135: lv_fsg_req_phase fnd_lookup_values.meaning%TYPE;
136: lv_fsg_req_status fnd_lookup_values.meaning%TYPE;
137: lv_fsg_req_status_code fnd_lookup_values.lookup_code%TYPE;
138:
139: ln_reqid_convert NUMBER;

Line 136: lv_fsg_req_status fnd_lookup_values.meaning%TYPE;

132: lv_message VARCHAR2(1000);
133: lb_xml_layout BOOLEAN;
134:
135: lv_fsg_req_phase fnd_lookup_values.meaning%TYPE;
136: lv_fsg_req_status fnd_lookup_values.meaning%TYPE;
137: lv_fsg_req_status_code fnd_lookup_values.lookup_code%TYPE;
138:
139: ln_reqid_convert NUMBER;
140:

Line 137: lv_fsg_req_status_code fnd_lookup_values.lookup_code%TYPE;

133: lb_xml_layout BOOLEAN;
134:
135: lv_fsg_req_phase fnd_lookup_values.meaning%TYPE;
136: lv_fsg_req_status fnd_lookup_values.meaning%TYPE;
137: lv_fsg_req_status_code fnd_lookup_values.lookup_code%TYPE;
138:
139: ln_reqid_convert NUMBER;
140:
141: lv_convert_req_phase fnd_lookup_values.meaning%TYPE;

Line 141: lv_convert_req_phase fnd_lookup_values.meaning%TYPE;

137: lv_fsg_req_status_code fnd_lookup_values.lookup_code%TYPE;
138:
139: ln_reqid_convert NUMBER;
140:
141: lv_convert_req_phase fnd_lookup_values.meaning%TYPE;
142: lv_convert_req_status fnd_lookup_values.meaning%TYPE;
143: lv_convert_req_status_code fnd_lookup_values.lookup_code%TYPE;
144:
145:

Line 142: lv_convert_req_status fnd_lookup_values.meaning%TYPE;

138:
139: ln_reqid_convert NUMBER;
140:
141: lv_convert_req_phase fnd_lookup_values.meaning%TYPE;
142: lv_convert_req_status fnd_lookup_values.meaning%TYPE;
143: lv_convert_req_status_code fnd_lookup_values.lookup_code%TYPE;
144:
145:
146: CURSOR C_COMPANY_NAME

Line 143: lv_convert_req_status_code fnd_lookup_values.lookup_code%TYPE;

139: ln_reqid_convert NUMBER;
140:
141: lv_convert_req_phase fnd_lookup_values.meaning%TYPE;
142: lv_convert_req_status fnd_lookup_values.meaning%TYPE;
143: lv_convert_req_status_code fnd_lookup_values.lookup_code%TYPE;
144:
145:
146: CURSOR C_COMPANY_NAME
147: IS

Line 591: fnd_lookup_values

587: lookup_code
588: INTO
589: lv_fsg_req_status_code
590: FROM
591: fnd_lookup_values
592: WHERE lookup_type = 'CP_STATUS_CODE'
593: AND view_application_id=0
594: AND security_group_id=0
595: AND meaning=lv_fsg_req_status

Line 640: fnd_lookup_values

636: lookup_code
637: INTO
638: lv_convert_req_status_code
639: FROM
640: fnd_lookup_values
641: WHERE lookup_type = 'CP_STATUS_CODE'
642: AND view_application_id=0
643: AND security_group_id=0
644: AND meaning=lv_convert_req_status