DBA Data[Home] [Help]

APPS.FA_ADDITIONS_PKG dependencies on FA_API_TYPES

Line 88: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS

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

Line 414: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS

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

Line 686: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS

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);

Line 1074: X_calling_Fn VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS

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);

Line 1110: X_Calling_Fn VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS

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

Line 1271: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS

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);

Line 1559: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS

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);

Line 1784: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS

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

Line 1814: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS

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;

Line 1940: ,p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS

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