DBA Data[Home] [Help]

APPS.OE_INTERNAL_REQUISITION_PVT dependencies on PO_REQUISITION_HEADERS_ALL

Line 12: , P_internal_req_header_id IN PO_Requisition_Headers_All.Requisition_Header_id%TYPE

8: g_fnd_debug CONSTANT VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
9:
10: Procedure Get_Eligible_ISO_Shipment -- Body definition
11: ( P_internal_req_line_id IN PO_Requisition_Lines_All.Requisition_Line_id%TYPE
12: , P_internal_req_header_id IN PO_Requisition_Headers_All.Requisition_Header_id%TYPE
13: , X_line_ids_rec OUT NOCOPY Line_Id_Rec_Type
14: , X_return_status OUT NOCOPY VARCHAR2
15: ) IS
16: --

Line 533: , P_internal_req_header_id IN PO_Requisition_Headers_All.Requisition_Header_id%TYPE

529:
530: Procedure Apply_Hold_for_IReq -- Body definition
531: ( P_API_Version IN NUMBER
532: , P_internal_req_line_id IN PO_Requisition_Lines_All.Requisition_Line_id%TYPE
533: , P_internal_req_header_id IN PO_Requisition_Headers_All.Requisition_Header_id%TYPE
534: , X_msg_count OUT NOCOPY NUMBER
535: , X_msg_data OUT NOCOPY VARCHAR2
536: , X_return_status OUT NOCOPY VARCHAR2
537: ) IS

Line 543: l_req_hdr_id PO_Requisition_Headers_All.Requisition_Header_id%TYPE;

539: --
540: l_API_name Constant Varchar2(30) := 'APPLY_HOLD_FOR_IREQ';
541: l_API_version Constant Number := 1.0;
542:
543: l_req_hdr_id PO_Requisition_Headers_All.Requisition_Header_id%TYPE;
544: l_line_ids_rec Line_Id_rec_Type;
545: l_return_status VARCHAR2(1);
546: l_msg_count NUMBER;
547: l_msg_data VARCHAR2(2000);

Line 737: , P_internal_req_header_id IN PO_Requisition_Headers_All.Requisition_Header_id%TYPE

733:
734: Procedure Release_Hold_for_IReq -- Body definition
735: ( P_API_Version IN NUMBER
736: , P_internal_req_line_id IN PO_Requisition_Lines_All.Requisition_Line_id%TYPE
737: , P_internal_req_header_id IN PO_Requisition_Headers_All.Requisition_Header_id%TYPE
738: , X_msg_count OUT NOCOPY NUMBER
739: , X_msg_data OUT NOCOPY VARCHAR2
740: , X_return_status OUT NOCOPY VARCHAR2
741: ) IS

Line 746: l_req_hdr_id PO_Requisition_Headers_All.Requisition_Header_id%TYPE;

742: --
743: l_API_name Constant Varchar2(30) := 'RELEASE_HOLD_FOR_IREQ';
744: l_API_version Constant Number := 1.0;
745:
746: l_req_hdr_id PO_Requisition_Headers_All.Requisition_Header_id%TYPE;
747: l_line_id NUMBER;
748: l_header_id NUMBER;
749: l_return_status VARCHAR2(1);
750: l_msg_count NUMBER;

Line 980: , P_internal_req_header_id IN PO_Requisition_Headers_All.Requisition_Header_id%TYPE

976:
977: Procedure Is_IReq_Changable -- Body definition
978: ( P_API_Version IN NUMBER
979: , P_internal_req_line_id IN PO_Requisition_Lines_All.Requisition_Line_id%TYPE
980: , P_internal_req_header_id IN PO_Requisition_Headers_All.Requisition_Header_id%TYPE
981: , X_Update_Allowed OUT NOCOPY BOOLEAN
982: , X_Cancel_Allowed OUT NOCOPY BOOLEAN
983: , X_msg_count OUT NOCOPY NUMBER
984: , X_msg_data OUT NOCOPY VARCHAR2

Line 998: l_req_hdr_id PO_Requisition_Headers_All.Requisition_Header_id%TYPE;

994: --
995: l_API_name Constant Varchar2(30) := 'IS_IREQ_CHANGABLE';
996: l_API_version Constant Number := 1.0;
997:
998: l_req_hdr_id PO_Requisition_Headers_All.Requisition_Header_id%TYPE;
999: l_header_id NUMBER;
1000: l_line_id NUMBER;
1001: l_lines_ctr NUMBER := 0;
1002: l_cancel_eligble_lin NUMBER := 0;

Line 1325: , P_internal_req_header_id IN PO_Requisition_Headers_All.Requisition_Header_id%TYPE

1321:
1322: Procedure Call_Process_Order_for_IReq -- Body definition
1323: ( P_API_Version IN NUMBER
1324: , P_internal_req_line_id IN PO_Requisition_Lines_All.Requisition_Line_id%TYPE
1325: , P_internal_req_header_id IN PO_Requisition_Headers_All.Requisition_Header_id%TYPE
1326: , P_Mode IN VARCHAR2
1327: , P_Cancel_ISO IN BOOLEAN
1328: , P_Cancel_ISO_lines IN BOOLEAN
1329: , P_New_Request_Date IN DATE

Line 1360: l_req_hdr_id PO_Requisition_Headers_All.Requisition_Header_id%TYPE;

1356: --
1357: l_API_name Constant Varchar2(30) := 'CALL_PROCESS_ORDER_FOR_IREQ';
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;