APPS.OE_BULK_VALIDATE dependencies on OE_BULK_ORDER_IMPORT_PVT

Line 2603: OE_BULK_ORDER_IMPORT_PVT.G_ERROR_ORDERS :=

2599: WHEN NO_DATA_FOUND THEN
2600: NULL;
2601: END;
2602:
2603: OE_BULK_ORDER_IMPORT_PVT.G_ERROR_ORDERS :=
2604: OE_BULK_ORDER_IMPORT_PVT.G_ERROR_ORDERS + SQL%ROWCOUNT;
2605: END IF;
2606: --End of ER 9060917
2607:

Line 2604: OE_BULK_ORDER_IMPORT_PVT.G_ERROR_ORDERS + SQL%ROWCOUNT;

2600: NULL;
2601: END;
2602:
2603: OE_BULK_ORDER_IMPORT_PVT.G_ERROR_ORDERS :=
2604: OE_BULK_ORDER_IMPORT_PVT.G_ERROR_ORDERS + SQL%ROWCOUNT;
2605: END IF;
2606: --End of ER 9060917
2607:
2608: IF g_error_count >= 1 THEN

Line 2655: OE_BULK_ORDER_IMPORT_PVT.G_ERROR_ORDERS :=

2651: AND b.order_source_id = a.order_source_id
2652: and b.original_sys_document_line_ref is NULL
2653: AND b.request_id = oe_bulk_order_pvt.g_request_id);
2654:
2655: OE_BULK_ORDER_IMPORT_PVT.G_ERROR_ORDERS :=
2656: OE_BULK_ORDER_IMPORT_PVT.G_ERROR_ORDERS + SQL%ROWCOUNT;
2657:
2658: UPDATE oe_headers_iface_all a
2659: SET error_flag = 'Y'

Line 2656: OE_BULK_ORDER_IMPORT_PVT.G_ERROR_ORDERS + SQL%ROWCOUNT;

2652: and b.original_sys_document_line_ref is NULL
2653: AND b.request_id = oe_bulk_order_pvt.g_request_id);
2654:
2655: OE_BULK_ORDER_IMPORT_PVT.G_ERROR_ORDERS :=
2656: OE_BULK_ORDER_IMPORT_PVT.G_ERROR_ORDERS + SQL%ROWCOUNT;
2657:
2658: UPDATE oe_headers_iface_all a
2659: SET error_flag = 'Y'
2660: ,attribute_status = NULL

Line 2672: OE_BULK_ORDER_IMPORT_PVT.G_ERROR_ORDERS :=

2668: AND nvl(error_flag, 'N') = 'N'
2669: AND b.request_id = oe_bulk_order_pvt.g_request_id);
2670:
2671:
2672: OE_BULK_ORDER_IMPORT_PVT.G_ERROR_ORDERS :=
2673: OE_BULK_ORDER_IMPORT_PVT.G_ERROR_ORDERS + SQL%ROWCOUNT;
2674:
2675:
2676: ELSE

Line 2673: OE_BULK_ORDER_IMPORT_PVT.G_ERROR_ORDERS + SQL%ROWCOUNT;

2669: AND b.request_id = oe_bulk_order_pvt.g_request_id);
2670:
2671:
2672: OE_BULK_ORDER_IMPORT_PVT.G_ERROR_ORDERS :=
2673: OE_BULK_ORDER_IMPORT_PVT.G_ERROR_ORDERS + SQL%ROWCOUNT;
2674:
2675:
2676: ELSE
2677:

Line 2691: OE_BULK_ORDER_IMPORT_PVT.G_ERROR_ORDERS :=

2687: AND b.order_source_id = a.order_source_id
2688: AND b.request_id = OE_BULK_ORDER_PVT.G_REQUEST_ID); -- Added for Bug 6671781
2689:
2690:
2691: OE_BULK_ORDER_IMPORT_PVT.G_ERROR_ORDERS :=
2692: OE_BULK_ORDER_IMPORT_PVT.G_ERROR_ORDERS + SQL%ROWCOUNT;
2693:
2694:
2695: BEGIN

Line 2692: OE_BULK_ORDER_IMPORT_PVT.G_ERROR_ORDERS + SQL%ROWCOUNT;

2688: AND b.request_id = OE_BULK_ORDER_PVT.G_REQUEST_ID); -- Added for Bug 6671781
2689:
2690:
2691: OE_BULK_ORDER_IMPORT_PVT.G_ERROR_ORDERS :=
2692: OE_BULK_ORDER_IMPORT_PVT.G_ERROR_ORDERS + SQL%ROWCOUNT;
2693:
2694:
2695: BEGIN
2696:

Line 2718: --OE_BULK_ORDER_IMPORT_PVT.G_ERROR_ORDERS :=

2714: ----------------------------------------
2715: --ADDED BY UMA ON 7/18/02
2716: ----------------------------------------
2717:
2718: --OE_BULK_ORDER_IMPORT_PVT.G_ERROR_ORDERS :=
2719: -- OE_BULK_ORDER_IMPORT_PVT.G_ERROR_ORDERS + SQL%ROWCOUNT;
2720:
2721: END IF;
2722:

Line 2719: -- OE_BULK_ORDER_IMPORT_PVT.G_ERROR_ORDERS + SQL%ROWCOUNT;

2715: --ADDED BY UMA ON 7/18/02
2716: ----------------------------------------
2717:
2718: --OE_BULK_ORDER_IMPORT_PVT.G_ERROR_ORDERS :=
2719: -- OE_BULK_ORDER_IMPORT_PVT.G_ERROR_ORDERS + SQL%ROWCOUNT;
2720:
2721: END IF;
2722:
2723: EXCEPTION