APPS.JAI_PO_LA_TRIGGER_PKG dependencies on JAI_PO_LINE_LOCATIONS

Line 94: DELETE FROM JAI_PO_LINE_LOCATIONS

90: -- RETURN;`
91: --END IF;
92:
93:
94: DELETE FROM JAI_PO_LINE_LOCATIONS
95: WHERE Po_Line_Id = v_po_line_id;
96:
97: OPEN Check_Llid_Cur;
98: FETCH Check_Llid_Cur INTO dummy;

Line 166: FROM JAI_PO_LINE_LOCATIONS

162:
163: -- Vijay Shankar for Bug# 3184418
164: CURSOR c_tax_modified_flag(p_po_line_id IN NUMBER) IS
165: SELECT tax_modified_flag
166: FROM JAI_PO_LINE_LOCATIONS
167: WHERE po_line_id = p_po_line_id
168: AND line_location_id IS NULL;
169:
170: v_tax_modified_flag CHAR(1);

Line 584: FROM JAI_PO_LINE_LOCATIONS

580: FROM Po_Line_Locations_All
581: WHERE Po_Line_Id = v_po_line_id;
582:
583: CURSOR Fetch_Flag_Cur( llid IN NUMBER ) IS SELECT NVL( Tax_Modified_Flag, 'N' ) Tax_Modified_Flag
584: FROM JAI_PO_LINE_LOCATIONS
585: WHERE Line_Location_Id = llid
586: AND Po_Line_Id = v_po_line_id;
587: BEGIN
588: pv_return_code := jai_constants.successful ;