APPS.OE_CNCL_ORDER_IMPORT_PVT dependencies on OE_SALES_CREDITS_S

Line 3114: SELECT OE_SALES_CREDITS_S.NEXTVAL

3110: LOOP
3111: --
3112: BEGIN
3113: --
3114: SELECT OE_SALES_CREDITS_S.NEXTVAL
3115: INTO l_header_scredit_tbl(I).sales_credit_id
3116: FROM DUAL;
3117: --
3118: l_header_scredit_tbl(I).header_id := l_header_rec.header_id;

Line 3419: SELECT OE_SALES_CREDITS_S.NEXTVAL

3415: LOOP
3416: --
3417: IF l_scredit_line_ref_tbl(J) = l_line_tbl(I).orig_sys_line_ref THEN
3418: --
3419: SELECT OE_SALES_CREDITS_S.NEXTVAL
3420: INTO l_line_scredit_tbl(J).sales_credit_id
3421: FROM DUAL;
3422: --
3423: l_line_scredit_tbl(J).header_id := l_header_rec.header_id;

Line 3560: SELECT OE_SALES_CREDITS_S.NEXTVAL

3556: --
3557: IF l_debug_level > 0 THEN
3558: oe_debug_pub.add( 'INSIDE IF STATEMENT**********************' , 2 ) ;
3559: END IF;
3560: SELECT OE_SALES_CREDITS_S.NEXTVAL
3561: INTO l_line_scredit_tbl(J).sales_credit_id
3562: FROM DUAL;
3563: --
3564: l_line_scredit_tbl(J).header_id := l_header_rec.header_id;