DBA Data[Home] [Help]

APPS.PAY_CA_BALANCE_PKG dependencies on PAY_US_BALANCE_VIEW_PKG

Line 55: pay_us_balance_view_pkg to

51: dimension in get_current_balance.
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

Line 197: pay_us_balance_view_pkg.debug_msg(' p_def_bal: '||l_defined_balance_id);

193: (p_run_action_id
194: ,p_defined_balance_id);
195:
196: ELSE
197: pay_us_balance_view_pkg.debug_msg(' p_def_bal: '||l_defined_balance_id);
198: OPEN csr_get_prepay_id (p_run_action_id);
199: FETCH csr_get_prepay_id INTO l_prepay_action_id;
200: CLOSE csr_get_prepay_id;
201:

Line 304: pay_us_balance_view_pkg.debug_msg( '=======================================');

300: l_pmed_enable varchar2(1) := 'Y'; -- bug 12534619
301:
302: --
303: BEGIN
304: pay_us_balance_view_pkg.debug_msg( '=======================================');
305: pay_us_balance_view_pkg.debug_msg('call_ca_balance_get_value entry:');
306: pay_us_balance_view_pkg.debug_msg(' p_balance_name: ' || p_balance_name);
307: pay_us_balance_view_pkg.debug_msg(' p_time_period: ' || p_time_period);
308: pay_us_balance_view_pkg.debug_msg(' p_assignment_action_id: ' ||

Line 305: pay_us_balance_view_pkg.debug_msg('call_ca_balance_get_value entry:');

301:
302: --
303: BEGIN
304: pay_us_balance_view_pkg.debug_msg( '=======================================');
305: pay_us_balance_view_pkg.debug_msg('call_ca_balance_get_value entry:');
306: pay_us_balance_view_pkg.debug_msg(' p_balance_name: ' || p_balance_name);
307: pay_us_balance_view_pkg.debug_msg(' p_time_period: ' || p_time_period);
308: pay_us_balance_view_pkg.debug_msg(' p_assignment_action_id: ' ||
309: TO_CHAR(p_assignment_action_id));

Line 306: pay_us_balance_view_pkg.debug_msg(' p_balance_name: ' || p_balance_name);

302: --
303: BEGIN
304: pay_us_balance_view_pkg.debug_msg( '=======================================');
305: pay_us_balance_view_pkg.debug_msg('call_ca_balance_get_value entry:');
306: pay_us_balance_view_pkg.debug_msg(' p_balance_name: ' || p_balance_name);
307: pay_us_balance_view_pkg.debug_msg(' p_time_period: ' || p_time_period);
308: pay_us_balance_view_pkg.debug_msg(' p_assignment_action_id: ' ||
309: TO_CHAR(p_assignment_action_id));
310: pay_us_balance_view_pkg.debug_msg(' p_assignment_id: ' ||

Line 307: pay_us_balance_view_pkg.debug_msg(' p_time_period: ' || p_time_period);

303: BEGIN
304: pay_us_balance_view_pkg.debug_msg( '=======================================');
305: pay_us_balance_view_pkg.debug_msg('call_ca_balance_get_value entry:');
306: pay_us_balance_view_pkg.debug_msg(' p_balance_name: ' || p_balance_name);
307: pay_us_balance_view_pkg.debug_msg(' p_time_period: ' || p_time_period);
308: pay_us_balance_view_pkg.debug_msg(' p_assignment_action_id: ' ||
309: TO_CHAR(p_assignment_action_id));
310: pay_us_balance_view_pkg.debug_msg(' p_assignment_id: ' ||
311: TO_CHAR(p_assignment_id));

Line 308: pay_us_balance_view_pkg.debug_msg(' p_assignment_action_id: ' ||

304: pay_us_balance_view_pkg.debug_msg( '=======================================');
305: pay_us_balance_view_pkg.debug_msg('call_ca_balance_get_value entry:');
306: pay_us_balance_view_pkg.debug_msg(' p_balance_name: ' || p_balance_name);
307: pay_us_balance_view_pkg.debug_msg(' p_time_period: ' || p_time_period);
308: pay_us_balance_view_pkg.debug_msg(' p_assignment_action_id: ' ||
309: TO_CHAR(p_assignment_action_id));
310: pay_us_balance_view_pkg.debug_msg(' p_assignment_id: ' ||
311: TO_CHAR(p_assignment_id));
312: pay_us_balance_view_pkg.debug_msg(' p_virtual_date: ' ||

Line 310: pay_us_balance_view_pkg.debug_msg(' p_assignment_id: ' ||

306: pay_us_balance_view_pkg.debug_msg(' p_balance_name: ' || p_balance_name);
307: pay_us_balance_view_pkg.debug_msg(' p_time_period: ' || p_time_period);
308: pay_us_balance_view_pkg.debug_msg(' p_assignment_action_id: ' ||
309: TO_CHAR(p_assignment_action_id));
310: pay_us_balance_view_pkg.debug_msg(' p_assignment_id: ' ||
311: TO_CHAR(p_assignment_id));
312: pay_us_balance_view_pkg.debug_msg(' p_virtual_date: ' ||
313: TO_CHAR(p_virtual_date));
314: pay_us_balance_view_pkg.debug_msg(' p_report_level: ' || p_report_level);

Line 312: pay_us_balance_view_pkg.debug_msg(' p_virtual_date: ' ||

308: pay_us_balance_view_pkg.debug_msg(' p_assignment_action_id: ' ||
309: TO_CHAR(p_assignment_action_id));
310: pay_us_balance_view_pkg.debug_msg(' p_assignment_id: ' ||
311: TO_CHAR(p_assignment_id));
312: pay_us_balance_view_pkg.debug_msg(' p_virtual_date: ' ||
313: TO_CHAR(p_virtual_date));
314: pay_us_balance_view_pkg.debug_msg(' p_report_level: ' || p_report_level);
315: pay_us_balance_view_pkg.debug_msg(' p_gre_id: ' ||
316: TO_CHAR(p_gre_id));

Line 314: pay_us_balance_view_pkg.debug_msg(' p_report_level: ' || p_report_level);

310: pay_us_balance_view_pkg.debug_msg(' p_assignment_id: ' ||
311: TO_CHAR(p_assignment_id));
312: pay_us_balance_view_pkg.debug_msg(' p_virtual_date: ' ||
313: TO_CHAR(p_virtual_date));
314: pay_us_balance_view_pkg.debug_msg(' p_report_level: ' || p_report_level);
315: pay_us_balance_view_pkg.debug_msg(' p_gre_id: ' ||
316: TO_CHAR(p_gre_id));
317: pay_us_balance_view_pkg.debug_msg(' p_business_group_id: ' ||
318: TO_CHAR(p_business_group_id));

Line 315: pay_us_balance_view_pkg.debug_msg(' p_gre_id: ' ||

311: TO_CHAR(p_assignment_id));
312: pay_us_balance_view_pkg.debug_msg(' p_virtual_date: ' ||
313: TO_CHAR(p_virtual_date));
314: pay_us_balance_view_pkg.debug_msg(' p_report_level: ' || p_report_level);
315: pay_us_balance_view_pkg.debug_msg(' p_gre_id: ' ||
316: TO_CHAR(p_gre_id));
317: pay_us_balance_view_pkg.debug_msg(' p_business_group_id: ' ||
318: TO_CHAR(p_business_group_id));
319: pay_us_balance_view_pkg.debug_msg(' p_jurisdiction_code: ' ||

Line 317: pay_us_balance_view_pkg.debug_msg(' p_business_group_id: ' ||

313: TO_CHAR(p_virtual_date));
314: pay_us_balance_view_pkg.debug_msg(' p_report_level: ' || p_report_level);
315: pay_us_balance_view_pkg.debug_msg(' p_gre_id: ' ||
316: TO_CHAR(p_gre_id));
317: pay_us_balance_view_pkg.debug_msg(' p_business_group_id: ' ||
318: TO_CHAR(p_business_group_id));
319: pay_us_balance_view_pkg.debug_msg(' p_jurisdiction_code: ' ||
320: p_jurisdiction_code);
321: pay_us_balance_view_pkg.debug_msg(' p_source_id: ' ||

Line 319: pay_us_balance_view_pkg.debug_msg(' p_jurisdiction_code: ' ||

315: pay_us_balance_view_pkg.debug_msg(' p_gre_id: ' ||
316: TO_CHAR(p_gre_id));
317: pay_us_balance_view_pkg.debug_msg(' p_business_group_id: ' ||
318: TO_CHAR(p_business_group_id));
319: pay_us_balance_view_pkg.debug_msg(' p_jurisdiction_code: ' ||
320: p_jurisdiction_code);
321: pay_us_balance_view_pkg.debug_msg(' p_source_id: ' ||
322: TO_CHAR(p_source_id));
323:

Line 321: pay_us_balance_view_pkg.debug_msg(' p_source_id: ' ||

317: pay_us_balance_view_pkg.debug_msg(' p_business_group_id: ' ||
318: TO_CHAR(p_business_group_id));
319: pay_us_balance_view_pkg.debug_msg(' p_jurisdiction_code: ' ||
320: p_jurisdiction_code);
321: pay_us_balance_view_pkg.debug_msg(' p_source_id: ' ||
322: TO_CHAR(p_source_id));
323:
324: --
325: --Set contexts

Line 417: pay_us_balance_view_pkg.debug_msg(' l_time_period: ' || l_time_period);

413: pay_balance_pkg.set_context('DATE_EARNED',p_virtual_date);
414: pay_balance_pkg.set_context('SOURCE_ID',p_source_id);
415:
416: l_time_period := p_time_period;
417: pay_us_balance_view_pkg.debug_msg(' l_time_period: ' || l_time_period);
418:
419: IF p_time_period = 'CURRENT' THEN
420: /* bug 12534619 */
421: if p_balance_name = 'PMED Reduced Subject' then --rgottipa

Line 452: pay_us_balance_view_pkg.debug_msg(' p_balance_name: ' || p_balance_name);

448: ELSE -- turn_off_dimension is FALSE so get the balance.
449: --
450: -- Get the defined balance
451: --
452: pay_us_balance_view_pkg.debug_msg(' p_balance_name: ' || p_balance_name);
453: pay_us_balance_view_pkg.debug_msg
454: (' p_dimension_suffix: ' || l_dimension_suffix);
455: l_defined_balance_id := pay_ca_group_level_bal_pkg.get_defined_balance
456: (p_balance_name => p_balance_name

Line 453: pay_us_balance_view_pkg.debug_msg

449: --
450: -- Get the defined balance
451: --
452: pay_us_balance_view_pkg.debug_msg(' p_balance_name: ' || p_balance_name);
453: pay_us_balance_view_pkg.debug_msg
454: (' p_dimension_suffix: ' || l_dimension_suffix);
455: l_defined_balance_id := pay_ca_group_level_bal_pkg.get_defined_balance
456: (p_balance_name => p_balance_name
457: ,p_dimension => l_dimension_suffix

Line 553: pay_us_balance_view_pkg.debug_msg('The Defined Balance does not exist');

549:
550: END IF;
551:
552: IF l_defined_balance_id IS NULL THEN
553: pay_us_balance_view_pkg.debug_msg('The Defined Balance does not exist');
554: RETURN NULL;
555: ELSE
556:
557: RETURN pay_ca_balance_view_pkg.get_value