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_CA_EOY_RL2_ARCHIVE dependencies on PAY_BALANCE_PKG

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

182: Purpose : Given the name of a balance and balance dimension
183: the function returns the defined_balance_id .
184:
185: Arguments : balance_name,balance_dimension_name and legislation_code
186: Notes : A defined balance_id is required call pay_balance_pkg.get_value.
187: */
188:
189: Function get_def_bal_id ( p_balance_name varchar2,
190: p_balance_dimension varchar2,

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

2269: balances jurisdiction is always a context. */
2270:
2271: hr_utility.trace('max assignment_action_id : ' || to_char(l_aaid));
2272:
2273: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',l_aaid);
2274: pay_balance_pkg.set_context('JURISDICTION_CODE', l_jurisdiction);
2275:
2276: hr_utility.trace('Archiving the balance dbi ' || l_jurisdiction);
2277:

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

2270:
2271: hr_utility.trace('max assignment_action_id : ' || to_char(l_aaid));
2272:
2273: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',l_aaid);
2274: pay_balance_pkg.set_context('JURISDICTION_CODE', l_jurisdiction);
2275:
2276: hr_utility.trace('Archiving the balance dbi ' || l_jurisdiction);
2277:
2278: /* Initialise the PL/SQL table before populating it */

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

2366:
2367: hr_utility.trace('l_aaid is ' || to_char(l_aaid));
2368: hr_utility.trace('l_count is ' || to_char(l_count));
2369:
2370: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',l_aaid);
2371: pay_balance_pkg.set_context('JURISDICTION_CODE', l_jurisdiction);
2372: result := result + nvl(pay_ca_balance_pkg.call_ca_balance_get_value
2373: ( l_balance_type_tab(i),
2374: 'YTD' ,

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

2367: hr_utility.trace('l_aaid is ' || to_char(l_aaid));
2368: hr_utility.trace('l_count is ' || to_char(l_count));
2369:
2370: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',l_aaid);
2371: pay_balance_pkg.set_context('JURISDICTION_CODE', l_jurisdiction);
2372: result := result + nvl(pay_ca_balance_pkg.call_ca_balance_get_value
2373: ( l_balance_type_tab(i),
2374: 'YTD' ,
2375: l_aaid,

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

2889: balances jurisdiction is always a context. */
2890:
2891: hr_utility.trace('max assignment_action_id : ' || to_char(l_aaid));
2892:
2893: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',l_aaid);
2894: pay_balance_pkg.set_context('JURISDICTION_CODE', l_jurisdiction);
2895:
2896: hr_utility.trace('Archiving the balance dbi ' || l_jurisdiction);
2897:

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

2890:
2891: hr_utility.trace('max assignment_action_id : ' || to_char(l_aaid));
2892:
2893: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',l_aaid);
2894: pay_balance_pkg.set_context('JURISDICTION_CODE', l_jurisdiction);
2895:
2896: hr_utility.trace('Archiving the balance dbi ' || l_jurisdiction);
2897:
2898: /* 14701748 */

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

3106: l_prev_tax_unit_id is null then
3107:
3108: hr_utility.trace('l_business_group_id is '||to_char(l_business_group_id));
3109:
3110: pay_balance_pkg.set_context('TAX_UNIT_ID',l_tax_unit_id);
3111: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',l_aaid);
3112: Pay_balance_pkg.set_context('JURISDICTION_CODE', 'QC');
3113:
3114: for i in 1 .. l_count

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

3107:
3108: hr_utility.trace('l_business_group_id is '||to_char(l_business_group_id));
3109:
3110: pay_balance_pkg.set_context('TAX_UNIT_ID',l_tax_unit_id);
3111: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',l_aaid);
3112: Pay_balance_pkg.set_context('JURISDICTION_CODE', 'QC');
3113:
3114: for i in 1 .. l_count
3115: loop

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

3108: hr_utility.trace('l_business_group_id is '||to_char(l_business_group_id));
3109:
3110: pay_balance_pkg.set_context('TAX_UNIT_ID',l_tax_unit_id);
3111: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',l_aaid);
3112: Pay_balance_pkg.set_context('JURISDICTION_CODE', 'QC');
3113:
3114: for i in 1 .. l_count
3115: loop
3116:

Line 3159: nvl(pay_balance_pkg.get_value(ln_defined_balance_id,

3155: 'Person in JD within GRE Year to Date',
3156: 'CA');
3157:
3158: l_user_entity_value_tab(i) := l_user_entity_value_tab(i) +
3159: nvl(pay_balance_pkg.get_value(ln_defined_balance_id,
3160: l_aaid),0);
3161:
3162: if l_user_entity_value_tab(i) <> 0 then
3163: l_has_been_paid := 'Y';

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

3213: close c_get_max_asg_act_id;
3214:
3215: hr_utility.trace('l_aaid is ' || to_char(l_aaid));
3216: hr_utility.trace('l_count_fi is ' || to_char(l_count_fi));
3217: pay_balance_pkg.set_context('TAX_UNIT_ID',l_tax_unit_id);
3218: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',l_aaid);
3219: Pay_balance_pkg.set_context('JURISDICTION_CODE', 'QC');
3220: l_fi_result := l_fi_result + nvl(pay_ca_balance_pkg.call_ca_balance_get_value
3221: ( l_fi_balance_type_tab(i),

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

3214:
3215: hr_utility.trace('l_aaid is ' || to_char(l_aaid));
3216: hr_utility.trace('l_count_fi is ' || to_char(l_count_fi));
3217: pay_balance_pkg.set_context('TAX_UNIT_ID',l_tax_unit_id);
3218: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',l_aaid);
3219: Pay_balance_pkg.set_context('JURISDICTION_CODE', 'QC');
3220: l_fi_result := l_fi_result + nvl(pay_ca_balance_pkg.call_ca_balance_get_value
3221: ( l_fi_balance_type_tab(i),
3222: 'YTD' ,

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

3215: hr_utility.trace('l_aaid is ' || to_char(l_aaid));
3216: hr_utility.trace('l_count_fi is ' || to_char(l_count_fi));
3217: pay_balance_pkg.set_context('TAX_UNIT_ID',l_tax_unit_id);
3218: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',l_aaid);
3219: Pay_balance_pkg.set_context('JURISDICTION_CODE', 'QC');
3220: l_fi_result := l_fi_result + nvl(pay_ca_balance_pkg.call_ca_balance_get_value
3221: ( l_fi_balance_type_tab(i),
3222: 'YTD' ,
3223: l_aaid,

Line 3531: pay_balance_pkg.set_context('TAX_UNIT_ID',

3527:
3528: if ( l_tax_unit_id <> l_prev_tax_unit_id or
3529: l_prev_tax_unit_id is null )
3530: then
3531: pay_balance_pkg.set_context('TAX_UNIT_ID',
3532: l_tax_unit_id);
3533: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',
3534: l_aaid);
3535: pay_balance_pkg.set_context('JURISDICTION_CODE', 'QC');

Line 3533: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',

3529: l_prev_tax_unit_id is null )
3530: then
3531: pay_balance_pkg.set_context('TAX_UNIT_ID',
3532: l_tax_unit_id);
3533: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',
3534: l_aaid);
3535: pay_balance_pkg.set_context('JURISDICTION_CODE', 'QC');
3536:
3537: l_footnote_amount := l_footnote_amount +

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

3531: pay_balance_pkg.set_context('TAX_UNIT_ID',
3532: l_tax_unit_id);
3533: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',
3534: l_aaid);
3535: pay_balance_pkg.set_context('JURISDICTION_CODE', 'QC');
3536:
3537: l_footnote_amount := l_footnote_amount +
3538: nvl(pay_ca_balance_pkg.call_ca_balance_get_value
3539: ( l_footnote_balance,