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.9.12010000.2 2008/09/04 12:26:56 mumohan 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 446: PN_EXP_TO_AR.EXP_TO_AR_NO_GRP(errbuf

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

Line 487: PN_EXP_TO_AR.EXP_TO_AR_GRP(errbuf

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

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

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

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

2862: ,p_customer_id NUMBER
2863: ,p_grp_param VARCHAR2
2864: ) IS
2865: BEGIN
2866: PNP_DEBUG_PKG.log('pn_exp_to_ar.do_binding (+)');
2867: IF p_grp_param IS NULL THEN
2868: IF p_lease_num_low IS NOT NULL AND
2869: p_lease_num_high IS NOT NULL THEN
2870: dbms_sql.bind_variable(p_cursor,'l_lease_num_low',p_lease_num_low);

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

2920: END IF;
2921: ELSE
2922: dbms_sql.bind_variable(p_cursor,'l_grp_param',p_grp_param);
2923: END IF;
2924: PNP_DEBUG_PKG.log('pn_exp_to_ar.do_binding (-)');
2925: END do_binding;
2926:
2927:
2928:

Line 2932: END PN_EXP_TO_AR;

2928:
2929: ------------------------------
2930: -- End of Package
2931: ------------------------------
2932: END PN_EXP_TO_AR;