DBA Data[Home] [Help]

APPS.PAY_DK_SICKNESS_DP202 dependencies on HR_DK_UTILITY

Line 301: xml_tab(xml_ctr).tagvalue := hr_dk_utility.REPLACE_SPECIAL_CHARS(emp_rec.ename);

297: CLOSE csr_le_cvr;
298:
299: /*Bug 5049222 fix*/
300: xml_tab(xml_ctr).tagname := 'emp_name';
301: xml_tab(xml_ctr).tagvalue := hr_dk_utility.REPLACE_SPECIAL_CHARS(emp_rec.ename);
302: xml_ctr := xml_ctr +1;
303:
304: xml_tab(xml_ctr).tagname := 'address_line1';
305: xml_tab(xml_ctr).tagvalue := hr_dk_utility.REPLACE_SPECIAL_CHARS(substr(addr_rec.address_line1,1,40));

Line 305: xml_tab(xml_ctr).tagvalue := hr_dk_utility.REPLACE_SPECIAL_CHARS(substr(addr_rec.address_line1,1,40));

301: xml_tab(xml_ctr).tagvalue := hr_dk_utility.REPLACE_SPECIAL_CHARS(emp_rec.ename);
302: xml_ctr := xml_ctr +1;
303:
304: xml_tab(xml_ctr).tagname := 'address_line1';
305: xml_tab(xml_ctr).tagvalue := hr_dk_utility.REPLACE_SPECIAL_CHARS(substr(addr_rec.address_line1,1,40));
306: xml_ctr := xml_ctr +1;
307:
308: xml_tab(xml_ctr).tagname := 'address_line2';
309: xml_tab(xml_ctr).tagvalue := hr_dk_utility.REPLACE_SPECIAL_CHARS(substr(addr_rec.address_line2,1,40));

Line 309: xml_tab(xml_ctr).tagvalue := hr_dk_utility.REPLACE_SPECIAL_CHARS(substr(addr_rec.address_line2,1,40));

305: xml_tab(xml_ctr).tagvalue := hr_dk_utility.REPLACE_SPECIAL_CHARS(substr(addr_rec.address_line1,1,40));
306: xml_ctr := xml_ctr +1;
307:
308: xml_tab(xml_ctr).tagname := 'address_line2';
309: xml_tab(xml_ctr).tagvalue := hr_dk_utility.REPLACE_SPECIAL_CHARS(substr(addr_rec.address_line2,1,40));
310: xml_ctr := xml_ctr +1;
311:
312: xml_tab(xml_ctr).tagname := 'postal_code';
313: xml_tab(xml_ctr).tagvalue := substr(addr_rec.postal_code,1,40);

Line 396: xml_tab(xml_ctr).tagvalue := hr_dk_utility.REPLACE_SPECIAL_CHARS(le_rec.le_name);

392: xml_tab(xml_ctr).tagvalue := asg_rec.absence_end_date;
393: xml_ctr := xml_ctr +1;*/
394:
395: xml_tab(xml_ctr).tagname := 'le_name';
396: xml_tab(xml_ctr).tagvalue := hr_dk_utility.REPLACE_SPECIAL_CHARS(le_rec.le_name);
397: xml_ctr := xml_ctr +1;
398:
399:
400: xml_tab(xml_ctr).tagname := 'le_address_pcode';

Line 401: xml_tab(xml_ctr).tagvalue := hr_dk_utility.REPLACE_SPECIAL_CHARS(le_rec.le_address1)||hr_dk_utility.REPLACE_SPECIAL_CHARS(le_rec.le_postalcode);

397: xml_ctr := xml_ctr +1;
398:
399:
400: xml_tab(xml_ctr).tagname := 'le_address_pcode';
401: xml_tab(xml_ctr).tagvalue := hr_dk_utility.REPLACE_SPECIAL_CHARS(le_rec.le_address1)||hr_dk_utility.REPLACE_SPECIAL_CHARS(le_rec.le_postalcode);
402: xml_ctr := xml_ctr +1;
403:
404: IF (le_rec.le_phone IS NOT NULL AND le_rec.le_email IS NOT NULL ) THEN
405: xml_tab(xml_ctr).tagname := 'le_phone_email';

Line 406: xml_tab(xml_ctr).tagvalue := hr_dk_utility.REPLACE_SPECIAL_CHARS(le_rec.le_phone) ||','||hr_dk_utility.REPLACE_SPECIAL_CHARS(le_rec.le_email);

402: xml_ctr := xml_ctr +1;
403:
404: IF (le_rec.le_phone IS NOT NULL AND le_rec.le_email IS NOT NULL ) THEN
405: xml_tab(xml_ctr).tagname := 'le_phone_email';
406: xml_tab(xml_ctr).tagvalue := hr_dk_utility.REPLACE_SPECIAL_CHARS(le_rec.le_phone) ||','||hr_dk_utility.REPLACE_SPECIAL_CHARS(le_rec.le_email);
407: xml_ctr := xml_ctr +1;
408: ELSE
409: xml_tab(xml_ctr).tagname := 'le_phone_email';
410: xml_tab(xml_ctr).tagvalue := hr_dk_utility.REPLACE_SPECIAL_CHARS(le_rec.le_phone) ||hr_dk_utility.REPLACE_SPECIAL_CHARS(le_rec.le_email);

Line 410: xml_tab(xml_ctr).tagvalue := hr_dk_utility.REPLACE_SPECIAL_CHARS(le_rec.le_phone) ||hr_dk_utility.REPLACE_SPECIAL_CHARS(le_rec.le_email);

406: xml_tab(xml_ctr).tagvalue := hr_dk_utility.REPLACE_SPECIAL_CHARS(le_rec.le_phone) ||','||hr_dk_utility.REPLACE_SPECIAL_CHARS(le_rec.le_email);
407: xml_ctr := xml_ctr +1;
408: ELSE
409: xml_tab(xml_ctr).tagname := 'le_phone_email';
410: xml_tab(xml_ctr).tagvalue := hr_dk_utility.REPLACE_SPECIAL_CHARS(le_rec.le_phone) ||hr_dk_utility.REPLACE_SPECIAL_CHARS(le_rec.le_email);
411: xml_ctr := xml_ctr +1;
412:
413:
414: END IF ;