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_CFS_GENERATE_PKG dependencies on FND_LOOKUP_VALUES

Line 139: l_fsg_req_phase fnd_lookup_values.meaning%TYPE;

135: l_reqid_fsg NUMBER; --Request id for 'Program - Run Financial Statement Generator'
136: l_reqid_cal NUMBER; --Request id for 'Cash flow statement - Calculation'
137: l_reqid_fsg_cfs NUMBER; --Request id for the FSG - CFS report that automatically submitted by
138: --'Program - Run Financial Statement Generator'
139: l_fsg_req_phase fnd_lookup_values.meaning%TYPE;
140: l_fsg_req_status fnd_lookup_values.meaning%TYPE;
141: l_fsg_req_status_code fnd_lookup_values.lookup_code%TYPE;
142:
143: l_fsg_req_phase_cfs fnd_lookup_values.meaning%TYPE;

Line 140: l_fsg_req_status fnd_lookup_values.meaning%TYPE;

136: l_reqid_cal NUMBER; --Request id for 'Cash flow statement - Calculation'
137: l_reqid_fsg_cfs NUMBER; --Request id for the FSG - CFS report that automatically submitted by
138: --'Program - Run Financial Statement Generator'
139: l_fsg_req_phase fnd_lookup_values.meaning%TYPE;
140: l_fsg_req_status fnd_lookup_values.meaning%TYPE;
141: l_fsg_req_status_code fnd_lookup_values.lookup_code%TYPE;
142:
143: l_fsg_req_phase_cfs fnd_lookup_values.meaning%TYPE;
144: l_fsg_req_status_cfs fnd_lookup_values.meaning%TYPE;

Line 141: l_fsg_req_status_code fnd_lookup_values.lookup_code%TYPE;

137: l_reqid_fsg_cfs NUMBER; --Request id for the FSG - CFS report that automatically submitted by
138: --'Program - Run Financial Statement Generator'
139: l_fsg_req_phase fnd_lookup_values.meaning%TYPE;
140: l_fsg_req_status fnd_lookup_values.meaning%TYPE;
141: l_fsg_req_status_code fnd_lookup_values.lookup_code%TYPE;
142:
143: l_fsg_req_phase_cfs fnd_lookup_values.meaning%TYPE;
144: l_fsg_req_status_cfs fnd_lookup_values.meaning%TYPE;
145: l_fsg_req_status_cfs_code fnd_lookup_values.lookup_code%TYPE;

Line 143: l_fsg_req_phase_cfs fnd_lookup_values.meaning%TYPE;

139: l_fsg_req_phase fnd_lookup_values.meaning%TYPE;
140: l_fsg_req_status fnd_lookup_values.meaning%TYPE;
141: l_fsg_req_status_code fnd_lookup_values.lookup_code%TYPE;
142:
143: l_fsg_req_phase_cfs fnd_lookup_values.meaning%TYPE;
144: l_fsg_req_status_cfs fnd_lookup_values.meaning%TYPE;
145: l_fsg_req_status_cfs_code fnd_lookup_values.lookup_code%TYPE;
146:
147: l_cal_req_phase fnd_lookup_values.meaning%TYPE;

Line 144: l_fsg_req_status_cfs fnd_lookup_values.meaning%TYPE;

140: l_fsg_req_status fnd_lookup_values.meaning%TYPE;
141: l_fsg_req_status_code fnd_lookup_values.lookup_code%TYPE;
142:
143: l_fsg_req_phase_cfs fnd_lookup_values.meaning%TYPE;
144: l_fsg_req_status_cfs fnd_lookup_values.meaning%TYPE;
145: l_fsg_req_status_cfs_code fnd_lookup_values.lookup_code%TYPE;
146:
147: l_cal_req_phase fnd_lookup_values.meaning%TYPE;
148: l_cal_req_status fnd_lookup_values.meaning%TYPE;

Line 145: l_fsg_req_status_cfs_code fnd_lookup_values.lookup_code%TYPE;

141: l_fsg_req_status_code fnd_lookup_values.lookup_code%TYPE;
142:
143: l_fsg_req_phase_cfs fnd_lookup_values.meaning%TYPE;
144: l_fsg_req_status_cfs fnd_lookup_values.meaning%TYPE;
145: l_fsg_req_status_cfs_code fnd_lookup_values.lookup_code%TYPE;
146:
147: l_cal_req_phase fnd_lookup_values.meaning%TYPE;
148: l_cal_req_status fnd_lookup_values.meaning%TYPE;
149: l_cal_req_status_code fnd_lookup_values.lookup_code%TYPE;

