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) IS
89:
90: h_error_message varchar2(255);
91:
92: CURSOR C IS SELECT rowid FROM fa_additions_B
410: X_Inventorial VARCHAR2,
411: X_Commitment VARCHAR2 DEFAULT NULL,
412: X_Investment_Law VARCHAR2 DEFAULT NULL,
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
682: X_Last_Update_Login NUMBER DEFAULT NULL,
683: X_Return_Status OUT NOCOPY BOOLEAN,
684: X_Calling_Fn VARCHAR2
685:
686: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
687:
688: l_asset_id number;
689: l_rowid rowid;
690: l_temp_attribute15 varchar2(150);
1070: END Update_Row;
1071:
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);
1106:
1107:
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
1267: X_gf_Attribute18 IN VARCHAR2 DEFAULT NULL,
1268: X_gf_Attribute19 IN VARCHAR2 DEFAULT NULL,
1269: X_gf_Attribute20 IN VARCHAR2 DEFAULT NULL,
1270: X_gf_Attribute_Category IN VARCHAR2 DEFAULT NULL
1271: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
1272:
1273: h_asset_id number;
1274: h_asset_number varchar2(15);
1275: h_record_exists number(15);
1555: X_gf_Attribute18 IN VARCHAR2 DEFAULT NULL,
1556: X_gf_Attribute19 IN VARCHAR2 DEFAULT NULL,
1557: X_gf_Attribute20 IN VARCHAR2 DEFAULT NULL,
1558: X_gf_Attribute_Category IN VARCHAR2 DEFAULT NULL,
1559: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
1560:
1561: h_asset_id number;
1562: h_asset_number varchar2(15);
1563: h_record_exists number(15);
1780:
1781: PROCEDURE TRANSLATE_ROW(
1782: X_Asset_Id IN NUMBER,
1783: X_Description IN VARCHAR2
1784: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
1785:
1786: begin
1787:
1788: update FA_ADDITIONS_TL set
1810: X_Asset_Id IN NUMBER,
1811: X_Owner IN VARCHAR2,
1812: X_Last_Update_Date IN DATE,
1813: X_Description IN VARCHAR2,
1814: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
1815:
1816: user_id number;
1817:
1818: db_last_updated_by number;
1936: x_gf_attribute18 IN VARCHAR2,
1937: x_gf_attribute19 IN VARCHAR2,
1938: x_gf_attribute20 IN VARCHAR2,
1939: x_gf_attribute_category IN VARCHAR2
1940: ,p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
1941:
1942: BEGIN
1943:
1944: if (x_upload_mode = 'NLS') then