DBA Data[Home] [Help]

APPS.PAY_IE_EHECS_REPORT_PKG dependencies on PAY_IE_EHECS_REPORT_PKG

Line 1: PACKAGE BODY PAY_IE_EHECS_REPORT_PKG AS

1: PACKAGE BODY PAY_IE_EHECS_REPORT_PKG AS
2: /* $Header: pyieehecs.pkb 120.5.12010000.3 2008/10/20 06:36:56 rsahai ship $ */
3:
4: g_package VARCHAR2(50) := 'PAY_IE_EHECS_REPORT_PKG.';
5: EOL VARCHAR2(5) := fnd_global.local_chr(10);

Line 4: g_package VARCHAR2(50) := 'PAY_IE_EHECS_REPORT_PKG.';

1: PACKAGE BODY PAY_IE_EHECS_REPORT_PKG AS
2: /* $Header: pyieehecs.pkb 120.5.12010000.3 2008/10/20 06:36:56 rsahai ship $ */
3:
4: g_package VARCHAR2(50) := 'PAY_IE_EHECS_REPORT_PKG.';
5: EOL VARCHAR2(5) := fnd_global.local_chr(10);
6: l_errflag VARCHAR2(1) := 'N';
7: error_message boolean;
8: l_str_Common VARCHAR2(2000);

Line 754: hr_utility.set_location('Entering PAY_IE_EHECS_REPORT_PKG.assignment_action_code',500);

750: l_ass_check varchar2(1);
751: l_csr_already_archived pay_element_entry_values_f.screen_entry_value%TYPE := 'N';
752: BEGIN
753:
754: hr_utility.set_location('Entering PAY_IE_EHECS_REPORT_PKG.assignment_action_code',500);
755:
756: -- Get all the parameters
757: /*6978389 */
758: hr_utility.set_location('Before get_all_parameters',501);

Line 870: hr_utility.set_location('Entering: PAY_IE_EHECS_REPORT_PKG.archive_init: ',600);

866: WHERE payroll_action_id = pactid;
867:
868: BEGIN
869:
870: hr_utility.set_location('Entering: PAY_IE_EHECS_REPORT_PKG.archive_init: ',600);
871:
872: OPEN csr_archive_effective_date(p_payroll_action_id);
873: FETCH csr_archive_effective_date
874: INTO g_archive_effective_date;

Line 899: hr_utility.set_location(' Leaving PAY_IE_EHECS_REPORT_PKG.archive_init', 640);

895: setup_balance_table;
896:
897: hr_utility.set_location('After calling setup_balance_table ',630);
898:
899: hr_utility.set_location(' Leaving PAY_IE_EHECS_REPORT_PKG.archive_init', 640);
900:
901: EXCEPTION
902: WHEN Others THEN
903: hr_utility.set_location(' Leaving PAY_IE_EHECS_REPORT_PKG.archive_init with errors', 650);

Line 903: hr_utility.set_location(' Leaving PAY_IE_EHECS_REPORT_PKG.archive_init with errors', 650);

899: hr_utility.set_location(' Leaving PAY_IE_EHECS_REPORT_PKG.archive_init', 640);
900:
901: EXCEPTION
902: WHEN Others THEN
903: hr_utility.set_location(' Leaving PAY_IE_EHECS_REPORT_PKG.archive_init with errors', 650);
904: Hr_Utility.set_location('..'||'SQL-ERRM :'||SQLERRM,1211);
905:
906: END archive_init;
907: -----------------------------------------------------------------------

Line 916: hr_utility.set_location(' Entering PAY_IE_EHECS_REPORT_PKG.ARCHIVE_CODE: ',700);

912: IS
913:
914: BEGIN
915:
916: hr_utility.set_location(' Entering PAY_IE_EHECS_REPORT_PKG.ARCHIVE_CODE: ',700);
917: hr_utility.set_location('g_pact_id '||TO_CHAR(g_pact_id),700);
918: hr_utility.set_location('p_assignment_action_id '||TO_CHAR(p_assactid),700);
919:
920: NUll;

Line 922: hr_utility.set_location(' Leaving PAY_IE_EHECS_REPORT_PKG.ARCHIVE_CODE: ',700);

918: hr_utility.set_location('p_assignment_action_id '||TO_CHAR(p_assactid),700);
919:
920: NUll;
921:
922: hr_utility.set_location(' Leaving PAY_IE_EHECS_REPORT_PKG.ARCHIVE_CODE: ',700);
923:
924: END archive_data;
925:
926: PROCEDURE ehecs_main_proc(p_business_group_id IN VARCHAR2

Line 1051: hr_utility.set_location(' Entering PAY_IE_EHECS_REPORT_PKG.ehecs_main_proc', 800);

1047: l_al_bal_val number:=0;
1048: --------------------------- Variables which will hold the Balance Values.
1049:
1050: BEGIN
1051: hr_utility.set_location(' Entering PAY_IE_EHECS_REPORT_PKG.ehecs_main_proc', 800);
1052:
1053: /*6856473*/
1054: hr_utility.set_location(' before calling get parameters ', 800);
1055:

Line 1710: hr_utility.set_location(' Leaving PAY_IE_EHECS_REPORT_PKG.ehecs_main_proc', 910);

1706: hr_utility.set_location(' After Inserting PAY_US_RPT_TOTALS', 900);
1707:
1708: CLOSE cur_valid_asg;
1709:
1710: hr_utility.set_location(' Leaving PAY_IE_EHECS_REPORT_PKG.ehecs_main_proc', 910);
1711:
1712: END;
1713:
1714: -----------------------------------------------------------------------

Line 1726: Hr_Utility.set_location('Entering: PAY_IE_EHECS_REPORT_PKG.c2b',1000);

1722: buffer RAW( 32767 );
1723: res BLOB;
1724: lob_len PLS_INTEGER := DBMS_LOB.getLength( c );
1725: BEGIN
1726: Hr_Utility.set_location('Entering: PAY_IE_EHECS_REPORT_PKG.c2b',1000);
1727: DBMS_LOB.createTemporary( res, TRUE );
1728: DBMS_LOB.OPEN( res, DBMS_LOB.LOB_ReadWrite );
1729:
1730:

Line 1742: Hr_Utility.set_location('Leaving: PAY_IE_EHECS_REPORT_PKG.c2b',1010);

1738: pos := pos + 16000;
1739: EXIT WHEN pos > lob_len;
1740: END LOOP;
1741:
1742: Hr_Utility.set_location('Leaving: PAY_IE_EHECS_REPORT_PKG.c2b',1010);
1743: RETURN res; -- res is OPEN here
1744: END c2b;
1745: -----------------------------------------------------------------------
1746: -- GEN_BODY_XML

Line 1852: hr_utility.set_location('Inside PAY_IE_EHECS_REPORT_PKG.gen_header_xml,l_payroll_action_id: '||l_payroll_action_id,300);

1848: l_proc := g_package || 'gen_header_xml';
1849: hr_utility.set_location ('Entering '||l_proc,1500);
1850:
1851: l_payroll_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
1852: hr_utility.set_location('Inside PAY_IE_EHECS_REPORT_PKG.gen_header_xml,l_payroll_action_id: '||l_payroll_action_id,300);
1853:
1854: OPEN c_get_header(l_payroll_action_id);
1855: FETCH c_get_header into l_header;
1856: CLOSE c_get_header;

Line 2863: hr_utility.set_location('entering pay_ie_ehecs_report_pkg,gen_footer ',3000);

2859: l_is_gt_0 Varchar2(100);
2860:
2861: begin
2862:
2863: hr_utility.set_location('entering pay_ie_ehecs_report_pkg,gen_footer ',3000);
2864:
2865: l_payroll_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
2866: hr_utility.set_location('l_payroll_action_id. '||TO_CHAR(l_payroll_action_id),3010);
2867:

Line 5265: END PAY_IE_EHECS_REPORT_PKG;

5261: l_ovn NUMBER;
5262: begin
5263: null;
5264: end archive_deinit;
5265: END PAY_IE_EHECS_REPORT_PKG;