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.12010000.3 2009/03/13 07:30:27 mdubasi ship $ */
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 98: WHERE org.org_information_context = pay_apac_payslip_archive.g_bg_context

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 673: pay_apac_payslip_archive.get_eit_definitions to archive the EIT balances

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

Line 698: pay_apac_payslip_archive.get_legislative_parameters

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

Line 712: pay_apac_payslip_archive.get_eit_definitions

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

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

1023: l_procedure VARCHAR2(100);
1024: l_count NUMBER;
1025:
1026: BEGIN
1027: l_procedure := 'pay_apac_payslip_archive.deinitialization_code';
1028:
1029: IF g_debug THEN
1030: hr_utility.set_location(l_procedure, 10);
1031: END IF;

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

1042: END IF;
1043:
1044: IF (l_count = -1)
1045: THEN
1046: pay_apac_payslip_archive.range_code(p_payroll_action_id => p_payroll_action_id);
1047: IF g_debug THEN
1048: hr_utility.set_location(l_procedure, 20);
1049: END IF;
1050: END IF;

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

1063: g_balance_context := 'BALANCE';
1064: g_element_context := 'ELEMENT';
1065: g_bg_context := 'Business Group:Payslip Info';
1066:
1067: END pay_apac_payslip_archive; /* End Of the Package Body */