DBA Data[Home] [Help]

APPS.OE_INTERNAL_REQUISITION_PVT dependencies on PO_REQUISITION_LINES_ALL

Line 8: ( P_internal_req_line_id IN PO_Requisition_Lines_All.Requisition_Line_id%TYPE

4: -- Global constant holding the package name
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

Line 529: , P_internal_req_line_id IN PO_Requisition_Lines_All.Requisition_Line_id%TYPE

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

Line 591: from po_requisition_lines_all

587: Begin
588: oe_debug_pub.add( ' Retrieving Requisition Header id',5);
589: select requisition_header_id
590: into l_req_hdr_id
591: from po_requisition_lines_all
592: where requisition_line_id = P_internal_req_line_id;
593:
594: IF l_req_hdr_id IS NULL THEN
595: oe_debug_pub.add( ' Invalid value for Requisition Header',5);

Line 689: , P_internal_req_line_id IN PO_Requisition_Lines_All.Requisition_Line_id%TYPE

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

Line 752: from po_requisition_lines_all

748: Begin
749: oe_debug_pub.add( ' Retrieving Requisition Header id',5);
750: select requisition_header_id
751: into l_req_hdr_id
752: from po_requisition_lines_all
753: where requisition_line_id = P_internal_req_line_id;
754:
755: IF l_req_hdr_id IS NULL THEN
756: oe_debug_pub.add( ' Invalid value for Requisition Header',5);

Line 887: , P_internal_req_line_id IN PO_Requisition_Lines_All.Requisition_Line_id%TYPE

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

Line 1060: from po_requisition_lines_all

1056: Begin
1057: oe_debug_pub.add( ' Retrieving Requisition Header id',5);
1058: select requisition_header_id
1059: into l_req_hdr_id
1060: from po_requisition_lines_all
1061: where requisition_line_id = P_internal_req_line_id;
1062:
1063: IF l_req_hdr_id IS NULL THEN
1064: oe_debug_pub.add( ' Invalid value for Requisition Header',5);

Line 1192: , P_internal_req_line_id IN PO_Requisition_Lines_All.Requisition_Line_id%TYPE

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

Line 1335: from po_requisition_lines_all

1331: oe_debug_pub.add( ' Retrieving Requisition Header id',5);
1332: END IF;
1333: select requisition_header_id
1334: into l_req_hdr_id
1335: from po_requisition_lines_all
1336: where requisition_line_id = P_internal_req_line_id;
1337:
1338: IF l_req_hdr_id IS NULL THEN
1339: IF l_debug_level > 0 THEN