DBA Data[Home] [Help]

APPS.PAY_CA_EOY_RL1_ARCHIVE dependencies on PAY_BALANCE_PKG

Line 2730: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',l_aaid);

2726: into l_business_group_id
2727: from hr_all_organization_units target1
2728: where target1.organization_id = l_tax_unit_id;
2729:
2730: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',l_aaid);
2731: pay_balance_pkg.set_context('JURISDICTION_CODE', l_jurisdiction);
2732: result := result+nvl(pay_ca_balance_pkg.call_ca_balance_get_value
2733: ( l_balance_type_tab(i),
2734: 'YTD' ,

Line 2731: pay_balance_pkg.set_context('JURISDICTION_CODE', l_jurisdiction);

2727: from hr_all_organization_units target1
2728: where target1.organization_id = l_tax_unit_id;
2729:
2730: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',l_aaid);
2731: pay_balance_pkg.set_context('JURISDICTION_CODE', l_jurisdiction);
2732: result := result+nvl(pay_ca_balance_pkg.call_ca_balance_get_value
2733: ( l_balance_type_tab(i),
2734: 'YTD' ,
2735: l_aaid,

Line 3358: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',l_aaid);

3354: balances jurisdiction is always a context. */
3355:
3356: hr_utility.trace('max assignment_action_id : ' || to_char(l_aaid));
3357:
3358: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',l_aaid);
3359: pay_balance_pkg.set_context('JURISDICTION_CODE', l_jurisdiction);
3360:
3361: hr_utility.trace('Archiving the balance dbi ' || l_jurisdiction);
3362: /* RL1 Slip number generation part has been moved

Line 3359: pay_balance_pkg.set_context('JURISDICTION_CODE', l_jurisdiction);

3355:
3356: hr_utility.trace('max assignment_action_id : ' || to_char(l_aaid));
3357:
3358: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',l_aaid);
3359: pay_balance_pkg.set_context('JURISDICTION_CODE', l_jurisdiction);
3360:
3361: hr_utility.trace('Archiving the balance dbi ' || l_jurisdiction);
3362: /* RL1 Slip number generation part has been moved
3363: as a seperate function for bug 13564765*/

Line 3687: pay_balance_pkg.set_context('TAX_UNIT_ID',l_tax_unit_id);

3683: l_prev_tax_unit_id is null then
3684:
3685: hr_utility.trace('l_business_group_id is '||l_business_group_id);
3686:
3687: pay_balance_pkg.set_context('TAX_UNIT_ID',l_tax_unit_id);
3688: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',l_aaid);
3689: Pay_balance_pkg.set_context('JURISDICTION_CODE', 'QC');
3690:
3691: for i in 1 .. l_count

Line 3688: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',l_aaid);

3684:
3685: hr_utility.trace('l_business_group_id is '||l_business_group_id);
3686:
3687: pay_balance_pkg.set_context('TAX_UNIT_ID',l_tax_unit_id);
3688: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',l_aaid);
3689: Pay_balance_pkg.set_context('JURISDICTION_CODE', 'QC');
3690:
3691: for i in 1 .. l_count
3692: loop

Line 3689: Pay_balance_pkg.set_context('JURISDICTION_CODE', 'QC');

3685: hr_utility.trace('l_business_group_id is '||l_business_group_id);
3686:
3687: pay_balance_pkg.set_context('TAX_UNIT_ID',l_tax_unit_id);
3688: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',l_aaid);
3689: Pay_balance_pkg.set_context('JURISDICTION_CODE', 'QC');
3690:
3691: for i in 1 .. l_count
3692: loop
3693:

Line 3991: pay_balance_pkg.set_context('TAX_UNIT_ID',

3987: then
3988: hr_utility.trace('l_business_group_id is ' ||
3989: l_business_group_id);
3990:
3991: pay_balance_pkg.set_context('TAX_UNIT_ID',
3992: l_ft_tax_unit_id);
3993: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',
3994: l_ft_aaid);
3995: pay_balance_pkg.set_context('JURISDICTION_CODE', 'QC');

Line 3993: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',

3989: l_business_group_id);
3990:
3991: pay_balance_pkg.set_context('TAX_UNIT_ID',
3992: l_ft_tax_unit_id);
3993: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',
3994: l_ft_aaid);
3995: pay_balance_pkg.set_context('JURISDICTION_CODE', 'QC');
3996:
3997: l_footnote_amount := l_footnote_amount +

Line 3995: pay_balance_pkg.set_context('JURISDICTION_CODE', 'QC');

3991: pay_balance_pkg.set_context('TAX_UNIT_ID',
3992: l_ft_tax_unit_id);
3993: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',
3994: l_ft_aaid);
3995: pay_balance_pkg.set_context('JURISDICTION_CODE', 'QC');
3996:
3997: l_footnote_amount := l_footnote_amount +
3998: nvl(pay_ca_balance_pkg.call_ca_balance_get_value
3999: ( l_footnote_balance,