APPS.JAI_PO_CMN_PKG dependencies on PO_HEADERS_ALL

Line 48: v_po_num po_headers_all.segment1 % type;

44: v_line_num po_lines_all.line_num % type;
45: v_item_id rcv_shipment_lines.item_id % type;
46: v_vendor_name po_vendors.vendor_name % type;
47: v_receipt_num rcv_shipment_headers.receipt_num % type;
48: v_po_num po_headers_all.segment1 % type;
49: v_unit_price number;
50: v_primary_uom mtl_system_items.primary_unit_of_measure % type;
51:
52: CURSOR org_cur IS

Line 94: FROM po_headers_all

90: WHERE shipment_header_id = v_rcv_rec.shipment_header_id;
91:
92: CURSOR po_cur IS
93: SELECT segment1
94: FROM po_headers_all
95: WHERE po_header_id = v_rcv_rec.po_header_id;
96:
97: CURSOR uom_cur IS
98: SELECT primary_unit_of_measure

Line 332: FROM Po_Headers_All

328: /*------------------------------------------------------------------------------------------------------------*/
329: FUNCTION Ja_In_Po_Get_Loc_Id( p_po_header_id IN NUMBER ) RETURN NUMBER IS
330:
331: CURSOR Fetch_Location_Id_Cur IS SELECT Ship_To_Location_Id
332: FROM Po_Headers_All
333: WHERE Po_Header_Id = p_po_header_id;
334:
335: v_location_id NUMBER;
336:

Line 403: FROM Po_Headers_All

399: */
400:
401: CURSOR Fetch_Curr_Details_Cur IS
402: SELECT Rate, Rate_Date, Rate_Type
403: FROM Po_Headers_All
404: WHERE Po_Header_Id = p_po_header_id;
405:
406: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_po_cmn_pkg.ja_in_po_assessable_val_conv';
407:

Line 416: FROM Po_Headers_All

412:
413: FUNCTION Ja_In_Po_Get_Org_Id RETURN NUMBER IS
414:
415: CURSOR Fetch_Org_Id_Cur IS SELECT NVL( Org_Id, -99 )
416: FROM Po_Headers_All
417: WHERE Po_Header_Id = p_po_header_id;
418:
419: v_org_id NUMBER;
420:

Line 647: from po_headers_all

643:
644:
645: cursor fetch_vendor_id_cur IS
646: select vendor_id,vendor_site_id
647: from po_headers_all
648: where po_header_id=v_po_hdr_id;
649:
650: --Added by kunkumar End
651: