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_BALANCE_PKG dependencies on PAY_CA_BALANCE_VIEW_PKG

Line 56: pay_ca_balance_view_pkg, except

52: JARTHURT 28-JAN-2000 110.9 Correct building of dimension
53: suffix string.
54: RThirlby 11-FEB-2000 115.10 Changed all references to
55: pay_us_balance_view_pkg to
56: pay_ca_balance_view_pkg, except
57: for calls to debug procedures.
58: Added new procedure payments_bal-
59: ance_required. (This is a copy
60: from pay_us_taxbal_view_pkg).

Line 187: l_bal_value := l_bal_value + pay_ca_balance_view_pkg.get_value

183: CLOSE csr_check_sep_chk;
184:
185: IF l_check_sep_chk_aa = 1 THEN
186:
187: l_bal_value := l_bal_value + pay_ca_balance_view_pkg.get_value
188: (p_run_action_id
189: ,p_defined_balance_id);
190:
191: ELSE

Line 199: l_bal_value := l_bal_value + pay_ca_balance_view_pkg.get_value

195: CLOSE csr_get_prepay_id;
196:
197: FOR v_runs IN csr_get_aa_ids(l_prepay_action_id) LOOP
198:
199: l_bal_value := l_bal_value + pay_ca_balance_view_pkg.get_value
200: (v_runs.locked_action_id,
201: p_defined_balance_id);
202:
203: END LOOP;

