DBA Data[Home] [Help]

APPS.FA_MASS_ADDITIONS_PKG2 dependencies on FA_API_TYPES

Line 136: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS

132: X_invoice_distribution_id NUMBER DEFAULT NULL,
133: X_invoice_line_number NUMBER DEFAULT NULL,
134: X_po_distribution_id NUMBER DEFAULT NULL,
135: X_warranty_number VARCHAR2 DEFAULT NULL ,
136: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
137: CURSOR C IS
138: SELECT mass_addition_id,
139: asset_number,
140: tag_number,

Line 750: PROCEDURE Delete_Row(X_Rowid VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS

746: END Lock_Row;
747:
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:

Line 765: X_TOTAL_UNITS_RTOT_DB IN OUT NOCOPY NUMBER, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS

761: PROCEDURE Select_Summary(X_MAss_Addition_ID IN NUMBER,
762: X_TOTAL_COST IN OUT NOCOPY NUMBER,
763: X_TOTAL_COST_RTOT_DB IN OUT NOCOPY NUMBER,
764: X_TOTAL_UNITS IN OUT NOCOPY NUMBER,
765: X_TOTAL_UNITS_RTOT_DB IN OUT NOCOPY NUMBER, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
766: Begin
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,