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.PAY_PAYRPENP_XML_PKG dependencies on DBMS_LOB

Line 73: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

69: l_start_date_char := fnd_date.date_to_displaydate(p_start_date);
70: l_end_date_char := fnd_date.date_to_displaydate(p_end_date);
71:
72: l_tag := pay_prl_xml_utils.getTag('CP_ORGANIZATION_NAME', p_organization_name );
73: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
74:
75: l_tag := pay_prl_xml_utils.getTag('CP_PAYROLL_NAME',p_payroll_name);
76: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
77:

Line 76: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

72: l_tag := pay_prl_xml_utils.getTag('CP_ORGANIZATION_NAME', p_organization_name );
73: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
74:
75: l_tag := pay_prl_xml_utils.getTag('CP_PAYROLL_NAME',p_payroll_name);
76: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
77:
78: l_tag := pay_prl_xml_utils.getTag('CP_LOCATION_CODE',p_location_code);
79: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
80:

Line 79: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

75: l_tag := pay_prl_xml_utils.getTag('CP_PAYROLL_NAME',p_payroll_name);
76: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
77:
78: l_tag := pay_prl_xml_utils.getTag('CP_LOCATION_CODE',p_location_code);
79: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
80:
81: l_tag := pay_prl_xml_utils.getTag('CP_CONSOLIDATION_SET_NAME',p_consolidation_set_name);
82: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
83:

Line 82: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

78: l_tag := pay_prl_xml_utils.getTag('CP_LOCATION_CODE',p_location_code);
79: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
80:
81: l_tag := pay_prl_xml_utils.getTag('CP_CONSOLIDATION_SET_NAME',p_consolidation_set_name);
82: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
83:
84: l_tag := pay_prl_xml_utils.getTag('CONSOLIDATION_SET_NAME',p_consolidation_set_name);
85: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
86:

Line 85: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

81: l_tag := pay_prl_xml_utils.getTag('CP_CONSOLIDATION_SET_NAME',p_consolidation_set_name);
82: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
83:
84: l_tag := pay_prl_xml_utils.getTag('CONSOLIDATION_SET_NAME',p_consolidation_set_name);
85: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
86:
87: l_tag := pay_prl_xml_utils.getTag('CP_BUSINESS_GROUP_NAME',p_business_group_name);
88: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
89:

Line 88: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

84: l_tag := pay_prl_xml_utils.getTag('CONSOLIDATION_SET_NAME',p_consolidation_set_name);
85: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
86:
87: l_tag := pay_prl_xml_utils.getTag('CP_BUSINESS_GROUP_NAME',p_business_group_name);
88: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
89:
90: l_tag := pay_prl_xml_utils.getTag('CP_NO_DATA_FOUND', to_char(p_no_data_found) );
91: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
92:

Line 91: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

87: l_tag := pay_prl_xml_utils.getTag('CP_BUSINESS_GROUP_NAME',p_business_group_name);
88: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
89:
90: l_tag := pay_prl_xml_utils.getTag('CP_NO_DATA_FOUND', to_char(p_no_data_found) );
91: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
92:
93: l_tag := pay_prl_xml_utils.getTag('CP_REPORT_DATE',p_report_date);
94: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
95:

Line 94: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

90: l_tag := pay_prl_xml_utils.getTag('CP_NO_DATA_FOUND', to_char(p_no_data_found) );
91: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
92:
93: l_tag := pay_prl_xml_utils.getTag('CP_REPORT_DATE',p_report_date);
94: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
95:
96: l_tag := pay_prl_xml_utils.getTag('CP_START_DATE',l_start_date_char);
97: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
98:

Line 97: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

93: l_tag := pay_prl_xml_utils.getTag('CP_REPORT_DATE',p_report_date);
94: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
95:
96: l_tag := pay_prl_xml_utils.getTag('CP_START_DATE',l_start_date_char);
97: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
98:
99: l_tag := pay_prl_xml_utils.getTag('CP_END_DATE',l_end_date_char);
100: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
101:

Line 100: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

96: l_tag := pay_prl_xml_utils.getTag('CP_START_DATE',l_start_date_char);
97: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
98:
99: l_tag := pay_prl_xml_utils.getTag('CP_END_DATE',l_end_date_char);
100: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
101:
102: l_tag := pay_prl_xml_utils.getTag('CP_GROUP_COLUMN1',get_display_name(p_group_column1));
103: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
104:

