27: '
28:
29: DBMS_LOB.createtemporary (p_xfdf_string, FALSE, DBMS_LOB.CALL);
30: DBMS_LOB.OPEN (p_xfdf_string, DBMS_LOB.lob_readwrite);
31: hr_utility.set_location ('TableCnt' || TO_CHAR (vxmltable.COUNT), 13);
32:
33: IF vxmltable.COUNT > 0
34: THEN
35: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str1), l_str1);
35: DBMS_LOB.writeappend (p_xfdf_string, LENGTH (l_str1), l_str1);
36:
37: FOR ctr_table IN vxmltable.FIRST .. vxmltable.LAST
38: LOOP
39: hr_utility.set_location ( vxmltable (ctr_table).tagname
40: || ' '
41: || vxmltable (ctr_table).tagvalue,
42: 15
43: );
299: --
300: l_pymt_type pay_payment_types_tl.payment_type_name%TYPE;
301: l_master_rec VARCHAR2 (1);
302: BEGIN
303: hr_utility.set_location ('Input Parameters', 01);
304: hr_utility.set_location ('p_bg_id ' || p_bg_id, 01);
305: hr_utility.set_location ('p_period_id ' || p_period_id, 01);
306: hr_utility.set_location ('p_payroll_id ' || p_payroll_id, 01);
307: hr_utility.set_location ( 'p_consolidation_set_id'
300: l_pymt_type pay_payment_types_tl.payment_type_name%TYPE;
301: l_master_rec VARCHAR2 (1);
302: BEGIN
303: hr_utility.set_location ('Input Parameters', 01);
304: hr_utility.set_location ('p_bg_id ' || p_bg_id, 01);
305: hr_utility.set_location ('p_period_id ' || p_period_id, 01);
306: hr_utility.set_location ('p_payroll_id ' || p_payroll_id, 01);
307: hr_utility.set_location ( 'p_consolidation_set_id'
308: || p_consolidation_set_id,
301: l_master_rec VARCHAR2 (1);
302: BEGIN
303: hr_utility.set_location ('Input Parameters', 01);
304: hr_utility.set_location ('p_bg_id ' || p_bg_id, 01);
305: hr_utility.set_location ('p_period_id ' || p_period_id, 01);
306: hr_utility.set_location ('p_payroll_id ' || p_payroll_id, 01);
307: hr_utility.set_location ( 'p_consolidation_set_id'
308: || p_consolidation_set_id,
309: 01
302: BEGIN
303: hr_utility.set_location ('Input Parameters', 01);
304: hr_utility.set_location ('p_bg_id ' || p_bg_id, 01);
305: hr_utility.set_location ('p_period_id ' || p_period_id, 01);
306: hr_utility.set_location ('p_payroll_id ' || p_payroll_id, 01);
307: hr_utility.set_location ( 'p_consolidation_set_id'
308: || p_consolidation_set_id,
309: 01
310: );
303: hr_utility.set_location ('Input Parameters', 01);
304: hr_utility.set_location ('p_bg_id ' || p_bg_id, 01);
305: hr_utility.set_location ('p_period_id ' || p_period_id, 01);
306: hr_utility.set_location ('p_payroll_id ' || p_payroll_id, 01);
307: hr_utility.set_location ( 'p_consolidation_set_id'
308: || p_consolidation_set_id,
309: 01
310: );
311: l_bg_name :=
329:
330: SELECT fnd_date.date_to_displaydate (SYSDATE)
331: INTO l_report_date
332: FROM DUAL;
333: hr_utility.set_location ('Header Table Creation', 10);
334: vxmltable.DELETE;
335: vctr := 1;
336: vxmltable (vctr).tagname := 'G_HEADER';
337: vxmltable (vctr).tagvalue := ' ';
450: vxmltable (vctr).tagvalue := (c_pymt_record.total_assignments_paid);
451: vctr := vctr + 1;
452: vxmltable (vctr).tagname := '/G_PYMT_RECORD';
453: vxmltable (vctr).tagvalue := ' ';
454: hr_utility.set_location ('TableCnt' || TO_CHAR (vxmltable.COUNT), 18);
455: END LOOP;
456:
457: IF (l_master_rec IS NOT NULL)
458: THEN
489: c_warning.payments_from_previous_periods;
490: EXIT;
491: END LOOP;
492:
493: hr_utility.set_location ('TableCnt' || TO_CHAR (vxmltable.COUNT), 13);
494: writetoclob (p_xml);
495: END populate_pymt_summary_rep;
496: END pay_ie_pymt_summary_rpt_pkg;