APPS.OE_INTERNAL_REQUISITION_PVT dependencies on PO_REQUISITION_LINES_ALL

Line 11: ( P_internal_req_line_id IN PO_Requisition_Lines_All.Requisition_Line_id%TYPE

7: -- Added for 8583903
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

Line 532: , P_internal_req_line_id IN PO_Requisition_Lines_All.Requisition_Line_id%TYPE

528:
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

Line 613: from po_requisition_lines_all

609: Begin
610: oe_debug_pub.add( ' Retrieving Requisition Header id',5);
611: select requisition_header_id
612: into l_req_hdr_id
613: from po_requisition_lines_all
614: where requisition_line_id = P_internal_req_line_id;
615:
616: IF l_req_hdr_id IS NULL THEN
617: oe_debug_pub.add( ' Invalid value for Requisition Header',5);

Line 736: , P_internal_req_line_id IN PO_Requisition_Lines_All.Requisition_Line_id%TYPE

732:
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

Line 818: from po_requisition_lines_all

814: Begin
815: oe_debug_pub.add( ' Retrieving Requisition Header id',5);
816: select requisition_header_id
817: into l_req_hdr_id
818: from po_requisition_lines_all
819: where requisition_line_id = P_internal_req_line_id;
820:
821: IF l_req_hdr_id IS NULL THEN
822: oe_debug_pub.add( ' Invalid value for Requisition Header',5);

Line 979: , P_internal_req_line_id IN PO_Requisition_Lines_All.Requisition_Line_id%TYPE

975:
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

Line 1171: from po_requisition_lines_all

1167: Begin
1168: oe_debug_pub.add( ' Retrieving Requisition Header id',5);
1169: select requisition_header_id
1170: into l_req_hdr_id
1171: from po_requisition_lines_all
1172: where requisition_line_id = P_internal_req_line_id;
1173:
1174: IF l_req_hdr_id IS NULL THEN
1175: oe_debug_pub.add( ' Invalid value for Requisition Header',5);

Line 1324: , P_internal_req_line_id IN PO_Requisition_Lines_All.Requisition_Line_id%TYPE

1320:
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

Line 1486: from po_requisition_lines_all

1482: oe_debug_pub.add( ' Retrieving Requisition Header id',5);
1483: END IF;
1484: select requisition_header_id
1485: into l_req_hdr_id
1486: from po_requisition_lines_all
1487: where requisition_line_id = P_internal_req_line_id;
1488:
1489: IF l_req_hdr_id IS NULL THEN
1490: IF l_debug_level > 0 THEN