APPS.FA_MASS_ADDITIONS_PKG2 dependencies on FA_MASS_ADDITIONS

Line 1: PACKAGE BODY FA_MASS_ADDITIONS_PKG2 as

1: PACKAGE BODY FA_MASS_ADDITIONS_PKG2 as
2: /* $Header: faxima2b.pls 120.7 2009/03/27 09:48:20 bridgway ship $ */
3: ----
4: PROCEDURE Lock_Row(X_Rowid VARCHAR2,
5: X_Mass_Addition_Id NUMBER DEFAULT NULL,

Line 282: FROM fa_mass_additions

278: invoice_distribution_id,
279: invoice_line_number,
280: po_distribution_id,
281: warranty_number
282: FROM fa_mass_additions
283: WHERE rowid = X_Rowid
284: FOR UPDATE of Mass_Addition_Id NOWAIT;
285: Recinfo C%ROWTYPE;
286:

Line 752: DELETE FROM fa_mass_additions

748: ---
749:
750: PROCEDURE Delete_Row(X_Rowid VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
751: BEGIN
752: DELETE FROM fa_mass_additions
753: WHERE rowid = X_Rowid;
754:
755: if (SQL%NOTFOUND) then
756: Raise NO_DATA_FOUND;

Line 771: From Fa_MAss_Additions

767: Select NVL(Sum(Fixed_Assets_Cost), 0), NVL(Sum(Fixed_Assets_Cost), 0),
768: NVL(Sum(Fixed_Assets_Units), 0), NVL(Sum(Fixed_Assets_Units), 0)
769: Into X_Total_Cost, X_TOTAL_Cost_RTOT_DB,
770: X_Total_Units, X_Total_Units_RTOT_DB
771: From Fa_MAss_Additions
772: Where Merge_PArent_MAss_Additions_ID = X_Mass_Addition_ID;
773:
774: End Select_Summary;
775:

Line 776: END FA_MASS_ADDITIONS_PKG2;

772: Where Merge_PArent_MAss_Additions_ID = X_Mass_Addition_ID;
773:
774: End Select_Summary;
775:
776: END FA_MASS_ADDITIONS_PKG2;