DBA Data[Home] [Help]

APPS.PN_R12_UTIL_PKG dependencies on PN_R12_UTIL_PKG

Line 1: PACKAGE BODY pn_r12_util_pkg AS

1: PACKAGE BODY pn_r12_util_pkg AS
2: /* $Header: PNUTL12B.pls 120.11 2008/02/11 13:39:42 rthumma ship $ */
3:
4: --------------------------------------------------------------------------
5: -- FUNCTION : get_tcc

Line 31: l_desc := 'pn_r12_util_pkg.get_tcc';

27: l_desc VARCHAR2(100);
28:
29: BEGIN
30:
31: l_desc := 'pn_r12_util_pkg.get_tcc';
32:
33: pnp_debug_pkg.log(l_desc ||' (+)');
34:
35: IF p_lease_class_code IN ('DIRECT','PAY','PAYMENT') THEN

Line 91: l_desc := 'pn_r12_util_pkg.get_tcc_name';

87: l_desc VARCHAR2(100);
88:
89: BEGIN
90:
91: l_desc := 'pn_r12_util_pkg.get_tcc_name';
92:
93: pnp_debug_pkg.log(l_desc ||' (+)');
94:
95: IF p_lease_class_code IN ('DIRECT','PAY') THEN

Line 139: l_desc := 'pn_r12_util_pkg.validate_term_template_tax';

135: WHERE term_template_id = p_term_temp_id;
136:
137: BEGIN
138:
139: l_desc := 'pn_r12_util_pkg.validate_term_template_tax';
140:
141: pnp_debug_pkg.log(l_desc ||' (+)');
142:
143: FOR tp_rec IN term_temp_cur(p_term_temp_id) LOOP

Line 151: l_tcc := pn_r12_util_pkg.get_tcc(

147: AND
148: tp_rec.tax_classification_code IS NULL
149: THEN
150:
151: l_tcc := pn_r12_util_pkg.get_tcc(
152: p_tax_code_id => nvl(tp_rec.tax_code_id, tp_rec.tax_group_id),
153: p_lease_class_code => p_lease_cls_code,
154: p_as_of_date => SYSDATE);
155:

Line 205: l_desc := 'pn_r12_util_pkg.is_le_compatible - internal';

201: l_le_id_old NUMBER(15) NULL;
202:
203: BEGIN
204:
205: l_desc := 'pn_r12_util_pkg.is_le_compatible - internal';
206:
207: pnp_debug_pkg.log(l_desc ||' (+)');
208:
209: /*

Line 324: l_desc := 'pn_r12_util_pkg.is_le_compatible';

320:
321:
322: BEGIN
323:
324: l_desc := 'pn_r12_util_pkg.is_le_compatible';
325:
326: pnp_debug_pkg.log(l_desc ||' (+)');
327:
328: IF p_mode = 'INSERT' THEN

Line 415: l_desc := 'pn_r12_util_pkg.get_let_for_ap';

411:
412: BEGIN
413:
414:
415: l_desc := 'pn_r12_util_pkg.get_let_for_ap';
416:
417: pnp_debug_pkg.log(l_desc ||' (+)');
418:
419: xle_businessinfo_grp.get_purchasetopay_info(

Line 458: l_desc := 'pn_r12_util_pkg.get_let_for_ar';

454: l_desc VARCHAR2(100);
455:
456: BEGIN
457:
458: l_desc := 'pn_r12_util_pkg.get_let_for_ar';
459:
460: pnp_debug_pkg.log(l_desc ||' (+)');
461:
462: mo_global.set_org_access(p_org_id, null, 'AR');

Line 517: pnp_debug_pkg.log('pn_r12_util_pkg.get_tax_flag (+)');

513: l_answer VARCHAR2(1);
514:
515: BEGIN
516:
517: pnp_debug_pkg.log('pn_r12_util_pkg.get_tax_flag (+)');
518:
519: -- Added IF condition for Bug 6413109
520: IF p_vendor_site_id IS NOT NULL THEN
521: FOR info_rec IN get_site_flag_value LOOP

Line 535: pnp_debug_pkg.log('pn_r12_util_pkg.get_tax_flag (-)');

531:
532: END LOOP;
533: END IF;
534:
535: pnp_debug_pkg.log('pn_r12_util_pkg.get_tax_flag (-)');
536:
537: RETURN l_answer;
538:
539: END get_tax_flag;

Line 602: l_tcc := pn_r12_util_pkg.get_tcc(

598:
599: BEGIN
600: IF (p_tax_code_id IS NOT NULL OR p_tax_group_id IS NOT NULL)
601: THEN
602: l_tcc := pn_r12_util_pkg.get_tcc(
603: p_tax_code_id => nvl(p_tax_code_id, p_tax_group_id),
604: p_lease_class_code => p_run_mode,
605: p_as_of_date => SYSDATE);
606:

Line 647: l_tcc := pn_r12_util_pkg.get_tcc(

643: IF rec.tax_classification_code IS NULL AND
644: ( rec.tax_code_id IS NOT NULL OR rec.tax_group_id IS NOT NULL)
645: THEN
646:
647: l_tcc := pn_r12_util_pkg.get_tcc(
648: p_tax_code_id => nvl(rec.tax_code_id, rec.tax_group_id),
649: p_lease_class_code => rec.term_template_type,
650: p_as_of_date => SYSDATE);
651:

Line 671: END pn_r12_util_pkg;

667: END LOOP;
668: END check_tax_upgrade;
669:
670:
671: END pn_r12_util_pkg;
672: