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) 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 322: if instr (h_error_message, 'FA_ADDITIONS_B_U2') <> 0 then

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

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

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

Line 417: FROM fa_additions_b

413: X_Calling_Fn VARCHAR2
414: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
415: CURSOR C IS
416: SELECT *
417: FROM fa_additions_b
418: WHERE rowid = X_Rowid
419: FOR UPDATE of Asset_Id NOWAIT;
420: Recinfo C%ROWTYPE;
421:

Line 696: from fa_additions_b

692: BEGIN
693: if (X_Rowid is NULL) then
694: select rowid
695: into l_rowid
696: from fa_additions_b
697: where asset_id = X_Asset_Id;
698: else
699: l_rowid := X_Rowid;
700: end if;

Line 708: UPDATE fa_additions_b

704: else
705: l_temp_attribute15 := X_attribute15;
706: end if;
707:
708: UPDATE fa_additions_b
709: SET
710: asset_id = decode(X_Asset_Id,
711: NULL, asset_id,
712: FND_API.G_MISS_NUM, NULL,

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

1072: PROCEDURE Delete_Row(X_Rowid VARCHAR2,
1073: X_Asset_Id number,
1074: X_calling_Fn VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
1075:
1076: -- CURSOR C IS SELECT asset_id FROM fa_additions_B
1077: -- WHERE rowid = X_Rowid;
1078: h_asset_id number(15);
1079: BEGIN
1080:

Line 1092: DELETE FROM fa_additions_b

1088: if (sql%notfound) then
1089: raise no_data_found;
1090: end if;
1091:
1092: DELETE FROM fa_additions_b
1093: WHERE asset_id = X_asset_id;
1094:
1095: if (SQL%NOTFOUND) then
1096: Raise NO_DATA_FOUND;

Line 1112: UPDATE fa_additions_b

1108:
1109: PROCEDURE Update_Units(X_Asset_Id NUMBER,
1110: X_Calling_Fn VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
1111: BEGIN
1112: UPDATE fa_additions_b
1113: SET current_units = (select units from fa_asset_history
1114: where asset_id = X_Asset_Id
1115: and date_ineffective is null)
1116: WHERE asset_id = X_Asset_Id;

Line 1142: from FA_ADDITIONS_B B

1138: -- delete from tl table if same asset doesn't exist in base table
1139: delete from FA_ADDITIONS_TL T
1140: where not exists
1141: (select NULL
1142: from FA_ADDITIONS_B B
1143: where B.ASSET_ID = T.ASSET_ID
1144: );
1145:
1146: -- repair description in tl table

Line 1291: from fa_additions_b

1287: user_id := 0;
1288:
1289: select count(*)
1290: into h_record_exists
1291: from fa_additions_b
1292: where asset_id = X_Asset_Id;
1293:
1294: if (h_record_exists > 0) then
1295:

Line 1581: from fa_additions_b

1577: user_id := fnd_load_util.owner_id (X_Owner);
1578:
1579: select count(*)
1580: into h_record_exists
1581: from fa_additions_b
1582: where asset_id = X_Asset_Id;
1583:
1584: if (h_record_exists > 0) then
1585:

Line 1588: from fa_additions_b

1584: if (h_record_exists > 0) then
1585:
1586: select last_updated_by, last_update_date
1587: into db_last_updated_by, db_last_update_date
1588: from fa_additions_b
1589: where asset_id = X_Asset_Id;
1590:
1591: if (fnd_load_util.upload_test(user_id, x_last_update_date,
1592: db_last_updated_by, db_last_update_date,