[Home] [Help]
5: G_PKG_Name CONSTANT VARCHAR2(30) := 'OE_INTERNAL_REQUISITION_PVT';
6:
7: Procedure Get_Eligible_ISO_Shipment -- Body definition
8: ( P_internal_req_line_id IN PO_Requisition_Lines_All.Requisition_Line_id%TYPE
9: , P_internal_req_header_id IN PO_Requisition_Headers_All.Requisition_Header_id%TYPE
10: , X_line_ids_rec OUT NOCOPY Line_Id_Rec_Type
11: , X_return_status OUT NOCOPY VARCHAR2
12: ) IS
13: --
526:
527: Procedure Apply_Hold_for_IReq -- Body definition
528: ( P_API_Version IN NUMBER
529: , P_internal_req_line_id IN PO_Requisition_Lines_All.Requisition_Line_id%TYPE
530: , P_internal_req_header_id IN PO_Requisition_Headers_All.Requisition_Header_id%TYPE
531: , X_msg_count OUT NOCOPY NUMBER
532: , X_msg_data OUT NOCOPY VARCHAR2
533: , X_return_status OUT NOCOPY VARCHAR2
534: ) IS
536: --
537: l_API_name Constant Varchar2(30) := 'APPLY_HOLD_FOR_IREQ';
538: l_API_version Constant Number := 1.0;
539:
540: l_req_hdr_id PO_Requisition_Headers_All.Requisition_Header_id%TYPE;
541: l_line_ids_rec Line_Id_rec_Type;
542: l_return_status VARCHAR2(1);
543: l_msg_count NUMBER;
544: l_msg_data VARCHAR2(2000);
686:
687: Procedure Release_Hold_for_IReq -- Body definition
688: ( P_API_Version IN NUMBER
689: , P_internal_req_line_id IN PO_Requisition_Lines_All.Requisition_Line_id%TYPE
690: , P_internal_req_header_id IN PO_Requisition_Headers_All.Requisition_Header_id%TYPE
691: , X_msg_count OUT NOCOPY NUMBER
692: , X_msg_data OUT NOCOPY VARCHAR2
693: , X_return_status OUT NOCOPY VARCHAR2
694: ) IS
695: --
696: l_API_name Constant Varchar2(30) := 'RELEASE_HOLD_FOR_IREQ';
697: l_API_version Constant Number := 1.0;
698:
699: l_req_hdr_id PO_Requisition_Headers_All.Requisition_Header_id%TYPE;
700: l_line_id NUMBER;
701: l_header_id NUMBER;
702: l_return_status VARCHAR2(1);
703: l_msg_count NUMBER;
884:
885: Procedure Is_IReq_Changable -- Body definition
886: ( P_API_Version IN NUMBER
887: , P_internal_req_line_id IN PO_Requisition_Lines_All.Requisition_Line_id%TYPE
888: , P_internal_req_header_id IN PO_Requisition_Headers_All.Requisition_Header_id%TYPE
889: , X_Update_Allowed OUT NOCOPY BOOLEAN
890: , X_Cancel_Allowed OUT NOCOPY BOOLEAN
891: , X_msg_count OUT NOCOPY NUMBER
892: , X_msg_data OUT NOCOPY VARCHAR2
902: --
903: l_API_name Constant Varchar2(30) := 'IS_IREQ_CHANGABLE';
904: l_API_version Constant Number := 1.0;
905:
906: l_req_hdr_id PO_Requisition_Headers_All.Requisition_Header_id%TYPE;
907: l_header_id NUMBER;
908: l_line_id NUMBER;
909: l_lines_ctr NUMBER := 0;
910: l_cancel_eligble_lin NUMBER := 0;
1189:
1190: Procedure Call_Process_Order_for_IReq -- Body definition
1191: ( P_API_Version IN NUMBER
1192: , P_internal_req_line_id IN PO_Requisition_Lines_All.Requisition_Line_id%TYPE
1193: , P_internal_req_header_id IN PO_Requisition_Headers_All.Requisition_Header_id%TYPE
1194: , P_Mode IN VARCHAR2
1195: , P_Cancel_ISO IN BOOLEAN
1196: , P_Cancel_ISO_lines IN BOOLEAN
1197: , P_New_Request_Date IN DATE
1224: --
1225: l_API_name Constant Varchar2(30) := 'CALL_PROCESS_ORDER_FOR_IREQ';
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;