DBA Data[Home] [Help]

APPS.PAY_PAYRPENP_XML_PKG dependencies on PAY_PRL_XML_UTILS

Line 72: l_tag := pay_prl_xml_utils.getTag('CP_ORGANIZATION_NAME', p_organization_name );

68: begin
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);

Line 75: l_tag := pay_prl_xml_utils.getTag('CP_PAYROLL_NAME',p_payroll_name);

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:
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);

Line 78: l_tag := pay_prl_xml_utils.getTag('CP_LOCATION_CODE',p_location_code);

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:
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);

Line 81: l_tag := pay_prl_xml_utils.getTag('CP_CONSOLIDATION_SET_NAME',p_consolidation_set_name);

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:
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);

Line 84: l_tag := pay_prl_xml_utils.getTag('CONSOLIDATION_SET_NAME',p_consolidation_set_name);

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:
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);

Line 87: l_tag := pay_prl_xml_utils.getTag('CP_BUSINESS_GROUP_NAME',p_business_group_name);

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:
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);

Line 90: l_tag := pay_prl_xml_utils.getTag('CP_NO_DATA_FOUND', to_char(p_no_data_found) );

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:
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);

Line 93: l_tag := pay_prl_xml_utils.getTag('CP_REPORT_DATE',p_report_date);

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:
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);

Line 96: l_tag := pay_prl_xml_utils.getTag('CP_START_DATE',l_start_date_char);

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:
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);

Line 99: l_tag := pay_prl_xml_utils.getTag('CP_END_DATE',l_end_date_char);

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:
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);

Line 102: l_tag := pay_prl_xml_utils.getTag('CP_GROUP_COLUMN1',get_display_name(p_group_column1));

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:
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);

Line 105: l_tag := pay_prl_xml_utils.getTag('CP_GROUP_COLUMN2',get_display_name(p_group_column2));

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:
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);

Line 108: l_tag := pay_prl_xml_utils.getTag('CP_GROUP_COLUMN3',get_display_name(p_group_column3));

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:
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);

Line 111: l_tag := pay_prl_xml_utils.getTag('CP_SORT_OPTION1',p_sort_option_one);

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:
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);

Line 114: l_tag := pay_prl_xml_utils.getTag('CP_SORT_OPTION2',p_sort_option_two);

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:
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);

Line 117: l_tag := pay_prl_xml_utils.getTag('CP_SORT_OPTION3',p_sort_option_three);

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:
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);

Line 120: l_tag := pay_prl_xml_utils.getTag('CP_TEMPLATE_NAME',p_template_name);

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:
123: end;
124:

Line 138: l_tag := pay_prl_xml_utils.getTag('REG_A',p_master_column1);

134:
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);

Line 141: l_tag := pay_prl_xml_utils.getTag('REG_B',p_master_column2);

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:
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);

Line 144: l_tag := pay_prl_xml_utils.getTag('REG_C',p_master_column3);

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:
147: end;
148:

Line 174: l_tag := pay_prl_xml_utils.getTag('ICX_PERIOD_START_DATE', to_char(p_ICX_period_start_date) );

170:
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);

Line 177: l_tag := pay_prl_xml_utils.getTag('ICX_PERIOD_END_DATE',p_ICX_period_end_date);

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:
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);

Line 180: l_tag := pay_prl_xml_utils.getTag('ORDER_NAME',p_order_name);

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:
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);

Line 183: l_tag := pay_prl_xml_utils.getTag('ORGANIZATION_NAME',p_organization_name);

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:
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);

Line 186: l_tag := pay_prl_xml_utils.getTag('CONSOLIDATION_SET_NAME',p_consolidation_set_name);

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:
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);

Line 189: l_tag := pay_prl_xml_utils.getTag('PAYROLL_NAME',p_payroll_name);

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:
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);

Line 192: l_tag := pay_prl_xml_utils.getTag('LOCATION_CODE',p_location_code);

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:
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);

Line 195: l_tag := pay_prl_xml_utils.getTag('ASSIGNMENT_ID',p_assignment_id);

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:
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);

Line 198: l_tag := pay_prl_xml_utils.getTag('PAY_BASIS',p_pay_basis);

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:
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);

Line 201: l_tag := pay_prl_xml_utils.getTag('FULL_NAME',p_full_name);

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:
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);

Line 204: l_tag := pay_prl_xml_utils.getTag('USER_STATUS',p_user_status);

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:
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);

Line 207: l_tag := pay_prl_xml_utils.getTag('PERSON_ID',p_person_id);

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:
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);

Line 210: l_tag := pay_prl_xml_utils.getTag('ASSIGNMENT_NUMBER',p_assignment_number);

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:
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);

Line 213: l_tag := pay_prl_xml_utils.getTag('CF_ABSENCE_TYPE',p_cf_absence_type);

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:
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);

Line 216: l_tag := pay_prl_xml_utils.getTag('CF_DATA_FOUND',p_cf_data_found);

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:
219: end append_detail_group_data;
220: