APPS.PAY_CN_PAYSLIP_ARCHIVE dependencies on PAY_CN_PAYSLIP

Line 1: PACKAGE BODY pay_cn_payslip_archive AS

1: PACKAGE BODY pay_cn_payslip_archive AS
2: /* $Header: pycnparc.pkb 120.16.12020000.2 2012/08/06 13:41:09 mdubasi ship $ */
3:
4: ----------------------------------------------------------------------+
5: -- This is a global variable used to store Archive assignment action id

Line 9: g_package CONSTANT VARCHAR2(100) := 'pay_cn_payslip_archive';

5: -- This is a global variable used to store Archive assignment action id
6: ----------------------------------------------------------------------+
7:
8: g_archive_pact NUMBER;
9: g_package CONSTANT VARCHAR2(100) := 'pay_cn_payslip_archive';
10:
11: --------------------------------------------------------------------------
12: -- --
13: -- Name : RANGE_CODE --

Line 714: , pay_cn_payslip.get_exchange_rate(pet.input_currency_code

710: ) classification_name
711: , sum(decode(substr(piv.uom,1,1), 'M', fnd_number.canonical_to_number(prrv.result_value), null)) amount
712: , decode(pet.input_currency_code, 'CNY',NULL
713: , pet.input_currency_code) foreign_currency_code
714: , pay_cn_payslip.get_exchange_rate(pet.input_currency_code
715: ,pet.output_currency_code
716: ,ppa.effective_date
717: ,ppa.business_group_id
718: ) exchange_rate

Line 785: , pay_cn_payslip.get_exchange_rate(pet.input_currency_code

781: )
782: , nvl(petl.reporting_name,petl.element_name)
783: , pet.processing_priority
784: , pet.input_currency_code
785: , pay_cn_payslip.get_exchange_rate(pet.input_currency_code
786: ,pet.output_currency_code
787: ,ppa.effective_date
788: , ppa.business_group_id
789: );

Line 925: pay_cn_payslip.get_run_result_value (

921: --
922: l_procedure := g_package || '.archive_special_elements';
923: hr_utility.set_location('Entering ' || l_procedure,10);
924:
925: pay_cn_payslip.get_run_result_value (
926: p_assignment_action_id => p_assignment_action_id
927: ,p_element_name => p_element_name
928: ,p_input_value_name => p_input_value_name
929: ,p_value => l_value

Line 1236: -- Description : This procedure calls pay_cn_payslip.balance_totals --

1232: -- --
1233: -- Name : ARCHIVE_STAT_BALANCES --
1234: -- Type : PROCEDURE --
1235: -- Access : Private --
1236: -- Description : This procedure calls pay_cn_payslip.balance_totals --
1237: -- to get the current and YTD values of the following --
1238: -- balances --
1239: -- 1. Taxable Earnings --
1240: -- 2. Non Taxable Earnings --

Line 1326: hr_utility.set_location('Calling balance_total from pay_cn_payslip',20);

1322: BEGIN
1323: --
1324: l_procedure := g_package || '.archive_stat_balances';
1325: hr_utility.set_location('Entering ' || l_procedure,10);
1326: hr_utility.set_location('Calling balance_total from pay_cn_payslip',20);
1327:
1328: -- Get the totals of all the balances
1329:
1330: pay_cn_payslip.balance_totals(

Line 1330: pay_cn_payslip.balance_totals(

1326: hr_utility.set_location('Calling balance_total from pay_cn_payslip',20);
1327:
1328: -- Get the totals of all the balances
1329:
1330: pay_cn_payslip.balance_totals(
1331: p_prepaid_tag => 'Y'
1332: ,p_assignment_action_id => p_assignment_action_id
1333: ,p_taxable_earnings_current => l_taxable_earnings_current
1334: ,p_non_taxable_earnings_current => l_non_taxable_earnings_current

Line 1462: pay_cn_payslip.current_and_ytd_balances (

1458: FETCH csr_balance_rpt_name INTO l_balance_rpt_name;
1459: CLOSE csr_balance_rpt_name;
1460: hr_utility.set_location('Archiving value for ' || l_balance_rpt_name,40);
1461:
1462: pay_cn_payslip.current_and_ytd_balances (
1463: p_prepaid_tag => 'Y'
1464: ,p_assignment_action_id => p_assact_id
1465: ,p_balance_name => l_narrative
1466: ,p_current_balance => l_annual_bonus_current

Line 1488: pay_cn_payslip.current_and_ytd_balances (

1484: FETCH csr_balance_rpt_name INTO l_balance_rpt_name;
1485: CLOSE csr_balance_rpt_name;
1486: hr_utility.set_location('Archiving value for ' || l_balance_rpt_name,45);
1487:
1488: pay_cn_payslip.current_and_ytd_balances (
1489: p_prepaid_tag => 'Y'
1490: ,p_assignment_action_id => p_assact_id
1491: ,p_balance_name => l_narrative
1492: ,p_current_balance => l_retro_ann_bonus_current

Line 1513: pay_cn_payslip.current_and_ytd_balances (

1509: FETCH csr_balance_rpt_name INTO l_balance_rpt_name;
1510: CLOSE csr_balance_rpt_name;
1511: hr_utility.set_location('Archiving value for ' || l_balance_rpt_name,45);
1512:
1513: pay_cn_payslip.current_and_ytd_balances (
1514: p_prepaid_tag => 'Y'
1515: ,p_assignment_action_id => p_assact_id
1516: ,p_balance_name => l_narrative
1517: ,p_current_balance => l_tax_ann_bonus_current

Line 2381: END pay_cn_payslip_archive;

2377: RAISE;
2378: --
2379: END archive_code;
2380: --
2381: END pay_cn_payslip_archive;