DBA Data[Home] [Help]

APPS.PN_EXP_TO_AR dependencies on PN_R12_UTIL_PKG

Line 741: le_ar_tbl(l_index) := pn_r12_util_pkg.get_le_for_ar(v_pn_customer_id1,

737: dbms_sql.column_value (g_cursor_select_grp, 1,term_ar_tbl(l_index));
738: dbms_sql.column_value (g_cursor_select_grp, 2,v_pn_customer_id1);
739: dbms_sql.column_value (g_cursor_select_grp,3,v_pn_trx_type_id1);
740: dbms_sql.column_value (g_cursor_select_grp,4,v_pn_org_id1);
741: le_ar_tbl(l_index) := pn_r12_util_pkg.get_le_for_ar(v_pn_customer_id1,
742: v_pn_trx_type_id1,
743: v_pn_org_id1);
744:
745: l_index := l_index+1;

Line 1279: IF NOT pn_r12_util_pkg.is_r12 THEN

1275:
1276:
1277: /* get the vat tax code */
1278:
1279: IF NOT pn_r12_util_pkg.is_r12 THEN
1280: OPEN get_tax_code(exp_ar_tbl(l_grp).pn_tax_code_id);
1281: FETCH get_tax_code into l_tax_code;
1282: CLOSE get_tax_code;
1283: ELSE

Line 2002: le_ar_tbl(l_index) := pn_r12_util_pkg.get_le_for_ar(v_pn_customer_id1,

1998: dbms_sql.column_value (g_cursor_select_nogrp,1,term_ar_tbl(l_index));
1999: dbms_sql.column_value (g_cursor_select_nogrp,2,v_pn_customer_id1);
2000: dbms_sql.column_value (g_cursor_select_nogrp,3,v_pn_trx_type_id1);
2001: dbms_sql.column_value (g_cursor_select_nogrp,4,v_pn_org_id1);
2002: le_ar_tbl(l_index) := pn_r12_util_pkg.get_le_for_ar(v_pn_customer_id1,
2003: v_pn_trx_type_id1,
2004: v_pn_org_id1);
2005: l_index := l_index+1;
2006: END;

Line 2390: IF NOT pn_r12_util_pkg.is_r12 THEN

2386: pnp_debug_pkg.put_log_msg(fnd_message.get);
2387:
2388: /* get the vat tax code */
2389:
2390: IF NOT pn_r12_util_pkg.is_r12 THEN
2391: OPEN get_tax_code(v_pn_tax_code_id);
2392: FETCH get_tax_code into l_tax_code;
2393: CLOSE get_tax_code;
2394: ELSE