DBA Data[Home] [Help]

APPS.OE_INTERNAL_REQUISITION_PVT dependencies on OE_ORDER_LINES_ALL

Line 5: ( LINE_ID OE_Order_Lines_All.LINE_ID%TYPE

1: PACKAGE OE_INTERNAL_REQUISITION_PVT AUTHID CURRENT_USER AS
2: /* $Header: OEXVIRQS.pls 120.0.12010000.1 2008/11/19 11:27:03 rmoharan noship $ */
3:
4: TYPE Line_id_Rec_Type IS RECORD
5: ( LINE_ID OE_Order_Lines_All.LINE_ID%TYPE
6: , LINE_NUMBER OE_Order_Lines_All.LINE_NUMBER%TYPE
7: , SHIPMENT_NUMBER OE_Order_Lines_All.SHIPMENT_NUMBER%TYPE
8: , HEADER_ID OE_Order_Lines_All.HEADER_ID%TYPE
9: , ORDERED_QUANTITY OE_Order_Lines_All.ORDERED_QUANTITY%TYPE

Line 6: , LINE_NUMBER OE_Order_Lines_All.LINE_NUMBER%TYPE

2: /* $Header: OEXVIRQS.pls 120.0.12010000.1 2008/11/19 11:27:03 rmoharan noship $ */
3:
4: TYPE Line_id_Rec_Type IS RECORD
5: ( LINE_ID OE_Order_Lines_All.LINE_ID%TYPE
6: , LINE_NUMBER OE_Order_Lines_All.LINE_NUMBER%TYPE
7: , SHIPMENT_NUMBER OE_Order_Lines_All.SHIPMENT_NUMBER%TYPE
8: , HEADER_ID OE_Order_Lines_All.HEADER_ID%TYPE
9: , ORDERED_QUANTITY OE_Order_Lines_All.ORDERED_QUANTITY%TYPE
10: , ORDERED_QUANTITY2 OE_Order_Lines_All.ORDERED_QUANTITY2%TYPE

Line 7: , SHIPMENT_NUMBER OE_Order_Lines_All.SHIPMENT_NUMBER%TYPE

3:
4: TYPE Line_id_Rec_Type IS RECORD
5: ( LINE_ID OE_Order_Lines_All.LINE_ID%TYPE
6: , LINE_NUMBER OE_Order_Lines_All.LINE_NUMBER%TYPE
7: , SHIPMENT_NUMBER OE_Order_Lines_All.SHIPMENT_NUMBER%TYPE
8: , HEADER_ID OE_Order_Lines_All.HEADER_ID%TYPE
9: , ORDERED_QUANTITY OE_Order_Lines_All.ORDERED_QUANTITY%TYPE
10: , ORDERED_QUANTITY2 OE_Order_Lines_All.ORDERED_QUANTITY2%TYPE
11: , REQUEST_DATE OE_Order_Lines_All.REQUEST_DATE%TYPE );

Line 8: , HEADER_ID OE_Order_Lines_All.HEADER_ID%TYPE

4: TYPE Line_id_Rec_Type IS RECORD
5: ( LINE_ID OE_Order_Lines_All.LINE_ID%TYPE
6: , LINE_NUMBER OE_Order_Lines_All.LINE_NUMBER%TYPE
7: , SHIPMENT_NUMBER OE_Order_Lines_All.SHIPMENT_NUMBER%TYPE
8: , HEADER_ID OE_Order_Lines_All.HEADER_ID%TYPE
9: , ORDERED_QUANTITY OE_Order_Lines_All.ORDERED_QUANTITY%TYPE
10: , ORDERED_QUANTITY2 OE_Order_Lines_All.ORDERED_QUANTITY2%TYPE
11: , REQUEST_DATE OE_Order_Lines_All.REQUEST_DATE%TYPE );
12:

Line 9: , ORDERED_QUANTITY OE_Order_Lines_All.ORDERED_QUANTITY%TYPE

5: ( LINE_ID OE_Order_Lines_All.LINE_ID%TYPE
6: , LINE_NUMBER OE_Order_Lines_All.LINE_NUMBER%TYPE
7: , SHIPMENT_NUMBER OE_Order_Lines_All.SHIPMENT_NUMBER%TYPE
8: , HEADER_ID OE_Order_Lines_All.HEADER_ID%TYPE
9: , ORDERED_QUANTITY OE_Order_Lines_All.ORDERED_QUANTITY%TYPE
10: , ORDERED_QUANTITY2 OE_Order_Lines_All.ORDERED_QUANTITY2%TYPE
11: , REQUEST_DATE OE_Order_Lines_All.REQUEST_DATE%TYPE );
12:
13: G_ORG_ID OE_Order_Headers_All.ORG_ID%TYPE;

Line 10: , ORDERED_QUANTITY2 OE_Order_Lines_All.ORDERED_QUANTITY2%TYPE

6: , LINE_NUMBER OE_Order_Lines_All.LINE_NUMBER%TYPE
7: , SHIPMENT_NUMBER OE_Order_Lines_All.SHIPMENT_NUMBER%TYPE
8: , HEADER_ID OE_Order_Lines_All.HEADER_ID%TYPE
9: , ORDERED_QUANTITY OE_Order_Lines_All.ORDERED_QUANTITY%TYPE
10: , ORDERED_QUANTITY2 OE_Order_Lines_All.ORDERED_QUANTITY2%TYPE
11: , REQUEST_DATE OE_Order_Lines_All.REQUEST_DATE%TYPE );
12:
13: G_ORG_ID OE_Order_Headers_All.ORG_ID%TYPE;
14: G_Update_ISO_From_Req BOOLEAN := FALSE;

Line 11: , REQUEST_DATE OE_Order_Lines_All.REQUEST_DATE%TYPE );

7: , SHIPMENT_NUMBER OE_Order_Lines_All.SHIPMENT_NUMBER%TYPE
8: , HEADER_ID OE_Order_Lines_All.HEADER_ID%TYPE
9: , ORDERED_QUANTITY OE_Order_Lines_All.ORDERED_QUANTITY%TYPE
10: , ORDERED_QUANTITY2 OE_Order_Lines_All.ORDERED_QUANTITY2%TYPE
11: , REQUEST_DATE OE_Order_Lines_All.REQUEST_DATE%TYPE );
12:
13: G_ORG_ID OE_Order_Headers_All.ORG_ID%TYPE;
14: G_Update_ISO_From_Req BOOLEAN := FALSE;
15: -- Confirming IR initiated change.This global is created to mark that the change on