APPS.OE_CNCL_ORDER_IMPORT_PVT dependencies on DUAL

Line 1264: from dual;

1260: END IF;
1261: begin
1262: select DECODE(p_validate_only,'Y','T','N','F',p_validate_only)
1263: into l_validate_only
1264: from dual;
1265: exception
1266: when others then
1267: l_validate_only := 'T';
1268: end;

Line 3032: FROM DUAL;

3028: END IF;
3029: --
3030: SELECT OE_ORDER_HEADERS_S.NEXTVAL
3031: INTO l_header_rec.header_id
3032: FROM DUAL;
3033: --
3034: OE_CNCL_Util.Convert_Miss_To_Null(l_header_rec);
3035: --
3036: l_header_rec.creation_date := SYSDATE;

Line 3116: FROM DUAL;

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;
3119: --
3120: OE_CNCL_Util.Convert_Miss_To_Null(l_header_scredit_tbl(I));

Line 3182: FROM DUAL;

3178: BEGIN
3179: --
3180: SELECT OE_PRICE_ADJUSTMENTS_S.NEXTVAL
3181: INTO l_header_adj_tbl(I).price_adjustment_id
3182: FROM DUAL;
3183: --
3184: l_header_adj_tbl(I).header_id := l_header_rec.header_id;
3185: --
3186: OE_CNCL_Util.Convert_Miss_To_Null(l_header_adj_tbl(I));

Line 3248: FROM DUAL;

3244: --
3245: --
3246: SELECT OE_ORDER_LINES_S.NEXTVAL
3247: INTO l_line_tbl(I).line_id
3248: FROM DUAL;
3249: --
3250: -- { Start Before insert check is the item_type_code is
3251: -- present. Call get_item_type_code function
3252: -- bug 1949855

Line 3421: FROM DUAL;

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;
3424: --
3425: l_line_scredit_tbl(J).line_id := l_line_tbl(I).line_id;

Line 3450: FROM DUAL;

3446: IF l_adj_line_ref_tbl(K) = l_line_tbl(I).orig_sys_line_ref THEN
3447: --
3448: SELECT OE_PRICE_ADJUSTMENTS_S.NEXTVAL
3449: INTO l_line_adj_tbl(K).price_adjustment_id
3450: FROM DUAL;
3451: --
3452: l_line_adj_tbl(K).header_id := l_header_rec.header_id;
3453: l_line_adj_tbl(K).line_id := l_line_tbl(I).line_id;
3454: --

Line 3562: FROM DUAL;

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;
3565: --
3566: l_line_scredit_tbl(J).line_id := l_line_tbl(L).line_id;

Line 3632: FROM DUAL;

3628: IF l_adj_line_ref_tbl(K) = l_line_tbl(L).orig_sys_line_ref THEN
3629: --
3630: SELECT OE_PRICE_ADJUSTMENTS_S.NEXTVAL
3631: INTO l_line_adj_tbl(K).price_adjustment_id
3632: FROM DUAL;
3633: --
3634: l_line_adj_tbl(K).header_id := l_header_rec.header_id;
3635: l_line_adj_tbl(K).line_id := l_line_tbl(L).line_id;
3636: --