APPS.JAI_PO_CMN_PKG dependencies on JAI_PO_LINE_LOCATIONS

Line 253: CURSOR Fetch_Focus_Id IS SELECT JAI_PO_LINE_LOCATIONS_S.NEXTVAL

249: v_total_amt NUMBER;
250:
251: ------------------------------>
252:
253: CURSOR Fetch_Focus_Id IS SELECT JAI_PO_LINE_LOCATIONS_S.NEXTVAL
254: FROM Dual;
255:
256: ------------------------------>
257: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_po_cmn_pkg.insert_line';

Line 274: INSERT INTO JAI_PO_LINE_LOCATIONS( Line_Focus_Id, Line_Location_Id, Po_Line_Id, Po_Header_Id,

270: END IF;
271:
272: IF flag = 'I' THEN
273:
274: INSERT INTO JAI_PO_LINE_LOCATIONS( Line_Focus_Id, Line_Location_Id, Po_Line_Id, Po_Header_Id,
275: Tax_Modified_Flag, Tax_Amount, Total_Amount,
276: Creation_Date, Created_By, Last_Update_Date, Last_Updated_By,
277: Last_Update_Login,Service_type_code )
278: VALUES

Line 286: UPDATE JAI_PO_LINE_LOCATIONS

282: v_last_upd_login,v_service_type_code );
283:
284: ELSIF flag = 'U' THEN
285:
286: UPDATE JAI_PO_LINE_LOCATIONS
287: SET Tax_Modified_flag = 'N',
288: Tax_Amount = 0,
289: Total_Amount = 0,
290: Last_Update_Date = v_last_upd_dt,

Line 672: CURSOR Fetch_Focus_Id IS SELECT JAI_PO_LINE_LOCATIONS_S.NEXTVAL

668:
669: ------------------------------>
670:
671:
672: CURSOR Fetch_Focus_Id IS SELECT JAI_PO_LINE_LOCATIONS_S.NEXTVAL
673: FROM Dual;
674:
675: ------------------------------>
676:

Line 686: v_tax_category_id_holder JAI_PO_LINE_LOCATIONS.tax_category_id%TYPE;

682:
683:
684: ------------------------------>
685: --Start, cbabu for EnhancementBug# 2427465
686: v_tax_category_id_holder JAI_PO_LINE_LOCATIONS.tax_category_id%TYPE;
687: CURSOR c_get_tax_category_id( p_line_location_id IN NUMBER) IS
688: SELECT tax_category_id
689: FROM JAI_PO_LINE_LOCATIONS
690: WHERE line_location_id = p_line_location_id;

Line 689: FROM JAI_PO_LINE_LOCATIONS

685: --Start, cbabu for EnhancementBug# 2427465
686: v_tax_category_id_holder JAI_PO_LINE_LOCATIONS.tax_category_id%TYPE;
687: CURSOR c_get_tax_category_id( p_line_location_id IN NUMBER) IS
688: SELECT tax_category_id
689: FROM JAI_PO_LINE_LOCATIONS
690: WHERE line_location_id = p_line_location_id;
691: -- End, cbabu for EnhancementBug# 2427465
692:
693: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_po_cmn_pkg.process_release_shipment';

Line 734: INSERT INTO JAI_PO_LINE_LOCATIONS(

730:
731:
732: IF flag <> 'U' THEN
733:
734: INSERT INTO JAI_PO_LINE_LOCATIONS(
735: line_focus_id, line_location_id, po_line_id, po_header_id,
736: tax_modified_flag, tax_amount, total_amount,
737: creation_date, created_by, last_update_date, last_updated_by, last_update_login,
738: tax_category_id -- cbabu for EnhancementBug# 2427465