DBA Data[Home] [Help]

APPS.FA_MASS_ADD_VALIDATE dependencies on FA_ADDITIONS

Line 30: from fa_additions

26: is
27:
28: cursor c2 is
29: select asset_number
30: from fa_additions
31: where asset_number = x_asset_number;
32:
33: c2_rec c2%rowtype;
34:

Line 59: --asset number used in fa_additions table?

55: end if;
56:
57: open c2;
58: fetch c2 into c2_rec;
59: --asset number used in fa_additions table?
60: if c2%notfound then
61: open c3;
62: fetch c3 into c3_rec;
63: --asset number used in fa_mass_additions table?

Line 108: -- (find in fa_additions) for the asset to be added to.

104: --
105: -- If Oracle error occurs, Oracle error number is returned.
106: --
107: -- USAGE The asset_id parameter should be the FA (not PA) asset_id
108: -- (find in fa_additions) for the asset to be added to.
109: --
110: -- The book_type_code parameter should be the book_type_code
111: -- found on the invoice line you are attempting to add. (This
112: -- should be the same book type code as on the asset.)

Line 128: from fa_additions

124: is
125:
126: cursor c1 is
127: select asset_type
128: from fa_additions
129: where asset_id = x_asset_id;
130:
131: c1_rec c1%rowtype;
132: