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.PQP_EXPREPLOD_PKG dependencies on PAY_BALANCE_PKG

Line 268: l_ret_value:=pay_balance_pkg.get_value(p_defined_balance_id,p_assignment_id,p_paydate );

264: OR p_comp_type= 'PC' OR p_comp_type= 'PP'
265: OR p_comp_type= 'QC' OR p_comp_type= 'YC') THEN
266: hr_utility.trace('Enter GB Legislation');
267: --l_ret_value:=hr_gbbal.calc_all_balances (p_paydate, p_assignment_id,p_defined_balance_id);
268: l_ret_value:=pay_balance_pkg.get_value(p_defined_balance_id,p_assignment_id,p_paydate );
269: --Commented out as we are using a wrapper after the bug was fixed for PTD dim.
270: -- l_ret_value:=hr_dirbal.get_balance(p_assignment_id,p_defined_balance_id,p_paydate );
271: hr_utility.trace('Leaving GB Legislation');
272: p_errmsg:='NOERROR' ;

Line 294: pay_balance_pkg.set_context ('SOURCE_TEXT2',l_component_name);

290: END LOOP;
291: CLOSE c_grename;*/
292:
293: IF l_instr_count2 > 0 and p_legislation_code = 'IN' THEN
294: pay_balance_pkg.set_context ('SOURCE_TEXT2',l_component_name);
295: END IF;
296:
297: --If the balance dimension has GRE in it then set the context to gre.
298: IF l_instr_count > 0 OR l_instr_count1 > 0 THEN

Line 299: --pay_balance_pkg.set_context ('TAX_UNIT_ID',NVL(g_gre_id,l_organization_id));

295: END IF;
296:
297: --If the balance dimension has GRE in it then set the context to gre.
298: IF l_instr_count > 0 OR l_instr_count1 > 0 THEN
299: --pay_balance_pkg.set_context ('TAX_UNIT_ID',NVL(g_gre_id,l_organization_id));
300: pay_balance_pkg.set_context ('TAX_UNIT_ID',NVL(g_gre_id,l_tax_unit_id));
301: END IF;
302: IF g_jd_code IS NOT NULL THEN
303: pay_balance_pkg.set_context('JURISDICTION_CODE',g_jd_code);

Line 300: pay_balance_pkg.set_context ('TAX_UNIT_ID',NVL(g_gre_id,l_tax_unit_id));

296:
297: --If the balance dimension has GRE in it then set the context to gre.
298: IF l_instr_count > 0 OR l_instr_count1 > 0 THEN
299: --pay_balance_pkg.set_context ('TAX_UNIT_ID',NVL(g_gre_id,l_organization_id));
300: pay_balance_pkg.set_context ('TAX_UNIT_ID',NVL(g_gre_id,l_tax_unit_id));
301: END IF;
302: IF g_jd_code IS NOT NULL THEN
303: pay_balance_pkg.set_context('JURISDICTION_CODE',g_jd_code);
304: END IF;

Line 303: pay_balance_pkg.set_context('JURISDICTION_CODE',g_jd_code);

299: --pay_balance_pkg.set_context ('TAX_UNIT_ID',NVL(g_gre_id,l_organization_id));
300: pay_balance_pkg.set_context ('TAX_UNIT_ID',NVL(g_gre_id,l_tax_unit_id));
301: END IF;
302: IF g_jd_code IS NOT NULL THEN
303: pay_balance_pkg.set_context('JURISDICTION_CODE',g_jd_code);
304: END IF;
305: hr_utility.trace('Entering US OR CA Legislation');
306: l_ret_value:=pay_balance_pkg.get_value(p_defined_balance_id,p_assignment_id,p_paydate );
307: hr_utility.trace('Leaving US OR CA Legislation');

Line 306: l_ret_value:=pay_balance_pkg.get_value(p_defined_balance_id,p_assignment_id,p_paydate );

302: IF g_jd_code IS NOT NULL THEN
303: pay_balance_pkg.set_context('JURISDICTION_CODE',g_jd_code);
304: END IF;
305: hr_utility.trace('Entering US OR CA Legislation');
306: l_ret_value:=pay_balance_pkg.get_value(p_defined_balance_id,p_assignment_id,p_paydate );
307: hr_utility.trace('Leaving US OR CA Legislation');
308: p_errmsg:='NOERROR' ;
309:
310: ELSIF (l_instr_count3 > 0 AND l_supported_loc = 'N') THEN

Line 320: pay_balance_pkg.set_context ('TAX_UNIT_ID',l_tax_unit);

316: AND sysdate BETWEEN paaf.effective_start_date AND paaf.effective_end_date;
317:
318: hr_utility.trace('Tax unit ID :'||l_tax_unit);
319: IF l_tax_unit IS NOT NULL THEN
320: pay_balance_pkg.set_context ('TAX_UNIT_ID',l_tax_unit);
321: END IF;
322: l_ret_value:=pay_balance_pkg.get_value(p_defined_balance_id,p_assignment_id,p_paydate );
323: hr_utility.trace('l_ret_value :'||l_ret_value);
324:

Line 322: l_ret_value:=pay_balance_pkg.get_value(p_defined_balance_id,p_assignment_id,p_paydate );