Line 103: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

99: l_tag := pay_prl_xml_utils.getTag('CP_END_DATE',l_end_date_char);
100: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
101:
102: l_tag := pay_prl_xml_utils.getTag('CP_GROUP_COLUMN1',get_display_name(p_group_column1));
103: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
104:
105: l_tag := pay_prl_xml_utils.getTag('CP_GROUP_COLUMN2',get_display_name(p_group_column2));
106: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
107:

Line 106: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

102: l_tag := pay_prl_xml_utils.getTag('CP_GROUP_COLUMN1',get_display_name(p_group_column1));
103: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
104:
105: l_tag := pay_prl_xml_utils.getTag('CP_GROUP_COLUMN2',get_display_name(p_group_column2));
106: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
107:
108: l_tag := pay_prl_xml_utils.getTag('CP_GROUP_COLUMN3',get_display_name(p_group_column3));
109: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
110:

Line 109: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

105: l_tag := pay_prl_xml_utils.getTag('CP_GROUP_COLUMN2',get_display_name(p_group_column2));
106: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
107:
108: l_tag := pay_prl_xml_utils.getTag('CP_GROUP_COLUMN3',get_display_name(p_group_column3));
109: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
110:
111: l_tag := pay_prl_xml_utils.getTag('CP_SORT_OPTION1',p_sort_option_one);
112: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
113:

Line 112: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

108: l_tag := pay_prl_xml_utils.getTag('CP_GROUP_COLUMN3',get_display_name(p_group_column3));
109: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
110:
111: l_tag := pay_prl_xml_utils.getTag('CP_SORT_OPTION1',p_sort_option_one);
112: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
113:
114: l_tag := pay_prl_xml_utils.getTag('CP_SORT_OPTION2',p_sort_option_two);
115: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
116:

Line 115: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

111: l_tag := pay_prl_xml_utils.getTag('CP_SORT_OPTION1',p_sort_option_one);
112: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
113:
114: l_tag := pay_prl_xml_utils.getTag('CP_SORT_OPTION2',p_sort_option_two);
115: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
116:
117: l_tag := pay_prl_xml_utils.getTag('CP_SORT_OPTION3',p_sort_option_three);
118: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
119:

Line 118: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

114: l_tag := pay_prl_xml_utils.getTag('CP_SORT_OPTION2',p_sort_option_two);
115: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
116:
117: l_tag := pay_prl_xml_utils.getTag('CP_SORT_OPTION3',p_sort_option_three);
118: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
119:
120: l_tag := pay_prl_xml_utils.getTag('CP_TEMPLATE_NAME',p_template_name);
121: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
122:

Line 121: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

117: l_tag := pay_prl_xml_utils.getTag('CP_SORT_OPTION3',p_sort_option_three);
118: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
119:
120: l_tag := pay_prl_xml_utils.getTag('CP_TEMPLATE_NAME',p_template_name);
121: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
122:
123: end;
124:
125: --

Line 139: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

135: l_tag varchar2(200);
136:
137: begin
138: l_tag := pay_prl_xml_utils.getTag('REG_A',p_master_column1);
139: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
140:
141: l_tag := pay_prl_xml_utils.getTag('REG_B',p_master_column2);
142: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
143:

Line 142: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

138: l_tag := pay_prl_xml_utils.getTag('REG_A',p_master_column1);
139: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
140:
141: l_tag := pay_prl_xml_utils.getTag('REG_B',p_master_column2);
142: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
143:
144: l_tag := pay_prl_xml_utils.getTag('REG_C',p_master_column3);
145: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
146:

Line 145: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

141: l_tag := pay_prl_xml_utils.getTag('REG_B',p_master_column2);
142: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
143:
144: l_tag := pay_prl_xml_utils.getTag('REG_C',p_master_column3);
145: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
146:
147: end;
148:
149: --

Line 175: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

171: l_tag varchar2(200);
172:
173: begin
174: l_tag := pay_prl_xml_utils.getTag('ICX_PERIOD_START_DATE', to_char(p_ICX_period_start_date) );
175: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
176:
177: l_tag := pay_prl_xml_utils.getTag('ICX_PERIOD_END_DATE',p_ICX_period_end_date);
178: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
179:

Line 178: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

