APPS.JAI_PO_HA_TRIGGER_PKG dependencies on JAI_PO_LINE_LOCATIONS

Line 335: SELECT JAI_PO_LINE_LOCATIONS_S.NEXTVAL

331:
332: -- Get the Line Focus Id from the Sequence
333:
334: CURSOR Fetch_Focus_Id IS
335: SELECT JAI_PO_LINE_LOCATIONS_S.NEXTVAL
336: FROM Dual;
337:
338: CURSOR Chk_Line_Count IS
339: SELECT NVL( COUNT( Po_Line_Id ), 0 )

Line 340: FROM JAI_PO_LINE_LOCATIONS

336: FROM Dual;
337:
338: CURSOR Chk_Line_Count IS
339: SELECT NVL( COUNT( Po_Line_Id ), 0 )
340: FROM JAI_PO_LINE_LOCATIONS
341: WHERE Po_Header_Id = v_po_hdr_id;
342:
343:
344: CURSOR Lines_Cur IS

Line 346: FROM JAI_PO_LINE_LOCATIONS

342:
343:
344: CURSOR Lines_Cur IS
345: SELECT DISTINCT Po_Line_Id
346: FROM JAI_PO_LINE_LOCATIONS
347: WHERE Po_Header_Id = v_po_hdr_id;
348:
349: CURSOR Fetch_Item_Cur( Lineid IN NUMBER ) IS
350: SELECT Item_Id

Line 356: FROM JAI_PO_LINE_LOCATIONS

352: WHERE Po_Line_Id = Lineid;
353:
354: CURSOR Line_Loc_Cur( lineid IN NUMBER ) IS
355: SELECT Line_Location_Id
356: FROM JAI_PO_LINE_LOCATIONS
357: WHERE Po_Line_Id = lineid;
358:
359: CURSOR Fetch_Dtls_Cur( lineid IN NUMBER ) IS
360: SELECT Quantity, Unit_Price, Unit_Meas_Lookup_Code

Line 378: FROM JAI_PO_LINE_LOCATIONS

374: WHERE Unit_Of_Measure = v_uom;
375:
376: CURSOR Tax_Flag1_Cur( lineid IN NUMBER ) IS
377: SELECT NVL( Tax_Modified_Flag, 'N' )
378: FROM JAI_PO_LINE_LOCATIONS
379: WHERE Po_Line_Id = lineid
380: AND Line_Location_Id IS NULL;
381:
382:

Line 385: FROM JAI_PO_LINE_LOCATIONS

381:
382:
383: CURSOR Tax_Flag_Cur( lineid IN NUMBER, linelocid IN NUMBER ) IS
384: SELECT NVL( Tax_Modified_Flag, 'N' )
385: FROM JAI_PO_LINE_LOCATIONS
386: WHERE Po_Line_Id = lineid
387: AND Line_Location_Id = linelocid;
388:
389:

Line 717: DELETE FROM JAI_PO_LINE_LOCATIONS

713: WHERE Po_Line_Id = Rec.Po_Line_Id
714: AND NVL( Line_Location_Id, -999 ) = NVL( Rec1.Line_Location_Id, -999 );
715:
716:
717: DELETE FROM JAI_PO_LINE_LOCATIONS
718: WHERE Po_Line_Id = Rec.Po_Line_Id
719: AND NVL( Line_Location_Id, -999 ) = NVL( Rec1.Line_Location_Id, -999 );
720:
721: OPEN Fetch_Focus_Id;

Line 728: INSERT INTO JAI_PO_LINE_LOCATIONS

724:
725: v_service_type_code := jai_ar_rctla_trigger_pkg.get_service_Type(v_vendor_id,v_vendor_site_id , 'V');
726: /*above code added by ssumaith - bug# 6109941 */
727:
728: INSERT INTO JAI_PO_LINE_LOCATIONS
729: (
730: Line_Focus_Id,
731: Line_Location_Id,
732: Po_Line_Id,