96:
97:
98: TCLEWIS 11-NOV-02 115.18 modified get value function to
99: check for null value of l_jd_context.
100: tclewis 12-NOV-02 115.19 added calls to the pay_balance_pkg.
101: set_context.
102: tclewis 14-nov-2002 115.21 modified payments balance required
103: to return true if pre-payments has
104: been run. It will no longer count
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
321: l_jd_context := nvl(pay_ca_balance_view_pkg.get_session_var
322: ('JURISDICTION_CODE'), 'Not_Set');
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
380: when others then
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);
401: pay_balance_pkg.set_context('BUSINESS_GROUP_ID',l_business_group_id);
402: pay_balance_pkg.set_context('DATE_EARNED',p_virtual_date);
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);
401: pay_balance_pkg.set_context('BUSINESS_GROUP_ID',l_business_group_id);
402: pay_balance_pkg.set_context('DATE_EARNED',p_virtual_date);
403: pay_balance_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);
401: pay_balance_pkg.set_context('BUSINESS_GROUP_ID',l_business_group_id);
402: pay_balance_pkg.set_context('DATE_EARNED',p_virtual_date);
403: pay_balance_pkg.set_context('SOURCE_ID',p_source_id);
404:
405: l_time_period := p_time_period;
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);
401: pay_balance_pkg.set_context('BUSINESS_GROUP_ID',l_business_group_id);
402: pay_balance_pkg.set_context('DATE_EARNED',p_virtual_date);
403: pay_balance_pkg.set_context('SOURCE_ID',p_source_id);
404:
405: l_time_period := p_time_period;
406: pay_us_balance_view_pkg.debug_msg(' l_time_period: ' || l_time_period);
399: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID'
400: ,p_assignment_action_id);
401: pay_balance_pkg.set_context('BUSINESS_GROUP_ID',l_business_group_id);
402: pay_balance_pkg.set_context('DATE_EARNED',p_virtual_date);
403: pay_balance_pkg.set_context('SOURCE_ID',p_source_id);
404:
405: l_time_period := p_time_period;
406: pay_us_balance_view_pkg.debug_msg(' l_time_period: ' || l_time_period);
407:
494: END IF;
495:
496: END IF;
497:
498: RETURN pay_balance_pkg.get_value
499: (l_defined_balance_id
500: ,l_assignment_action_id);
501:
502: END IF;
507: (p_balance_name => p_balance_name
508: ,p_dimension => 'ASG_PAYMENTS'
509: ,p_business_group_id => p_business_group_id);
510:
511: RETURN pay_balance_pkg.get_value
512: (l_defined_balance_id
513: ,p_assignment_action_id);
514:
515: END IF;
520: (p_balance_name => p_balance_name
521: ,p_dimension => 'ASG_PAYMENTS_JD'
522: ,p_business_group_id => p_business_group_id);
523:
524: RETURN pay_balance_pkg.get_value
525: (l_defined_balance_id
526: ,p_assignment_action_id);
527:
528: END IF;