APPS.OE_CNCL_ORDER_IMPORT_PVT dependencies on DUAL

Line 1260: from dual;

1256: END IF;
1257: begin
1258: select DECODE(p_validate_only,'Y','T','N','F',p_validate_only)
1259: into l_validate_only
1260: from dual;
1261: exception
1262: when others then
1263: l_validate_only := 'T';
1264: end;

Line 3028: FROM DUAL;

3024: END IF;
3025: --
3026: SELECT OE_ORDER_HEADERS_S.NEXTVAL
3027: INTO l_header_rec.header_id
3028: FROM DUAL;
3029: --
3030: OE_CNCL_Util.Convert_Miss_To_Null(l_header_rec);
3031: --
3032: l_header_rec.creation_date := SYSDATE;

Line 3112: FROM DUAL;

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

Line 3178: FROM DUAL;

3174: BEGIN
3175: --
3176: SELECT OE_PRICE_ADJUSTMENTS_S.NEXTVAL
3177: INTO l_header_adj_tbl(I).price_adjustment_id
3178: FROM DUAL;
3179: --
3180: l_header_adj_tbl(I).header_id := l_header_rec.header_id;
3181: --
3182: OE_CNCL_Util.Convert_Miss_To_Null(l_header_adj_tbl(I));

Line 3244: FROM DUAL;

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

Line 3367: FROM DUAL;

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

Line 3396: FROM DUAL;

3392: IF l_adj_line_ref_tbl(K) = l_line_tbl(I).orig_sys_line_ref THEN
3393: --
3394: SELECT OE_PRICE_ADJUSTMENTS_S.NEXTVAL
3395: INTO l_line_adj_tbl(K).price_adjustment_id
3396: FROM DUAL;
3397: --
3398: l_line_adj_tbl(K).header_id := l_header_rec.header_id;
3399: l_line_adj_tbl(K).line_id := l_line_tbl(I).line_id;
3400: --

Line 3493: FROM DUAL;

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

Line 3563: FROM DUAL;

3559: IF l_adj_line_ref_tbl(K) = l_line_tbl(L).orig_sys_line_ref THEN
3560: --
3561: SELECT OE_PRICE_ADJUSTMENTS_S.NEXTVAL
3562: INTO l_line_adj_tbl(K).price_adjustment_id
3563: FROM DUAL;
3564: --
3565: l_line_adj_tbl(K).header_id := l_header_rec.header_id;
3566: l_line_adj_tbl(K).line_id := l_line_tbl(L).line_id;
3567: --