DBA Data[Home] [Help]

APPS.PAY_IE_PYMT_SUMMARY_RPT_PKG dependencies on HR_UTILITY

Line 31: hr_utility.set_location ('TableCnt' || TO_CHAR (vxmltable.COUNT), 13);

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

Line 39: hr_utility.set_location ( vxmltable (ctr_table).tagname

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

Line 303: hr_utility.set_location ('Input Parameters', 01);

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'

Line 304: hr_utility.set_location ('p_bg_id ' || p_bg_id, 01);

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,

Line 305: hr_utility.set_location ('p_period_id ' || p_period_id, 01);

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

Line 306: hr_utility.set_location ('p_payroll_id ' || p_payroll_id, 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: );

Line 307: hr_utility.set_location ( 'p_consolidation_set_id'

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 :=

Line 333: hr_utility.set_location ('Header Table Creation', 10);

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 := ' ';

Line 454: hr_utility.set_location ('TableCnt' || TO_CHAR (vxmltable.COUNT), 18);

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

Line 493: hr_utility.set_location ('TableCnt' || TO_CHAR (vxmltable.COUNT), 13);

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;