APPS.PAY_CA_EOY_RL2_ARCHIVE dependencies on PAY_BALANCE_PKG

Line 147: Notes : A defined balance_id is required call pay_balance_pkg.get_value.

143: Purpose : Given the name of a balance and balance dimension
144: the function returns the defined_balance_id .
145:
146: Arguments : balance_name,balance_dimension_name and legislation_code
147: Notes : A defined balance_id is required call pay_balance_pkg.get_value.
148: */
149:
150: Function get_def_bal_id ( p_balance_name varchar2,
151: p_balance_dimension varchar2,

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

2183: balances jurisdiction is always a context. */
2184:
2185: hr_utility.trace('max assignment_action_id : ' || to_char(l_aaid));
2186:
2187: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',l_aaid);
2188: pay_balance_pkg.set_context('JURISDICTION_CODE', l_jurisdiction);
2189:
2190: hr_utility.trace('Archiving the balance dbi ' || l_jurisdiction);
2191:

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

2184:
2185: hr_utility.trace('max assignment_action_id : ' || to_char(l_aaid));
2186:
2187: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',l_aaid);
2188: pay_balance_pkg.set_context('JURISDICTION_CODE', l_jurisdiction);
2189:
2190: hr_utility.trace('Archiving the balance dbi ' || l_jurisdiction);
2191:
2192: /* RL2 Slip number generation */

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

2391: l_prev_tax_unit_id is null then
2392:
2393: hr_utility.trace('l_business_group_id is '||to_char(l_business_group_id));
2394:
2395: pay_balance_pkg.set_context('TAX_UNIT_ID',l_tax_unit_id);
2396: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',l_aaid);
2397: Pay_balance_pkg.set_context('JURISDICTION_CODE', 'QC');
2398:
2399: for i in 1 .. l_count

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

2392:
2393: hr_utility.trace('l_business_group_id is '||to_char(l_business_group_id));
2394:
2395: pay_balance_pkg.set_context('TAX_UNIT_ID',l_tax_unit_id);
2396: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',l_aaid);
2397: Pay_balance_pkg.set_context('JURISDICTION_CODE', 'QC');
2398:
2399: for i in 1 .. l_count
2400: loop

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

2393: hr_utility.trace('l_business_group_id is '||to_char(l_business_group_id));
2394:
2395: pay_balance_pkg.set_context('TAX_UNIT_ID',l_tax_unit_id);
2396: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',l_aaid);
2397: Pay_balance_pkg.set_context('JURISDICTION_CODE', 'QC');
2398:
2399: for i in 1 .. l_count
2400: loop
2401:

Line 2444: nvl(pay_balance_pkg.get_value(ln_defined_balance_id,

2440: 'Person in JD within GRE Year to Date',
2441: 'CA');
2442:
2443: l_user_entity_value_tab(i) := l_user_entity_value_tab(i) +
2444: nvl(pay_balance_pkg.get_value(ln_defined_balance_id,
2445: l_aaid),0);
2446:
2447: if l_user_entity_value_tab(i) <> 0 then
2448: l_has_been_paid := 'Y';

Line 2759: pay_balance_pkg.set_context('TAX_UNIT_ID',

2755:
2756: if ( l_tax_unit_id <> l_prev_tax_unit_id or
2757: l_prev_tax_unit_id is null )
2758: then
2759: pay_balance_pkg.set_context('TAX_UNIT_ID',
2760: l_tax_unit_id);
2761: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',
2762: l_aaid);
2763: pay_balance_pkg.set_context('JURISDICTION_CODE', 'QC');

Line 2761: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',

2757: l_prev_tax_unit_id is null )
2758: then
2759: pay_balance_pkg.set_context('TAX_UNIT_ID',
2760: l_tax_unit_id);
2761: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',
2762: l_aaid);
2763: pay_balance_pkg.set_context('JURISDICTION_CODE', 'QC');
2764:
2765: l_footnote_amount := l_footnote_amount +

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

2759: pay_balance_pkg.set_context('TAX_UNIT_ID',
2760: l_tax_unit_id);
2761: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',
2762: l_aaid);
2763: pay_balance_pkg.set_context('JURISDICTION_CODE', 'QC');
2764:
2765: l_footnote_amount := l_footnote_amount +
2766: nvl(pay_ca_balance_pkg.call_ca_balance_get_value
2767: ( l_footnote_balance,