84: X_Created_By NUMBER DEFAULT NULL,
85: X_Creation_Date DATE DEFAULT NULL,
86: X_Last_Update_Login NUMBER DEFAULT NULL,
87: X_Calling_Fn VARCHAR2,
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
417: X_Inventorial VARCHAR2,
418: X_Commitment VARCHAR2 DEFAULT NULL,
419: X_Investment_Law VARCHAR2 DEFAULT NULL,
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
687: X_Last_Updated_By NUMBER DEFAULT NULL,
688: X_Last_Update_Login NUMBER DEFAULT NULL,
689: X_Return_Status OUT NOCOPY BOOLEAN,
690: X_Calling_Fn VARCHAR2,
691: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
692:
693: l_asset_id number;
694: l_rowid rowid;
695: l_temp_attribute15 varchar2(150);
1077:
1078: PROCEDURE Delete_Row(X_Rowid VARCHAR2,
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);
1115:
1116:
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
1280: X_gf_Attribute18 IN VARCHAR2 DEFAULT NULL,
1281: X_gf_Attribute19 IN VARCHAR2 DEFAULT NULL,
1282: X_gf_Attribute20 IN VARCHAR2 DEFAULT NULL,
1283: X_gf_Attribute_Category IN VARCHAR2 DEFAULT NULL,
1284: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
1285:
1286: h_asset_id number;
1287: h_asset_number varchar2(15);
1288: h_record_exists number(15);
1507: X_Asset_Id IN NUMBER,
1508: X_Owner IN VARCHAR2,
1509: X_Last_Update_Date IN DATE,
1510: X_Description IN VARCHAR2,
1511: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
1512:
1513: user_id number;
1514:
1515: db_last_updated_by number;
1631: x_gf_attribute18 IN VARCHAR2,
1632: x_gf_attribute19 IN VARCHAR2,
1633: x_gf_attribute20 IN VARCHAR2,
1634: x_gf_attribute_category IN VARCHAR2
1635: ,p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
1636:
1637: BEGIN
1638:
1639: if (x_upload_mode = 'NLS') then