DBA Data[Home] [Help]

APPS.PN_EXP_TO_AR dependencies on PN_R12_UTIL_PKG

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

746: dbms_sql.column_value (g_cursor_select_grp, 1,term_ar_tbl(l_index));
747: dbms_sql.column_value (g_cursor_select_grp, 2,v_pn_customer_id1);
748: dbms_sql.column_value (g_cursor_select_grp,3,v_pn_trx_type_id1);
749: dbms_sql.column_value (g_cursor_select_grp,4,v_pn_org_id1);
750: le_ar_tbl(l_index) := pn_r12_util_pkg.get_le_for_ar(v_pn_customer_id1,
751: v_pn_trx_type_id1,
752: v_pn_org_id1);
753:
754: l_index := l_index+1;

Line 1294: IF NOT pn_r12_util_pkg.is_r12 THEN

1290:
1291:
1292: /* get the vat tax code */
1293:
1294: IF NOT pn_r12_util_pkg.is_r12 THEN
1295: OPEN get_tax_code(exp_ar_tbl(l_grp).pn_tax_code_id);
1296: FETCH get_tax_code into l_tax_code;
1297: CLOSE get_tax_code;
1298: ELSE

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

2049: dbms_sql.column_value (g_cursor_select_nogrp,1,term_ar_tbl(l_index));
2050: dbms_sql.column_value (g_cursor_select_nogrp,2,v_pn_customer_id1);
2051: dbms_sql.column_value (g_cursor_select_nogrp,3,v_pn_trx_type_id1);
2052: dbms_sql.column_value (g_cursor_select_nogrp,4,v_pn_org_id1);
2053: le_ar_tbl(l_index) := pn_r12_util_pkg.get_le_for_ar(v_pn_customer_id1,
2054: v_pn_trx_type_id1,
2055: v_pn_org_id1);
2056: l_index := l_index+1;
2057: END;

Line 2441: IF NOT pn_r12_util_pkg.is_r12 THEN

2437: pnp_debug_pkg.put_log_msg(fnd_message.get);
2438:
2439: /* get the vat tax code */
2440:
2441: IF NOT pn_r12_util_pkg.is_r12 THEN
2442: OPEN get_tax_code(v_pn_tax_code_id);
2443: FETCH get_tax_code into l_tax_code;
2444: CLOSE get_tax_code;
2445: ELSE