APPS.PN_EXP_TO_AR dependencies on PN_EXP_TO_AR

Line 1: package body PN_EXP_TO_AR as

1: package body PN_EXP_TO_AR as
2: -- $Header: PNTXBILB.pls 120.11.12020000.3 2012/12/28 13:09:44 pcheruvu ship $
3:
4: /* All Cursor declarations go here */
5: CURSOR get_dist(p_term_id NUMBER) IS

Line 148: -- PN_EXP_TO_AR.EXP_TO_AR_GRP. This condition is needed

144: -- 11 params. Form will call this with with only
145: -- group_id after all items are updated with same
146: -- export_group_id in the form.
147: -- 29-APR-04 Anand o Added another condition before calling proc
148: -- PN_EXP_TO_AR.EXP_TO_AR_GRP. This condition is needed
149: -- when grouping rule name has no optional attr attched.
150: -- In this case, we need to group by ONLY mandatory attr
151: -- Bug#3586774
152: -- 28-OCT-05 sdmahesh o ATG mandated changes for SQL literals

Line 192: pnp_debug_pkg.log('-------- PN_EXP_TO_AR.EXP_TO_AR --------- (+)');

188: pn_mo_cache_utils.get_current_org_id));
189:
190:
191: BEGIN
192: pnp_debug_pkg.log('-------- PN_EXP_TO_AR.EXP_TO_AR --------- (+)');
193:
194: OPEN get_func_curr_code(l_set_of_books_id);
195: FETCH get_func_curr_code INTO l_func_curr_code;
196: CLOSE get_func_curr_code;

Line 448: PN_EXP_TO_AR.EXP_TO_AR_NO_GRP(errbuf

444:
445: IF g_no_group_flag THEN
446:
447: Q_Billitem_nogrp := Q_Billitem_nogrp ||l_param_where_clause;
448: PN_EXP_TO_AR.EXP_TO_AR_NO_GRP(errbuf
449: ,retcode
450: ,l_groupId
451: ,p_lease_num_low
452: ,p_lease_num_high

Line 489: PN_EXP_TO_AR.EXP_TO_AR_GRP(errbuf

485: pnp_debug_pkg.put_log_msg(fnd_message.get);
486: l_ord_clause := l_ord_clause || ' , le.lease_num';
487: END IF;
488: Q_Billitem_grp := Q_Billitem_grp ||l_param_where_clause || l_ord_clause;
489: PN_EXP_TO_AR.EXP_TO_AR_GRP(errbuf
490: ,retcode
491: ,l_groupId
492: ,p_lease_num_low
493: ,p_lease_num_high

Line 507: pnp_debug_pkg.log('-------- PN_EXP_TO_AR.EXP_TO_AR --------- (-)');

503: ,p_grp_param
504: );
505: END IF;
506:
507: pnp_debug_pkg.log('-------- PN_EXP_TO_AR.EXP_TO_AR --------- (-)');
508:
509: EXCEPTION
510:
511: WHEN INVALID_GROUP_RULE THEN

Line 2950: PNP_DEBUG_PKG.log('pn_exp_to_ar.do_binding (+)');

2946: ,p_customer_id NUMBER
2947: ,p_grp_param VARCHAR2
2948: ) IS
2949: BEGIN
2950: PNP_DEBUG_PKG.log('pn_exp_to_ar.do_binding (+)');
2951: IF p_grp_param IS NULL THEN
2952: IF p_lease_num_low IS NOT NULL AND
2953: p_lease_num_high IS NOT NULL THEN
2954: dbms_sql.bind_variable(p_cursor,'l_lease_num_low',p_lease_num_low);

Line 3008: PNP_DEBUG_PKG.log('pn_exp_to_ar.do_binding (-)');

3004: END IF;
3005: ELSE
3006: dbms_sql.bind_variable(p_cursor,'l_grp_param',p_grp_param);
3007: END IF;
3008: PNP_DEBUG_PKG.log('pn_exp_to_ar.do_binding (-)');
3009: END do_binding;
3010:
3011:
3012:

Line 3016: END PN_EXP_TO_AR;

3012:
3013: ------------------------------
3014: -- End of Package
3015: ------------------------------
3016: END PN_EXP_TO_AR;