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.17 2011/03/31 10:05:41 abraghun 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.17 2011/03/31 10:05:41 abraghun 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 928: hr_utility.set_location('Entering PAY_IE_EHECS_REPORT_PKG.assignment_action_code',500);

924: l_ass_check varchar2(1);
925: l_csr_already_archived pay_element_entry_values_f.screen_entry_value%TYPE := 'N';
926: BEGIN
927:
928: hr_utility.set_location('Entering PAY_IE_EHECS_REPORT_PKG.assignment_action_code',500);
929:
930: -- Get all the parameters
931: /*6978389 */
932: hr_utility.set_location('Before get_all_parameters',501);

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

1040: WHERE payroll_action_id = pactid;
1041:
1042: BEGIN
1043:
1044: hr_utility.set_location('Entering: PAY_IE_EHECS_REPORT_PKG.archive_init: ',600);
1045:
1046: OPEN csr_archive_effective_date(p_payroll_action_id);
1047: FETCH csr_archive_effective_date
1048: INTO g_archive_effective_date;

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

1069: setup_balance_table;
1070:
1071: hr_utility.set_location('After calling setup_balance_table ',630);
1072:
1073: hr_utility.set_location(' Leaving PAY_IE_EHECS_REPORT_PKG.archive_init', 640);
1074:
1075: EXCEPTION
1076: WHEN Others THEN
1077: hr_utility.set_location(' Leaving PAY_IE_EHECS_REPORT_PKG.archive_init with errors', 650);

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

1073: hr_utility.set_location(' Leaving PAY_IE_EHECS_REPORT_PKG.archive_init', 640);
1074:
1075: EXCEPTION
1076: WHEN Others THEN
1077: hr_utility.set_location(' Leaving PAY_IE_EHECS_REPORT_PKG.archive_init with errors', 650);
1078: Hr_Utility.set_location('..'||'SQL-ERRM :'||SQLERRM,1211);
1079:
1080: END archive_init;
1081: -----------------------------------------------------------------------

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

1086: IS
1087:
1088: BEGIN
1089:
1090: hr_utility.set_location(' Entering PAY_IE_EHECS_REPORT_PKG.ARCHIVE_CODE: ',700);
1091: hr_utility.set_location('g_pact_id '||TO_CHAR(g_pact_id),700);
1092: hr_utility.set_location('p_assignment_action_id '||TO_CHAR(p_assactid),700);
1093:
1094: NUll;

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

1092: hr_utility.set_location('p_assignment_action_id '||TO_CHAR(p_assactid),700);
1093:
1094: NUll;
1095:
1096: hr_utility.set_location(' Leaving PAY_IE_EHECS_REPORT_PKG.ARCHIVE_CODE: ',700);
1097:
1098: END archive_data;
1099:
1100: PROCEDURE ehecs_main_proc(p_business_group_id IN VARCHAR2

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

1271:
1272: l_factor NUMBER :=1; /* 10040939 */
1273:
1274: BEGIN
1275: hr_utility.set_location(' Entering PAY_IE_EHECS_REPORT_PKG.ehecs_main_proc', 800);
1276:
1277: /*6856473*/
1278: hr_utility.set_location(' before calling get parameters ', 800);
1279:

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

1989: hr_utility.set_location(' After Inserting PAY_US_RPT_TOTALS', 900);
1990:
1991: CLOSE cur_valid_asg;
1992:
1993: hr_utility.set_location(' Leaving PAY_IE_EHECS_REPORT_PKG.ehecs_main_proc', 910);
1994:
1995: END;
1996:
1997: -----------------------------------------------------------------------

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

2005: buffer RAW( 32767 );
2006: res BLOB;
2007: lob_len PLS_INTEGER := DBMS_LOB.getLength( c );
2008: BEGIN
2009: Hr_Utility.set_location('Entering: PAY_IE_EHECS_REPORT_PKG.c2b',1000);
2010: DBMS_LOB.createTemporary( res, TRUE );
2011: DBMS_LOB.OPEN( res, DBMS_LOB.LOB_ReadWrite );
2012:
2013:

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

2021: pos := pos + 16000;
2022: EXIT WHEN pos > lob_len;
2023: END LOOP;
2024:
2025: Hr_Utility.set_location('Leaving: PAY_IE_EHECS_REPORT_PKG.c2b',1010);
2026: RETURN res; -- res is OPEN here
2027: END c2b;
2028: -----------------------------------------------------------------------
2029: -- GEN_BODY_XML

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

2131: l_proc := g_package || 'gen_header_xml';
2132: hr_utility.set_location ('Entering '||l_proc,1500);
2133:
2134: l_payroll_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
2135: hr_utility.set_location('Inside PAY_IE_EHECS_REPORT_PKG.gen_header_xml,l_payroll_action_id: '||l_payroll_action_id,300);
2136:
2137: OPEN c_get_header(l_payroll_action_id);
2138: FETCH c_get_header into l_header;
2139: CLOSE c_get_header;

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

3146: l_is_gt_0 Varchar2(100);
3147:
3148: begin
3149:
3150: hr_utility.set_location('entering pay_ie_ehecs_report_pkg,gen_footer ',3000);
3151:
3152: l_payroll_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
3153: hr_utility.set_location('l_payroll_action_id. '||TO_CHAR(l_payroll_action_id),3010);
3154:

Line 5569: END PAY_IE_EHECS_REPORT_PKG;

5565: l_ovn NUMBER;
5566: begin
5567: null;
5568: end archive_deinit;
5569: END PAY_IE_EHECS_REPORT_PKG;