APPS.OE_CNCL_ORDER_IMPORT_PVT dependencies on OE_SALES_CREDITS_S

Line 3110: SELECT OE_SALES_CREDITS_S.NEXTVAL

3106: LOOP
3107: --
3108: BEGIN
3109: --
3110: SELECT OE_SALES_CREDITS_S.NEXTVAL
3111: INTO l_header_scredit_tbl(I).sales_credit_id
3112: FROM DUAL;
3113: --
3114: l_header_scredit_tbl(I).header_id := l_header_rec.header_id;

Line 3365: SELECT OE_SALES_CREDITS_S.NEXTVAL

3361: LOOP
3362: --
3363: IF l_scredit_line_ref_tbl(J) = l_line_tbl(I).orig_sys_line_ref THEN
3364: --
3365: SELECT OE_SALES_CREDITS_S.NEXTVAL
3366: INTO l_line_scredit_tbl(J).sales_credit_id
3367: FROM DUAL;
3368: --
3369: l_line_scredit_tbl(J).header_id := l_header_rec.header_id;

Line 3491: SELECT OE_SALES_CREDITS_S.NEXTVAL

3487: --
3488: IF l_debug_level > 0 THEN
3489: oe_debug_pub.add( 'INSIDE IF STATEMENT**********************' , 2 ) ;
3490: END IF;
3491: SELECT OE_SALES_CREDITS_S.NEXTVAL
3492: INTO l_line_scredit_tbl(J).sales_credit_id
3493: FROM DUAL;
3494: --
3495: l_line_scredit_tbl(J).header_id := l_header_rec.header_id;