DBA Data[Home] [Help]

APPS.FA_MASS_ADD_VALIDATE dependencies on FA_ADDITIONS

Line 31: from fa_additions

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

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

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

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

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

Line 130: from fa_additions

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