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.7 2005/07/25 10:03:41 yyoon ship $ */
3:
4: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
5: X_Mass_Addition_Id IN OUT NOCOPY NUMBER ,

Line 144: CURSOR C IS SELECT rowid FROM fa_mass_additions

140: X_invoice_line_number NUMBER DEFAULT NULL,
141: X_po_distribution_id NUMBER DEFAULT NULL,
142: X_warranty_number VARCHAR2 DEFAULT NULL,
143: p_log_level_rec in fa_api_types.log_level_rec_type default null) IS
144: CURSOR C IS SELECT rowid FROM fa_mass_additions
145: WHERE mass_addition_id = X_Mass_Addition_Id;
146: CURSOR C2 IS SELECT fa_mass_additions_s.nextval FROM sys.dual;
147: BEGIN
148: if (X_Mass_Addition_Id is NULL) then

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

142: X_warranty_number VARCHAR2 DEFAULT NULL,
143: p_log_level_rec in fa_api_types.log_level_rec_type default null) IS
144: CURSOR C IS SELECT rowid FROM fa_mass_additions
145: WHERE mass_addition_id = X_Mass_Addition_Id;
146: CURSOR C2 IS SELECT fa_mass_additions_s.nextval FROM sys.dual;
147: BEGIN
148: if (X_Mass_Addition_Id is NULL) then
149: OPEN C2;
150: FETCH C2 INTO X_Mass_Addition_Id;

Line 154: INSERT INTO fa_mass_additions(

150: FETCH C2 INTO X_Mass_Addition_Id;
151: CLOSE C2;
152: end if;
153:
154: INSERT INTO fa_mass_additions(
155:
156: mass_addition_id,
157: asset_number,
158: tag_number,

Line 444: END FA_MASS_ADDITIONS_PKG3;

440: CLOSE C;
441:
442: END Insert_Row;
443:
444: END FA_MASS_ADDITIONS_PKG3;