DBA Data[Home] [Help]

APPS.OE_INTERNAL_REQUISITION_PVT dependencies on OE_ORDER_PUB

Line 112: l_line_rec OE_Order_Pub.Line_Rec_Type;

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

Line 251: l_line_rec OE_Order_Pub.Line_Rec_Type;

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

Line 358: l_header_rec OE_Order_Pub.Header_Rec_Type;

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

Line 415: (p_line_Tbl IN OE_Order_PUB.Line_Tbl_Type

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

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

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

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

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

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

1226: l_API_version Constant Number := 1.0;
1227: --
1228: l_req_hdr_id PO_Requisition_Headers_All.Requisition_Header_id%TYPE;
1229: l_line_ids_rec Line_Id_rec_Type;
1230: l_line_orig_rec OE_Order_PUB.Line_Rec_Type := OE_ORDER_PUB.G_MISS_LINE_REC;
1231: l_line_tbl OE_Order_PUB.Line_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_TBL;
1232: l_control_rec OE_GLOBALS.Control_Rec_Type;
1233: l_return_status VARCHAR2(1);
1234: l_header_rec OE_Order_PUB.Header_Rec_Type := OE_ORDER_PUB.G_MISS_HEADER_REC;

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

1227: --
1228: l_req_hdr_id PO_Requisition_Headers_All.Requisition_Header_id%TYPE;
1229: l_line_ids_rec Line_Id_rec_Type;
1230: l_line_orig_rec OE_Order_PUB.Line_Rec_Type := OE_ORDER_PUB.G_MISS_LINE_REC;
1231: l_line_tbl OE_Order_PUB.Line_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_TBL;
1232: l_control_rec OE_GLOBALS.Control_Rec_Type;
1233: l_return_status VARCHAR2(1);
1234: l_header_rec OE_Order_PUB.Header_Rec_Type := OE_ORDER_PUB.G_MISS_HEADER_REC;
1235: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type := OE_ORDER_PUB.G_MISS_HEADER_REC;

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

1230: l_line_orig_rec OE_Order_PUB.Line_Rec_Type := OE_ORDER_PUB.G_MISS_LINE_REC;
1231: l_line_tbl OE_Order_PUB.Line_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_TBL;
1232: l_control_rec OE_GLOBALS.Control_Rec_Type;
1233: l_return_status VARCHAR2(1);
1234: l_header_rec OE_Order_PUB.Header_Rec_Type := OE_ORDER_PUB.G_MISS_HEADER_REC;
1235: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type := OE_ORDER_PUB.G_MISS_HEADER_REC;
1236: l_line_id NUMBER;
1237: l_header_id NUMBER;
1238: l_order_header_id NUMBER;

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

1231: l_line_tbl OE_Order_PUB.Line_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_TBL;
1232: l_control_rec OE_GLOBALS.Control_Rec_Type;
1233: l_return_status VARCHAR2(1);
1234: l_header_rec OE_Order_PUB.Header_Rec_Type := OE_ORDER_PUB.G_MISS_HEADER_REC;
1235: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type := OE_ORDER_PUB.G_MISS_HEADER_REC;
1236: l_line_id NUMBER;
1237: l_header_id NUMBER;
1238: l_order_header_id NUMBER;
1239: l_line_ord_qty2 NUMBER;