eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_APAC_PAYSLIP_ARCHIVE dependencies on PAY_APAC_PAYSLIP_ARCHIVE

Line 1: PACKAGE BODY pay_apac_payslip_archive AS

1: PACKAGE BODY pay_apac_payslip_archive AS
2: /* $Header: pyapacps.pkb 120.4 2007/10/15 06:19:29 jalin noship $ */
3: /*
4: ******************************************************************
5: * *

Line 20: Name : pay_apac_payslip_archive

16: * 500 Oracle Parkway, Redwood City, CA, 94065. *
17: * *
18: ******************************************************************
19:
20: Name : pay_apac_payslip_archive
21:
22: Description :This is a common package to archive the payroll
23: action level data for APAC countries SS payslip.
24: Different procedures defined are called by the

Line 96: WHERE org.org_information_context = pay_apac_payslip_archive.g_bg_context

92: org.org_information5,
93: org.org_information6,
94: org.org_information7
95: FROM hr_organization_information_v org
96: WHERE org.org_information_context = pay_apac_payslip_archive.g_bg_context
97: AND org.organization_id = p_business_group_id;
98:
99:
100: -- Cursor to fetch the balance name delcared at EIT and definded balance id

Line 181: IF (l_context = pay_apac_payslip_archive.g_balance_context) THEN

177: IF g_debug THEN
178: hr_utility.trace(' For context : l_context ........:'||l_context);
179: END IF;
180:
181: IF (l_context = pay_apac_payslip_archive.g_balance_context) THEN
182:
183: l_balance_index := l_balance_index+1;
184:
185: g_user_balance_table(l_balance_index).balance_type_id := csr_eit_rec.org_information4;

Line 228: END IF; -- l_context = pay_apac_payslip_archive.g_balance_context

224: , p_action_information4 => g_user_balance_table(l_balance_index).balance_narrative
225: );
226: END IF;
227:
228: END IF; -- l_context = pay_apac_payslip_archive.g_balance_context
229:
230: IF ( l_context = pay_apac_payslip_archive.g_element_context ) THEN
231:
232: l_element_type_id := csr_eit_rec.org_information2;

Line 230: IF ( l_context = pay_apac_payslip_archive.g_element_context ) THEN

226: END IF;
227:
228: END IF; -- l_context = pay_apac_payslip_archive.g_balance_context
229:
230: IF ( l_context = pay_apac_payslip_archive.g_element_context ) THEN
231:
232: l_element_type_id := csr_eit_rec.org_information2;
233: l_input_value_id := csr_eit_rec.org_information3;
234: l_element_narrative := csr_eit_rec.org_information7;

Line 282: END IF; -- l_context = l_context = pay_apac_payslip_archive.g_element_context

278: );
279:
280: END IF;
281:
282: END IF; -- l_context = l_context = pay_apac_payslip_archive.g_element_context
283: END LOOP;
284:
285: g_max_user_balance_index := l_balance_index;
286: g_max_user_element_index := l_element_index;

Line 355: FOR l_index IN 1 .. pay_apac_payslip_archive.g_max_user_balance_index LOOP

351: IF g_debug THEN
352: hr_utility.trace('Start of archive user balances');
353: END IF;
354:
355: FOR l_index IN 1 .. pay_apac_payslip_archive.g_max_user_balance_index LOOP
356:
357: /* Start of Bug No : 2518997 */
358:
359: OPEN csr_tax_unit_id(p_run_assignment_action_id);

Line 380: p_defined_balance_id => pay_apac_payslip_archive.g_user_balance_table(l_index).defined_balance_id

376: pay_balance_pkg.set_context('SOURCE_ID',l_source);
377: end if;
378:
379: l_balance_value := pay_balance_pkg.get_value (
380: p_defined_balance_id => pay_apac_payslip_archive.g_user_balance_table(l_index).defined_balance_id
381: ,p_assignment_action_id => p_run_assignment_action_id
382: );
383: -- Archive balance if non-zero
384:

Line 396: , p_action_information1 => pay_apac_payslip_archive.g_user_balance_table(l_index).defined_balance_id

392: , p_effective_date => p_pre_effective_date
393: , p_source_id => p_run_assignment_action_id
394: , p_source_text => NULL
395: , p_action_information_category => 'EMEA BALANCES'
396: , p_action_information1 => pay_apac_payslip_archive.g_user_balance_table(l_index).defined_balance_id
397: , p_action_information4 => fnd_number.number_to_canonical(l_balance_value) -- Bug 3604206
398: );
399:
400: END IF;

Line 671: pay_apac_payslip_archive.get_eit_definitions to archive the EIT balances

667: EIT's balances and elements into global table.
668: From archive_payroll_level_data it is called with p_archive='Y' to actually archive
669: the EIT's balances and elements.
670: This procedure internally calls the common
671: pay_apac_payslip_archive.get_eit_definitions to archive the EIT balances
672: and elements.
673: ********************************************************************************/
674:
675:

Line 696: pay_apac_payslip_archive.get_legislative_parameters

692: END IF;
693:
694: -- Get the legislative parameters of the archive request.
695:
696: pay_apac_payslip_archive.get_legislative_parameters
697: (p_payroll_action_id,
698: l_payroll_id,
699: l_consolidation_set_id,
700: l_business_group_id,

Line 710: pay_apac_payslip_archive.get_eit_definitions

706: l_canonical_end_date := TO_DATE(l_end_date,fnd_date.canonical_mask);
707:
708: l_business_group_id := to_number(l_business_group_id);
709:
710: pay_apac_payslip_archive.get_eit_definitions
711: ( p_payroll_action_id => p_payroll_action_id -- archival payroll_action_id
712: , p_business_group_id => l_business_group_id -- business group legislative parameter
713: , p_pre_payroll_action_id => NULL /* Bug No : 2613475 */
714: , p_pre_effective_date => l_canonical_start_date /* Bug No : 2613475 */

Line 1004: l_procedure := 'pay_apac_payslip_archive.deinitialization_code';

1000: l_procedure VARCHAR2(100);
1001: l_count NUMBER;
1002:
1003: BEGIN
1004: l_procedure := 'pay_apac_payslip_archive.deinitialization_code';
1005:
1006: IF g_debug THEN
1007: hr_utility.set_location(l_procedure, 10);
1008: END IF;

Line 1023: pay_apac_payslip_archive.range_code(p_payroll_action_id => p_payroll_action_id);

1019: END IF;
1020:
1021: IF (l_count = -1)
1022: THEN
1023: pay_apac_payslip_archive.range_code(p_payroll_action_id => p_payroll_action_id);
1024: IF g_debug THEN
1025: hr_utility.set_location(l_procedure, 20);
1026: END IF;
1027: END IF;

Line 1044: END pay_apac_payslip_archive; /* End Of the Package Body */

1040: g_balance_context := 'BALANCE';
1041: g_element_context := 'ELEMENT';
1042: g_bg_context := 'Business Group:Payslip Info';
1043:
1044: END pay_apac_payslip_archive; /* End Of the Package Body */