APPS.FA_MASS_ADDITIONS_PKG3 dependencies on FA_MASS_ADDITIONS

Line 1: PACKAGE BODY FA_MASS_ADDITIONS_PKG3 as

1: PACKAGE BODY FA_MASS_ADDITIONS_PKG3 as
2: /* $Header: faxima3b.pls 120.9 2009/07/17 03:31:44 snandiko ship $ */
3:
4: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
5: X_Mass_Addition_Id IN OUT NOCOPY NUMBER ,

Line 166: CURSOR C IS SELECT rowid FROM fa_mass_additions

162: X_invoice_line_number NUMBER DEFAULT NULL,
163: X_po_distribution_id NUMBER DEFAULT NULL,
164: X_warranty_number VARCHAR2 DEFAULT NULL,
165: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
166: CURSOR C IS SELECT rowid FROM fa_mass_additions
167: WHERE mass_addition_id = X_Mass_Addition_Id;
168: CURSOR C2 IS SELECT fa_mass_additions_s.nextval FROM sys.dual;
169: BEGIN
170: if (X_Mass_Addition_Id is NULL) then

Line 168: CURSOR C2 IS SELECT fa_mass_additions_s.nextval FROM sys.dual;

164: X_warranty_number VARCHAR2 DEFAULT NULL,
165: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
166: CURSOR C IS SELECT rowid FROM fa_mass_additions
167: WHERE mass_addition_id = X_Mass_Addition_Id;
168: CURSOR C2 IS SELECT fa_mass_additions_s.nextval FROM sys.dual;
169: BEGIN
170: if (X_Mass_Addition_Id is NULL) then
171: OPEN C2;
172: FETCH C2 INTO X_Mass_Addition_Id;

Line 176: INSERT INTO fa_mass_additions(

172: FETCH C2 INTO X_Mass_Addition_Id;
173: CLOSE C2;
174: end if;
175:
176: INSERT INTO fa_mass_additions(
177:
178: mass_addition_id,
179: asset_number,
180: tag_number,

Line 516: END FA_MASS_ADDITIONS_PKG3;

512:
513:
514: ----
515:
516: END FA_MASS_ADDITIONS_PKG3;