174: l_tag := pay_prl_xml_utils.getTag('ICX_PERIOD_START_DATE', to_char(p_ICX_period_start_date) );
175: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
176:
177: l_tag := pay_prl_xml_utils.getTag('ICX_PERIOD_END_DATE',p_ICX_period_end_date);
178: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
179:
180: l_tag := pay_prl_xml_utils.getTag('ORDER_NAME',p_order_name);
181: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
182:

Line 181: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

177: l_tag := pay_prl_xml_utils.getTag('ICX_PERIOD_END_DATE',p_ICX_period_end_date);
178: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
179:
180: l_tag := pay_prl_xml_utils.getTag('ORDER_NAME',p_order_name);
181: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
182:
183: l_tag := pay_prl_xml_utils.getTag('ORGANIZATION_NAME',p_organization_name);
184: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
185:

Line 184: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

180: l_tag := pay_prl_xml_utils.getTag('ORDER_NAME',p_order_name);
181: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
182:
183: l_tag := pay_prl_xml_utils.getTag('ORGANIZATION_NAME',p_organization_name);
184: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
185:
186: l_tag := pay_prl_xml_utils.getTag('CONSOLIDATION_SET_NAME',p_consolidation_set_name);
187: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
188:

Line 187: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

183: l_tag := pay_prl_xml_utils.getTag('ORGANIZATION_NAME',p_organization_name);
184: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
185:
186: l_tag := pay_prl_xml_utils.getTag('CONSOLIDATION_SET_NAME',p_consolidation_set_name);
187: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
188:
189: l_tag := pay_prl_xml_utils.getTag('PAYROLL_NAME',p_payroll_name);
190: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
191:

Line 190: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

186: l_tag := pay_prl_xml_utils.getTag('CONSOLIDATION_SET_NAME',p_consolidation_set_name);
187: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
188:
189: l_tag := pay_prl_xml_utils.getTag('PAYROLL_NAME',p_payroll_name);
190: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
191:
192: l_tag := pay_prl_xml_utils.getTag('LOCATION_CODE',p_location_code);
193: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
194:

Line 193: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

189: l_tag := pay_prl_xml_utils.getTag('PAYROLL_NAME',p_payroll_name);
190: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
191:
192: l_tag := pay_prl_xml_utils.getTag('LOCATION_CODE',p_location_code);
193: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
194:
195: l_tag := pay_prl_xml_utils.getTag('ASSIGNMENT_ID',p_assignment_id);
196: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
197:

Line 196: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

192: l_tag := pay_prl_xml_utils.getTag('LOCATION_CODE',p_location_code);
193: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
194:
195: l_tag := pay_prl_xml_utils.getTag('ASSIGNMENT_ID',p_assignment_id);
196: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
197:
198: l_tag := pay_prl_xml_utils.getTag('PAY_BASIS',p_pay_basis);
199: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
200:

Line 199: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

195: l_tag := pay_prl_xml_utils.getTag('ASSIGNMENT_ID',p_assignment_id);
196: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
197:
198: l_tag := pay_prl_xml_utils.getTag('PAY_BASIS',p_pay_basis);
199: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
200:
201: l_tag := pay_prl_xml_utils.getTag('FULL_NAME',p_full_name);
202: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
203:

Line 202: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

198: l_tag := pay_prl_xml_utils.getTag('PAY_BASIS',p_pay_basis);
199: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
200:
201: l_tag := pay_prl_xml_utils.getTag('FULL_NAME',p_full_name);
202: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
203:
204: l_tag := pay_prl_xml_utils.getTag('USER_STATUS',p_user_status);
205: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
206:

Line 205: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

201: l_tag := pay_prl_xml_utils.getTag('FULL_NAME',p_full_name);
202: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
203:
204: l_tag := pay_prl_xml_utils.getTag('USER_STATUS',p_user_status);
205: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
206:
207: l_tag := pay_prl_xml_utils.getTag('PERSON_ID',p_person_id);
208: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
209:

Line 208: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

204: l_tag := pay_prl_xml_utils.getTag('USER_STATUS',p_user_status);
205: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
206:
207: l_tag := pay_prl_xml_utils.getTag('PERSON_ID',p_person_id);
208: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
209:
210: l_tag := pay_prl_xml_utils.getTag('ASSIGNMENT_NUMBER',p_assignment_number);
211: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
212:

Line 211: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

