33: c2_rec c2%rowtype;
34:
35: cursor c3 is
36: select asset_number
37: from fa_mass_additions
38: where asset_number = x_asset_number;
39:
40: c3_rec c3%rowtype;
41:
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?
64: if c3%notfound then
65: BEGIN
66: x_numeric_asset_number := TO_NUMBER(x_asset_number);
67: --asset number all numeric?