DBA Data[Home] [Help]

APPS.OE_INTERNAL_REQUISITION_PVT dependencies on OE_ORDER_PUB

Line 115: l_line_rec OE_Order_Pub.Line_Rec_Type;

111: , P_Attribute IN VARCHAR2
112: ) RETURN BOOLEAN
113: IS
114: --
115: l_line_rec OE_Order_Pub.Line_Rec_Type;
116: l_return_status VARCHAR2(1);
117: l_line_rowtype_rec OE_AK_ORDER_LINES_V%ROWTYPE;
118: l_attr_update_allowed BOOLEAN := FALSE;
119: l_entity_update_allowed BOOLEAN := FALSE;

Line 254: l_line_rec OE_Order_Pub.Line_Rec_Type;

250: ( P_line_id IN NUMBER
251: ) RETURN BOOLEAN
252: IS
253: --
254: l_line_rec OE_Order_Pub.Line_Rec_Type;
255: l_result NUMBER := OE_PC_GLOBALS.NO;
256: l_rowtype_rec OE_AK_ORDER_LINES_V%ROWTYPE;
257: l_return_status VARCHAR2(1);
258: l_action NUMBER;

Line 361: l_header_rec OE_Order_Pub.Header_Rec_Type;

357: ( P_header_id IN NUMBER
358: ) RETURN BOOLEAN
359: IS
360: --
361: l_header_rec OE_Order_Pub.Header_Rec_Type;
362: l_header_rowtype_rec OE_AK_ORDER_HEADERS_V%ROWTYPE;
363: l_action NUMBER;
364: l_result NUMBER := OE_PC_GLOBALS.NO;
365: --

Line 418: (p_line_Tbl IN OE_Order_PUB.Line_Tbl_Type

414: End Cancel_Header_Allowed;
415:
416:
417: PROCEDURE Process_Line_Entity -- Body definition
418: (p_line_Tbl IN OE_Order_PUB.Line_Tbl_Type
419: ,P_mode IN VARCHAR2
420: ,P_Cancel IN BOOLEAN
421: ,x_return_status OUT NOCOPY VARCHAR2
422: )

Line 425: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_TBL;

421: ,x_return_status OUT NOCOPY VARCHAR2
422: )
423: IS
424:
425: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_TBL;
426: l_x_old_line_tbl OE_Order_PUB.Line_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_TBL;
427: l_control_rec OE_GLOBALS.Control_Rec_Type;
428: l_return_status VARCHAR2(1);
429: l_header_id NUMBER;

Line 426: l_x_old_line_tbl OE_Order_PUB.Line_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_TBL;

422: )
423: IS
424:
425: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_TBL;
426: l_x_old_line_tbl OE_Order_PUB.Line_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_TBL;
427: l_control_rec OE_GLOBALS.Control_Rec_Type;
428: l_return_status VARCHAR2(1);
429: l_header_id NUMBER;
430: l_msg_count NUMBER;

Line 1362: l_line_orig_rec OE_Order_PUB.Line_Rec_Type := OE_ORDER_PUB.G_MISS_LINE_REC;

1358: l_API_version Constant Number := 1.0;
1359: --
1360: l_req_hdr_id PO_Requisition_Headers_All.Requisition_Header_id%TYPE;
1361: l_line_ids_rec Line_Id_rec_Type;
1362: l_line_orig_rec OE_Order_PUB.Line_Rec_Type := OE_ORDER_PUB.G_MISS_LINE_REC;
1363: l_line_tbl OE_Order_PUB.Line_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_TBL;
1364: l_control_rec OE_GLOBALS.Control_Rec_Type;
1365: l_return_status VARCHAR2(1);
1366: l_header_rec OE_Order_PUB.Header_Rec_Type := OE_ORDER_PUB.G_MISS_HEADER_REC;

Line 1363: l_line_tbl OE_Order_PUB.Line_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_TBL;

1359: --
1360: l_req_hdr_id PO_Requisition_Headers_All.Requisition_Header_id%TYPE;
1361: l_line_ids_rec Line_Id_rec_Type;
1362: l_line_orig_rec OE_Order_PUB.Line_Rec_Type := OE_ORDER_PUB.G_MISS_LINE_REC;
1363: l_line_tbl OE_Order_PUB.Line_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_TBL;
1364: l_control_rec OE_GLOBALS.Control_Rec_Type;
1365: l_return_status VARCHAR2(1);
1366: l_header_rec OE_Order_PUB.Header_Rec_Type := OE_ORDER_PUB.G_MISS_HEADER_REC;
1367: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type := OE_ORDER_PUB.G_MISS_HEADER_REC;

Line 1366: l_header_rec OE_Order_PUB.Header_Rec_Type := OE_ORDER_PUB.G_MISS_HEADER_REC;

1362: l_line_orig_rec OE_Order_PUB.Line_Rec_Type := OE_ORDER_PUB.G_MISS_LINE_REC;
1363: l_line_tbl OE_Order_PUB.Line_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_TBL;
1364: l_control_rec OE_GLOBALS.Control_Rec_Type;
1365: l_return_status VARCHAR2(1);
1366: l_header_rec OE_Order_PUB.Header_Rec_Type := OE_ORDER_PUB.G_MISS_HEADER_REC;
1367: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type := OE_ORDER_PUB.G_MISS_HEADER_REC;
1368: l_line_id NUMBER;
1369: l_header_id NUMBER;
1370: l_order_header_id NUMBER;

Line 1367: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type := OE_ORDER_PUB.G_MISS_HEADER_REC;

1363: l_line_tbl OE_Order_PUB.Line_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_TBL;
1364: l_control_rec OE_GLOBALS.Control_Rec_Type;
1365: l_return_status VARCHAR2(1);
1366: l_header_rec OE_Order_PUB.Header_Rec_Type := OE_ORDER_PUB.G_MISS_HEADER_REC;
1367: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type := OE_ORDER_PUB.G_MISS_HEADER_REC;
1368: l_line_id NUMBER;
1369: l_header_id NUMBER;
1370: l_order_header_id NUMBER;
1371: l_line_ord_qty2 NUMBER;