207: l_tag := pay_prl_xml_utils.getTag('PERSON_ID',p_person_id);
208: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
209:
210: l_tag := pay_prl_xml_utils.getTag('ASSIGNMENT_NUMBER',p_assignment_number);
211: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
212:
213: l_tag := pay_prl_xml_utils.getTag('CF_ABSENCE_TYPE',p_cf_absence_type);
214: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
215:

Line 214: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

210: l_tag := pay_prl_xml_utils.getTag('ASSIGNMENT_NUMBER',p_assignment_number);
211: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
212:
213: l_tag := pay_prl_xml_utils.getTag('CF_ABSENCE_TYPE',p_cf_absence_type);
214: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
215:
216: l_tag := pay_prl_xml_utils.getTag('CF_DATA_FOUND',p_cf_data_found);
217: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
218:

Line 217: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

213: l_tag := pay_prl_xml_utils.getTag('CF_ABSENCE_TYPE',p_cf_absence_type);
214: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
215:
216: l_tag := pay_prl_xml_utils.getTag('CF_DATA_FOUND',p_cf_data_found);
217: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
218:
219: end append_detail_group_data;
220:
221: --

Line 645: dbms_lob.createtemporary(g_xml_data,false,dbms_lob.call);

641: ' and NVL ('|| l_group_column3 || ' , ''-1'' ) = NVL( :5, ''-1'')' ||
642: ' order by '||l_order_by_clause;
643:
644:
645: dbms_lob.createtemporary(g_xml_data,false,dbms_lob.call);
646: dbms_lob.open(g_xml_data,dbms_lob.lob_readwrite);
647:
648: l_tag :='';
649: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

Line 646: dbms_lob.open(g_xml_data,dbms_lob.lob_readwrite);

642: ' order by '||l_order_by_clause;
643:
644:
645: dbms_lob.createtemporary(g_xml_data,false,dbms_lob.call);
646: dbms_lob.open(g_xml_data,dbms_lob.lob_readwrite);
647:
648: l_tag :='';
649: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
650:

Line 649: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

645: dbms_lob.createtemporary(g_xml_data,false,dbms_lob.call);
646: dbms_lob.open(g_xml_data,dbms_lob.lob_readwrite);
647:
648: l_tag :='';
649: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
650:
651: l_tag := '';
652: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
653:

Line 652: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

648: l_tag :='';
649: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
650:
651: l_tag := '';
652: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
653:
654: l_tag := '';
655: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
656:

Line 655: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

651: l_tag := '';
652: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
653:
654: l_tag := '';
655: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
656:
657: cf_data_found := 0;
658:
659: open csr_master for l_master_statement using fnd_date.canonical_to_date(p_start_date_char),

Line 667: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

663: fetch csr_master into l_master_column1,l_master_column2,l_master_column3;
664: exit when csr_master%notfound;
665:
666: l_tag := '';
667: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
668:
669: append_master_group_data(
670: l_master_column1,
671: l_master_column2,

Line 682: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

678: l_master_column2,
679: l_master_column3;
680:
681: l_tag := '';
682: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
683:
684: loop
685:
686: fetch csr_detail into c_detail_rec;

Line 700: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

696: ,c_detail_rec.person_id
697: );
698:
699: l_tag := '';
700: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
701: append_detail_group_data(
702: c_detail_rec.ICX_period_start_date
703: ,c_detail_rec.ICX_period_end_date
704: ,c_detail_rec.order_name

Line 720: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

716: ,cf_absence_type
717: ,cf_data_found
718: );
719: l_tag := '';
720: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
721:
722: --dbms_output.put_line('Full Name = ' || c_detail_rec.full_name);
723: end loop;
724: close csr_detail;

Line 727: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

723: end loop;
724: close csr_detail;
725:
726: l_tag := '';
727: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
728:
729: l_tag := '';
730: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
731:

Line 730: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

726: l_tag := '';
727: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
728:
729: l_tag := '';
730: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
731:
732: end loop;
733: close csr_master;
734:

Line 736: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

732: end loop;
733: close csr_master;
734:
735: l_tag := '';
736: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
737:
738: --
739: --
740: --

Line 767: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);

763: ,l_template_name
764: );
765:
766: l_tag := '';
767: dbms_lob.writeappend(g_xml_data, length(l_tag), l_tag);
768:
769: p_xml := g_xml_data;
770:
771: end emp_asg_not_processed;