Line 316: pay_ca_balance_view_pkg.set_context('TAX_UNIT_ID',

312:
313: --
314: --Set contexts
315: --
316: pay_ca_balance_view_pkg.set_context('TAX_UNIT_ID',
317: p_gre_id);
318: pay_balance_pkg.set_context('TAX_UNIT_ID', p_gre_id);
319:
320: IF p_jurisdiction_code IS NULL THEN

Line 321: l_jd_context := nvl(pay_ca_balance_view_pkg.get_session_var

317: p_gre_id);
318: pay_balance_pkg.set_context('TAX_UNIT_ID', p_gre_id);
319:
320: IF p_jurisdiction_code IS NULL THEN
321: l_jd_context := nvl(pay_ca_balance_view_pkg.get_session_var
322: ('JURISDICTION_CODE'), 'Not_Set');
323: ELSE
324: l_jd_context := p_jurisdiction_code;
325: END IF;

Line 352: pay_ca_balance_view_pkg.set_session_var('REPORT_LEVEL','ASG');

348: -- derive the dimension_suffix
349: -- set session var REPORT_LEVEL to default of ASG if not already set.
350: --
351: IF p_report_level IS NULL THEN
352: pay_ca_balance_view_pkg.set_session_var('REPORT_LEVEL','ASG');
353:
354: l_report_level :=
355: pay_ca_balance_view_pkg.get_session_var('REPORT_LEVEL')||'_';
356: ELSE

Line 355: pay_ca_balance_view_pkg.get_session_var('REPORT_LEVEL')||'_';

351: IF p_report_level IS NULL THEN
352: pay_ca_balance_view_pkg.set_session_var('REPORT_LEVEL','ASG');
353:
354: l_report_level :=
355: pay_ca_balance_view_pkg.get_session_var('REPORT_LEVEL')||'_';
356: ELSE
357: l_report_level := p_report_level||'_';
358: END IF;
359:

Line 361: IF pay_ca_balance_view_pkg.get_session_var('TAX_GROUP') = 'Y' then

357: l_report_level := p_report_level||'_';
358: END IF;
359:
360: IF p_source_id IS NULL THEN
361: IF pay_ca_balance_view_pkg.get_session_var('TAX_GROUP') = 'Y' then
362: l_gre_tg_or_rpt_unit := 'TG_';
363:
364: begin
365: select pac.context_value

Line 375: pay_ca_balance_view_pkg.set_context('TAX_GROUP',l_tax_group_id);

371: and pac.context_id = fc.context_id;
372:
373: if l_tax_group <> 'No Tax Group' then
374: l_tax_group_id := l_tax_group;
375: pay_ca_balance_view_pkg.set_context('TAX_GROUP',l_tax_group_id);
376: pay_balance_pkg.set_context('TAX_GROUP',l_tax_group_id);
377: end if;
378:
379: exception

Line 391: pay_ca_balance_view_pkg.set_context('JURISDICTION_CODE',l_jd_context);

387: ELSE
388: l_gre_tg_or_rpt_unit := 'RPT_UNIT_';
389: END IF;
390:
391: pay_ca_balance_view_pkg.set_context('JURISDICTION_CODE',l_jd_context);
392: pay_ca_balance_view_pkg.set_context('ASSIGNMENT_ACTION_ID'
393: ,p_assignment_action_id);
394: pay_ca_balance_view_pkg.set_context('BUSINESS_GROUP_ID',l_business_group_id);
395: pay_ca_balance_view_pkg.set_context('DATE_EARNED',p_virtual_date);

Line 392: pay_ca_balance_view_pkg.set_context('ASSIGNMENT_ACTION_ID'

388: l_gre_tg_or_rpt_unit := 'RPT_UNIT_';
389: END IF;
390:
391: pay_ca_balance_view_pkg.set_context('JURISDICTION_CODE',l_jd_context);
392: pay_ca_balance_view_pkg.set_context('ASSIGNMENT_ACTION_ID'
393: ,p_assignment_action_id);
394: pay_ca_balance_view_pkg.set_context('BUSINESS_GROUP_ID',l_business_group_id);
395: pay_ca_balance_view_pkg.set_context('DATE_EARNED',p_virtual_date);
396: pay_ca_balance_view_pkg.set_context('SOURCE_ID',p_source_id);

Line 394: pay_ca_balance_view_pkg.set_context('BUSINESS_GROUP_ID',l_business_group_id);

390:
391: pay_ca_balance_view_pkg.set_context('JURISDICTION_CODE',l_jd_context);
392: pay_ca_balance_view_pkg.set_context('ASSIGNMENT_ACTION_ID'
393: ,p_assignment_action_id);
394: pay_ca_balance_view_pkg.set_context('BUSINESS_GROUP_ID',l_business_group_id);
395: pay_ca_balance_view_pkg.set_context('DATE_EARNED',p_virtual_date);
396: pay_ca_balance_view_pkg.set_context('SOURCE_ID',p_source_id);
397:
398: pay_balance_pkg.set_context('JURISDICTION_CODE',l_jd_context);

Line 395: pay_ca_balance_view_pkg.set_context('DATE_EARNED',p_virtual_date);

391: pay_ca_balance_view_pkg.set_context('JURISDICTION_CODE',l_jd_context);
392: pay_ca_balance_view_pkg.set_context('ASSIGNMENT_ACTION_ID'
393: ,p_assignment_action_id);
394: pay_ca_balance_view_pkg.set_context('BUSINESS_GROUP_ID',l_business_group_id);
395: pay_ca_balance_view_pkg.set_context('DATE_EARNED',p_virtual_date);
396: pay_ca_balance_view_pkg.set_context('SOURCE_ID',p_source_id);
397:
398: pay_balance_pkg.set_context('JURISDICTION_CODE',l_jd_context);
399: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID'

Line 396: pay_ca_balance_view_pkg.set_context('SOURCE_ID',p_source_id);

392: pay_ca_balance_view_pkg.set_context('ASSIGNMENT_ACTION_ID'
393: ,p_assignment_action_id);
394: pay_ca_balance_view_pkg.set_context('BUSINESS_GROUP_ID',l_business_group_id);
395: pay_ca_balance_view_pkg.set_context('DATE_EARNED',p_virtual_date);
396: pay_ca_balance_view_pkg.set_context('SOURCE_ID',p_source_id);
397:
398: pay_balance_pkg.set_context('JURISDICTION_CODE',l_jd_context);
399: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID'
400: ,p_assignment_action_id);

Line 468: IF pay_ca_balance_view_pkg.get_session_var('TAX_GROUP') = 'Y' then

464: END;
465:
466: IF l_sep_check <> 'Y' THEN
467:
468: IF pay_ca_balance_view_pkg.get_session_var('TAX_GROUP') = 'Y' then
469: select paa_master.source_action_id
470: into l_assignment_action_id
471: from pay_assignment_actions paa_master
472: ,pay_assignment_actions paa_sm

Line 535: RETURN pay_ca_balance_view_pkg.get_value

531: pay_us_balance_view_pkg.debug_msg('The Defined Balance does not exist');
532: RETURN NULL;
533: ELSE
534:
535: RETURN pay_ca_balance_view_pkg.get_value
536: (p_assignment_action_id
537: ,l_defined_balance_id);
538:
539: END IF;

Line 614: IF nvl(pay_ca_balance_view_pkg.get_session_var(p_dimension),'ON') = 'OFF' THEN

610: RETURN BOOLEAN IS
611: --
612: BEGIN
613: --
614: IF nvl(pay_ca_balance_view_pkg.get_session_var(p_dimension),'ON') = 'OFF' THEN
615: --
616: RETURN TRUE;
617: --
618: ELSE

Line 635: THEN pay_ca_balance_view_pkg.set_session_var(PTD','OFF');

631: --
632: /*
633: IF p_report_name = 'SOE'
634: --
635: THEN pay_ca_balance_view_pkg.set_session_var(PTD','OFF');
636: pay_ca_balance_view_pkg.set_session_var('MONTH','OFF');
637: pay_ca_balance_view_pkg.set_session_var('QTD','OFF');
638: pay_ca_balance_view_pkg.set_session_var('YTD','ON');
639: -- Need to check if need both CURRENT and RUN

Line 636: pay_ca_balance_view_pkg.set_session_var('MONTH','OFF');

632: /*
633: IF p_report_name = 'SOE'
634: --
635: THEN pay_ca_balance_view_pkg.set_session_var(PTD','OFF');
636: pay_ca_balance_view_pkg.set_session_var('MONTH','OFF');
637: pay_ca_balance_view_pkg.set_session_var('QTD','OFF');
638: pay_ca_balance_view_pkg.set_session_var('YTD','ON');
639: -- Need to check if need both CURRENT and RUN
640: pay_ca_balance_view_pkg.set_session_var('CURRENT','ON');

Line 637: pay_ca_balance_view_pkg.set_session_var('QTD','OFF');

633: IF p_report_name = 'SOE'
634: --
635: THEN pay_ca_balance_view_pkg.set_session_var(PTD','OFF');
636: pay_ca_balance_view_pkg.set_session_var('MONTH','OFF');
637: pay_ca_balance_view_pkg.set_session_var('QTD','OFF');
638: pay_ca_balance_view_pkg.set_session_var('YTD','ON');
639: -- Need to check if need both CURRENT and RUN
640: pay_ca_balance_view_pkg.set_session_var('CURRENT','ON');
641: pay_ca_balance_view_pkg.set_session_var('RUN','ON');

Line 638: pay_ca_balance_view_pkg.set_session_var('YTD','ON');

634: --
635: THEN pay_ca_balance_view_pkg.set_session_var(PTD','OFF');
636: pay_ca_balance_view_pkg.set_session_var('MONTH','OFF');
637: pay_ca_balance_view_pkg.set_session_var('QTD','OFF');
638: pay_ca_balance_view_pkg.set_session_var('YTD','ON');
639: -- Need to check if need both CURRENT and RUN
640: pay_ca_balance_view_pkg.set_session_var('CURRENT','ON');
641: pay_ca_balance_view_pkg.set_session_var('RUN','ON');
642: --

Line 640: pay_ca_balance_view_pkg.set_session_var('CURRENT','ON');

636: pay_ca_balance_view_pkg.set_session_var('MONTH','OFF');
637: pay_ca_balance_view_pkg.set_session_var('QTD','OFF');
638: pay_ca_balance_view_pkg.set_session_var('YTD','ON');
639: -- Need to check if need both CURRENT and RUN
640: pay_ca_balance_view_pkg.set_session_var('CURRENT','ON');
641: pay_ca_balance_view_pkg.set_session_var('RUN','ON');
642: --
643: END IF;
644: */

Line 641: pay_ca_balance_view_pkg.set_session_var('RUN','ON');

637: pay_ca_balance_view_pkg.set_session_var('QTD','OFF');
638: pay_ca_balance_view_pkg.set_session_var('YTD','ON');
639: -- Need to check if need both CURRENT and RUN
640: pay_ca_balance_view_pkg.set_session_var('CURRENT','ON');
641: pay_ca_balance_view_pkg.set_session_var('RUN','ON');
642: --
643: END IF;
644: */
645: null;