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.11.12010000.2 2008/08/06 07:03:06 ubhat 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 616: , pay_cn_payslip.get_exchange_rate(pet.input_currency_code

612: ) classification_name
613: , sum(decode(substr(piv.uom,1,1), 'M', fnd_number.canonical_to_number(prrv.result_value), null)) amount
614: , decode(pet.input_currency_code, 'CNY',NULL
615: , pet.input_currency_code) foreign_currency_code
616: , pay_cn_payslip.get_exchange_rate(pet.input_currency_code
617: ,pet.output_currency_code
618: ,ppa.effective_date
619: ,ppa.business_group_id
620: ) exchange_rate

Line 683: , pay_cn_payslip.get_exchange_rate(pet.input_currency_code

679: )
680: , nvl(petl.reporting_name,petl.element_name)
681: , pet.processing_priority
682: , pet.input_currency_code
683: , pay_cn_payslip.get_exchange_rate(pet.input_currency_code
684: ,pet.output_currency_code
685: ,ppa.effective_date
686: , ppa.business_group_id
687: );

Line 823: pay_cn_payslip.get_run_result_value (

819: --
820: l_procedure := g_package || '.archive_special_elements';
821: hr_utility.set_location('Entering ' || l_procedure,10);
822:
823: pay_cn_payslip.get_run_result_value (
824: p_assignment_action_id => p_assignment_action_id
825: ,p_element_name => p_element_name
826: ,p_input_value_name => p_input_value_name
827: ,p_value => l_value

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

1130: -- --
1131: -- Name : ARCHIVE_STAT_BALANCES --
1132: -- Type : PROCEDURE --
1133: -- Access : Private --
1134: -- Description : This procedure calls pay_cn_payslip.balance_totals --
1135: -- to get the current and YTD values of the following --
1136: -- balances --
1137: -- 1. Taxable Earnings --
1138: -- 2. Non Taxable Earnings --

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

1216: BEGIN
1217: --
1218: l_procedure := g_package || '.archive_stat_balances';
1219: hr_utility.set_location('Entering ' || l_procedure,10);
1220: hr_utility.set_location('Calling balance_total from pay_cn_payslip',20);
1221:
1222: -- Get the totals of all the balances
1223:
1224: pay_cn_payslip.balance_totals(

Line 1224: pay_cn_payslip.balance_totals(

1220: hr_utility.set_location('Calling balance_total from pay_cn_payslip',20);
1221:
1222: -- Get the totals of all the balances
1223:
1224: pay_cn_payslip.balance_totals(
1225: p_prepaid_tag => 'Y'
1226: ,p_assignment_action_id => p_assignment_action_id
1227: ,p_taxable_earnings_current => l_taxable_earnings_current
1228: ,p_non_taxable_earnings_current => l_non_taxable_earnings_current

Line 1334: pay_cn_payslip.current_and_ytd_balances (

1330: FETCH csr_balance_rpt_name INTO l_balance_rpt_name;
1331: CLOSE csr_balance_rpt_name;
1332: hr_utility.set_location('Archiving value for ' || l_balance_rpt_name,40);
1333:
1334: pay_cn_payslip.current_and_ytd_balances (
1335: p_prepaid_tag => 'Y'
1336: ,p_assignment_action_id => p_assact_id
1337: ,p_balance_name => l_narrative
1338: ,p_current_balance => l_annual_bonus_current

Line 1360: pay_cn_payslip.current_and_ytd_balances (

1356: FETCH csr_balance_rpt_name INTO l_balance_rpt_name;
1357: CLOSE csr_balance_rpt_name;
1358: hr_utility.set_location('Archiving value for ' || l_balance_rpt_name,45);
1359:
1360: pay_cn_payslip.current_and_ytd_balances (
1361: p_prepaid_tag => 'Y'
1362: ,p_assignment_action_id => p_assact_id
1363: ,p_balance_name => l_narrative
1364: ,p_current_balance => l_retro_ann_bonus_current

Line 1385: pay_cn_payslip.current_and_ytd_balances (

1381: FETCH csr_balance_rpt_name INTO l_balance_rpt_name;
1382: CLOSE csr_balance_rpt_name;
1383: hr_utility.set_location('Archiving value for ' || l_balance_rpt_name,45);
1384:
1385: pay_cn_payslip.current_and_ytd_balances (
1386: p_prepaid_tag => 'Y'
1387: ,p_assignment_action_id => p_assact_id
1388: ,p_balance_name => l_narrative
1389: ,p_current_balance => l_tax_ann_bonus_current

Line 2253: END pay_cn_payslip_archive;

2249: RAISE;
2250: --
2251: END archive_code;
2252: --
2253: END pay_cn_payslip_archive;