111: --Request id for the FSG - CFS report that automatically submitted by
112: --'Program - Run Financial Statement Generator'
113: l_reqid_fsg_cfs NUMBER;
114:
115: l_fsg_req_phase fnd_lookup_values.lookup_code%TYPE;
116: l_fsg_req_status fnd_lookup_values.lookup_code%TYPE;
117: l_fsg_req_phase_cfs fnd_lookup_values.lookup_code%TYPE;
118: l_fsg_req_status_cfs fnd_lookup_values.lookup_code%TYPE;
119: l_cal_req_phase fnd_lookup_values.lookup_code%TYPE;
112: --'Program - Run Financial Statement Generator'
113: l_reqid_fsg_cfs NUMBER;
114:
115: l_fsg_req_phase fnd_lookup_values.lookup_code%TYPE;
116: l_fsg_req_status fnd_lookup_values.lookup_code%TYPE;
117: l_fsg_req_phase_cfs fnd_lookup_values.lookup_code%TYPE;
118: l_fsg_req_status_cfs fnd_lookup_values.lookup_code%TYPE;
119: l_cal_req_phase fnd_lookup_values.lookup_code%TYPE;
120: l_cal_req_status fnd_lookup_values.lookup_code%TYPE;
113: l_reqid_fsg_cfs NUMBER;
114:
115: l_fsg_req_phase fnd_lookup_values.lookup_code%TYPE;
116: l_fsg_req_status fnd_lookup_values.lookup_code%TYPE;
117: l_fsg_req_phase_cfs fnd_lookup_values.lookup_code%TYPE;
118: l_fsg_req_status_cfs fnd_lookup_values.lookup_code%TYPE;
119: l_cal_req_phase fnd_lookup_values.lookup_code%TYPE;
120: l_cal_req_status fnd_lookup_values.lookup_code%TYPE;
121:
114:
115: l_fsg_req_phase fnd_lookup_values.lookup_code%TYPE;
116: l_fsg_req_status fnd_lookup_values.lookup_code%TYPE;
117: l_fsg_req_phase_cfs fnd_lookup_values.lookup_code%TYPE;
118: l_fsg_req_status_cfs fnd_lookup_values.lookup_code%TYPE;
119: l_cal_req_phase fnd_lookup_values.lookup_code%TYPE;
120: l_cal_req_status fnd_lookup_values.lookup_code%TYPE;
121:
122: -- Request id for the 'Cash flow statement for small enterprise - Combination'
115: l_fsg_req_phase fnd_lookup_values.lookup_code%TYPE;
116: l_fsg_req_status fnd_lookup_values.lookup_code%TYPE;
117: l_fsg_req_phase_cfs fnd_lookup_values.lookup_code%TYPE;
118: l_fsg_req_status_cfs fnd_lookup_values.lookup_code%TYPE;
119: l_cal_req_phase fnd_lookup_values.lookup_code%TYPE;
120: l_cal_req_status fnd_lookup_values.lookup_code%TYPE;
121:
122: -- Request id for the 'Cash flow statement for small enterprise - Combination'
123: l_reqid_combination NUMBER;
116: l_fsg_req_status fnd_lookup_values.lookup_code%TYPE;
117: l_fsg_req_phase_cfs fnd_lookup_values.lookup_code%TYPE;
118: l_fsg_req_status_cfs fnd_lookup_values.lookup_code%TYPE;
119: l_cal_req_phase fnd_lookup_values.lookup_code%TYPE;
120: l_cal_req_status fnd_lookup_values.lookup_code%TYPE;
121:
122: -- Request id for the 'Cash flow statement for small enterprise - Combination'
123: l_reqid_combination NUMBER;
124: -- Request id for the 'XML report publisher'
123: l_reqid_combination NUMBER;
124: -- Request id for the 'XML report publisher'
125: l_reqid_xmlpublisher NUMBER;
126:
127: l_combination_req_phase fnd_lookup_values.lookup_code%TYPE;
128: l_combination_req_status fnd_lookup_values.lookup_code%TYPE;
129:
130: l_user_phase fnd_lookup_values.meaning%TYPE;
131: l_user_status fnd_lookup_values.meaning%TYPE;
124: -- Request id for the 'XML report publisher'
125: l_reqid_xmlpublisher NUMBER;
126:
127: l_combination_req_phase fnd_lookup_values.lookup_code%TYPE;
128: l_combination_req_status fnd_lookup_values.lookup_code%TYPE;
129:
130: l_user_phase fnd_lookup_values.meaning%TYPE;
131: l_user_status fnd_lookup_values.meaning%TYPE;
132:
126:
127: l_combination_req_phase fnd_lookup_values.lookup_code%TYPE;
128: l_combination_req_status fnd_lookup_values.lookup_code%TYPE;
129:
130: l_user_phase fnd_lookup_values.meaning%TYPE;
131: l_user_status fnd_lookup_values.meaning%TYPE;
132:
133: l_reqid_cvt NUMBER;
134: l_cvt_req_status VARCHAR2(100);
127: l_combination_req_phase fnd_lookup_values.lookup_code%TYPE;
128: l_combination_req_status fnd_lookup_values.lookup_code%TYPE;
129:
130: l_user_phase fnd_lookup_values.meaning%TYPE;
131: l_user_status fnd_lookup_values.meaning%TYPE;
132:
133: l_reqid_cvt NUMBER;
134: l_cvt_req_status VARCHAR2(100);
135: