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.6 2005/07/25 10:01:12 yyoon 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 749: DELETE FROM fa_mass_additions

745: ---
746:
747: PROCEDURE Delete_Row(X_Rowid VARCHAR2,p_log_level_rec in fa_api_types.log_level_rec_type default null) IS
748: BEGIN
749: DELETE FROM fa_mass_additions
750: WHERE rowid = X_Rowid;
751:
752: if (SQL%NOTFOUND) then
753: Raise NO_DATA_FOUND;

Line 769: From Fa_MAss_Additions

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

Line 774: END FA_MASS_ADDITIONS_PKG2;

770: Where Merge_PArent_MAss_Additions_ID = X_Mass_Addition_ID;
771:
772: End Select_Summary;
773:
774: END FA_MASS_ADDITIONS_PKG2;