318: hr_utility.trace('Tax unit ID :'||l_tax_unit);
319: IF l_tax_unit IS NOT NULL THEN
320: pay_balance_pkg.set_context ('TAX_UNIT_ID',l_tax_unit);
321: END IF;
322: l_ret_value:=pay_balance_pkg.get_value(p_defined_balance_id,p_assignment_id,p_paydate );
323: hr_utility.trace('l_ret_value :'||l_ret_value);
324:
325: ELSE
326: -- Call the core get_balance pkg

Line 328: l_ret_value:=pay_balance_pkg.get_value(p_defined_balance_id,p_assignment_id,p_paydate );

324:
325: ELSE
326: -- Call the core get_balance pkg
327: hr_utility.trace('Entering General Legislation');
328: l_ret_value:=pay_balance_pkg.get_value(p_defined_balance_id,p_assignment_id,p_paydate );
329: hr_utility.trace('Leaving General Legislation');
330: p_errmsg:='NOERROR' ;
331: END IF;
332:

Line 413: pay_balance_pkg.set_context('JURISDICTION_CODE',g_jd_code);

409: FETCH c_get_in_comp_name INTO l_component_name;
410: CLOSE c_get_in_comp_name;
411:
412: IF g_jd_code IS NOT NULL THEN
413: pay_balance_pkg.set_context('JURISDICTION_CODE',g_jd_code);
414: END IF;
415:
416: --If the balance dimension has GRE in it then set the context to gre.
417: IF l_instr_count > 0 THEN

Line 419: pay_balance_pkg.set_context ('TAX_UNIT_ID',l_segment1);

415:
416: --If the balance dimension has GRE in it then set the context to gre.
417: IF l_instr_count > 0 THEN
418: if l_segment1 is not null then
419: pay_balance_pkg.set_context ('TAX_UNIT_ID',l_segment1);
420: l_ret_value1:=pay_balance_pkg.get_value(p_defined_balance_id,p_assignment_id,p_paydate );
421: end if;
422: if l_segment11 is not null then
423: pay_balance_pkg.set_context ('TAX_UNIT_ID',l_segment11);

Line 420: l_ret_value1:=pay_balance_pkg.get_value(p_defined_balance_id,p_assignment_id,p_paydate );

416: --If the balance dimension has GRE in it then set the context to gre.
417: IF l_instr_count > 0 THEN
418: if l_segment1 is not null then
419: pay_balance_pkg.set_context ('TAX_UNIT_ID',l_segment1);
420: l_ret_value1:=pay_balance_pkg.get_value(p_defined_balance_id,p_assignment_id,p_paydate );
421: end if;
422: if l_segment11 is not null then
423: pay_balance_pkg.set_context ('TAX_UNIT_ID',l_segment11);
424: l_ret_value11:=pay_balance_pkg.get_value(p_defined_balance_id,p_assignment_id,p_paydate );

Line 423: pay_balance_pkg.set_context ('TAX_UNIT_ID',l_segment11);

419: pay_balance_pkg.set_context ('TAX_UNIT_ID',l_segment1);
420: l_ret_value1:=pay_balance_pkg.get_value(p_defined_balance_id,p_assignment_id,p_paydate );
421: end if;
422: if l_segment11 is not null then
423: pay_balance_pkg.set_context ('TAX_UNIT_ID',l_segment11);
424: l_ret_value11:=pay_balance_pkg.get_value(p_defined_balance_id,p_assignment_id,p_paydate );
425: end if;
426: if l_segment12 is not null then
427: pay_balance_pkg.set_context ('TAX_UNIT_ID',l_segment12);

Line 424: l_ret_value11:=pay_balance_pkg.get_value(p_defined_balance_id,p_assignment_id,p_paydate );

420: l_ret_value1:=pay_balance_pkg.get_value(p_defined_balance_id,p_assignment_id,p_paydate );
421: end if;
422: if l_segment11 is not null then
423: pay_balance_pkg.set_context ('TAX_UNIT_ID',l_segment11);
424: l_ret_value11:=pay_balance_pkg.get_value(p_defined_balance_id,p_assignment_id,p_paydate );
425: end if;
426: if l_segment12 is not null then
427: pay_balance_pkg.set_context ('TAX_UNIT_ID',l_segment12);
428: l_ret_value12:=pay_balance_pkg.get_value(p_defined_balance_id,p_assignment_id,p_paydate );

Line 427: pay_balance_pkg.set_context ('TAX_UNIT_ID',l_segment12);

423: pay_balance_pkg.set_context ('TAX_UNIT_ID',l_segment11);
424: l_ret_value11:=pay_balance_pkg.get_value(p_defined_balance_id,p_assignment_id,p_paydate );
425: end if;
426: if l_segment12 is not null then
427: pay_balance_pkg.set_context ('TAX_UNIT_ID',l_segment12);
428: l_ret_value12:=pay_balance_pkg.get_value(p_defined_balance_id,p_assignment_id,p_paydate );
429: end if;
430: END IF;
431:

Line 428: l_ret_value12:=pay_balance_pkg.get_value(p_defined_balance_id,p_assignment_id,p_paydate );

424: l_ret_value11:=pay_balance_pkg.get_value(p_defined_balance_id,p_assignment_id,p_paydate );
425: end if;
426: if l_segment12 is not null then
427: pay_balance_pkg.set_context ('TAX_UNIT_ID',l_segment12);
428: l_ret_value12:=pay_balance_pkg.get_value(p_defined_balance_id,p_assignment_id,p_paydate );
429: end if;
430: END IF;
431:
432: p_errmsg:='NOERROR' ;