Line 147: l_cal_req_phase fnd_lookup_values.meaning%TYPE;

143: l_fsg_req_phase_cfs fnd_lookup_values.meaning%TYPE;
144: l_fsg_req_status_cfs fnd_lookup_values.meaning%TYPE;
145: l_fsg_req_status_cfs_code fnd_lookup_values.lookup_code%TYPE;
146:
147: l_cal_req_phase fnd_lookup_values.meaning%TYPE;
148: l_cal_req_status fnd_lookup_values.meaning%TYPE;
149: l_cal_req_status_code fnd_lookup_values.lookup_code%TYPE;
150:
151: l_reqid_comb NUMBER; -- Request id for the 'Cash flow statement - Combination'

Line 148: l_cal_req_status fnd_lookup_values.meaning%TYPE;

144: l_fsg_req_status_cfs fnd_lookup_values.meaning%TYPE;
145: l_fsg_req_status_cfs_code fnd_lookup_values.lookup_code%TYPE;
146:
147: l_cal_req_phase fnd_lookup_values.meaning%TYPE;
148: l_cal_req_status fnd_lookup_values.meaning%TYPE;
149: l_cal_req_status_code fnd_lookup_values.lookup_code%TYPE;
150:
151: l_reqid_comb NUMBER; -- Request id for the 'Cash flow statement - Combination'
152:

Line 149: l_cal_req_status_code fnd_lookup_values.lookup_code%TYPE;

145: l_fsg_req_status_cfs_code fnd_lookup_values.lookup_code%TYPE;
146:
147: l_cal_req_phase fnd_lookup_values.meaning%TYPE;
148: l_cal_req_status fnd_lookup_values.meaning%TYPE;
149: l_cal_req_status_code fnd_lookup_values.lookup_code%TYPE;
150:
151: l_reqid_comb NUMBER; -- Request id for the 'Cash flow statement - Combination'
152:
153:

Line 154: l_comb_req_phase fnd_lookup_values.meaning%TYPE;

150:
151: l_reqid_comb NUMBER; -- Request id for the 'Cash flow statement - Combination'
152:
153:
154: l_comb_req_phase fnd_lookup_values.meaning%TYPE;
155: l_comb_req_status fnd_lookup_values.meaning%TYPE;
156: l_comb_req_status_code fnd_lookup_values.lookup_code%TYPE;
157:
158: l_error_flag VARCHAR2(1);

Line 155: l_comb_req_status fnd_lookup_values.meaning%TYPE;

151: l_reqid_comb NUMBER; -- Request id for the 'Cash flow statement - Combination'
152:
153:
154: l_comb_req_phase fnd_lookup_values.meaning%TYPE;
155: l_comb_req_status fnd_lookup_values.meaning%TYPE;
156: l_comb_req_status_code fnd_lookup_values.lookup_code%TYPE;
157:
158: l_error_flag VARCHAR2(1);
159: l_error_status BOOLEAN;

Line 156: l_comb_req_status_code fnd_lookup_values.lookup_code%TYPE;

152:
153:
154: l_comb_req_phase fnd_lookup_values.meaning%TYPE;
155: l_comb_req_status fnd_lookup_values.meaning%TYPE;
156: l_comb_req_status_code fnd_lookup_values.lookup_code%TYPE;
157:
158: l_error_flag VARCHAR2(1);
159: l_error_status BOOLEAN;
160:

Line 416: fnd_lookup_values

412: lookup_code
413: INTO
414: l_fsg_req_status_code
415: FROM
416: fnd_lookup_values
417: WHERE lookup_type = 'CP_STATUS_CODE'
418: AND view_application_id=0
419: AND security_group_id=0
420: AND meaning=l_fsg_req_status

Line 491: fnd_lookup_values

487: lookup_code
488: INTO
489: l_cal_req_status_code
490: FROM
491: fnd_lookup_values
492: WHERE lookup_type = 'CP_STATUS_CODE'
493: AND view_application_id=0
494: AND security_group_id=0
495: AND meaning=l_cal_req_status

Line 544: fnd_lookup_values

540: lookup_code
541: INTO
542: l_comb_req_status_code
543: FROM
544: fnd_lookup_values
545: WHERE lookup_type = 'CP_STATUS_CODE'
546: AND view_application_id=0
547: AND security_group_id=0
548: AND meaning=l_comb_req_status