APPS.FA_ADDITIONS_PKG dependencies on FA_ADDITIONS_B

Line 92: CURSOR C IS SELECT rowid FROM fa_additions_B

88: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
89:
90: h_error_message varchar2(255);
91:
92: CURSOR C IS SELECT rowid FROM fa_additions_B
93: WHERE asset_id = X_Asset_Id;
94: CURSOR C2 IS SELECT fa_additions_s.nextval FROM sys.dual;
95:
96: l_attribute15 varchar2(150);

Line 114: INSERT INTO fa_additions_B(

110: else
111: l_attribute15 := X_attribute15;
112: end if;
113:
114: INSERT INTO fa_additions_B(
115: asset_id,
116: asset_number,
117: asset_key_ccid,
118: current_units,

Line 323: if instr (h_error_message, 'FA_ADDITIONS_B_U2') <> 0 then

319: exception
320: when dup_val_on_index then
321: h_error_message := SQLERRM;
322:
323: if instr (h_error_message, 'FA_ADDITIONS_B_U2') <> 0 then
324: FA_SRVR_MSG.add_message(
325: CALLING_FN => 'fa_additions_pkg.insert_row',
326: NAME => 'FA_ADD_ASSET_NUMBER_EXISTS',
327: TOKEN1 => 'ASSET_NUMBER',

Line 335: elsif instr (h_error_message, 'FA_ADDITIONS_B_U3') <> 0 then

331: CALLING_FN => 'fa_additions_pkg.insert_row'
332: ,p_log_level_rec => p_log_level_rec);
333: raise;
334:
335: elsif instr (h_error_message, 'FA_ADDITIONS_B_U3') <> 0 then
336: FA_SRVR_MSG.add_message(
337: CALLING_FN => 'fa_additions_pkg.insert_row',
338: NAME => 'FA_ADD_TAG_NUMBER_EXISTS',
339: TOKEN1 => 'TAG_NUMBER',

Line 424: FROM fa_additions_b

420: X_Calling_Fn VARCHAR2,
421: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
422: CURSOR C IS
423: SELECT *
424: FROM fa_additions_b
425: WHERE rowid = X_Rowid
426: FOR UPDATE of Asset_Id NOWAIT;
427: Recinfo C%ROWTYPE;
428:

Line 701: from fa_additions_b

697: BEGIN
698: if (X_Rowid is NULL) then
699: select rowid
700: into l_rowid
701: from fa_additions_b
702: where asset_id = X_Asset_Id;
703: else
704: l_rowid := X_Rowid;
705: end if;

Line 713: UPDATE fa_additions_b

709: else
710: l_temp_attribute15 := X_attribute15;
711: end if;
712:
713: UPDATE fa_additions_b
714: SET
715: asset_id = decode(X_Asset_Id,
716: NULL, asset_id,
717: FND_API.G_MISS_NUM, NULL,

Line 1083: -- CURSOR C IS SELECT asset_id FROM fa_additions_B

1079: X_Asset_Id number,
1080: X_calling_Fn VARCHAR2,
1081: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
1082:
1083: -- CURSOR C IS SELECT asset_id FROM fa_additions_B
1084: -- WHERE rowid = X_Rowid;
1085: h_asset_id number(15);
1086: BEGIN
1087:

Line 1099: DELETE FROM fa_additions_b

1095: if (sql%notfound) then
1096: raise no_data_found;
1097: end if;
1098:
1099: DELETE FROM fa_additions_b
1100: WHERE asset_id = X_asset_id;
1101:
1102: if (SQL%NOTFOUND) then
1103: Raise NO_DATA_FOUND;

Line 1121: UPDATE fa_additions_b

1117: PROCEDURE Update_Units(X_Asset_Id NUMBER,
1118: X_Calling_Fn VARCHAR2,
1119: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
1120: BEGIN
1121: UPDATE fa_additions_b
1122: SET current_units = (select units from fa_asset_history
1123: where asset_id = X_Asset_Id
1124: and date_ineffective is null)
1125: WHERE asset_id = X_Asset_Id;

Line 1152: from FA_ADDITIONS_B B

1148: -- delete from tl table if same asset doesn't exist in base table
1149: delete from FA_ADDITIONS_TL T
1150: where not exists
1151: (select NULL
1152: from FA_ADDITIONS_B B
1153: where B.ASSET_ID = T.ASSET_ID
1154: );
1155:
1156: -- repair description in tl table

Line 1306: from fa_additions_b

1302: user_id := fnd_load_util.owner_id (X_Owner);
1303:
1304: select count(*)
1305: into h_record_exists
1306: from fa_additions_b
1307: where asset_id = X_Asset_Id;
1308:
1309: if (h_record_exists > 0) then
1310:

Line 1313: from fa_additions_b

1309: if (h_record_exists > 0) then
1310:
1311: select last_updated_by, last_update_date
1312: into db_last_updated_by, db_last_update_date
1313: from fa_additions_b
1314: where asset_id = X_Asset_Id;
1315:
1316: if (fnd_load_util.upload_test(user_id, x_last_update_date,
1317: db_last_updated_by, db_last_update_date,