DBA Data[Home] [Help]

APPS.FA_TRANSFER_DETAILS_PKG dependencies on FA_API_TYPES

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

5: X_Transfer_Header_Id NUMBER,
6: X_Distribution_Id NUMBER,
7: X_Book_Header_Id NUMBER,
8: X_Calling_Fn VARCHAR2,
9: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
10: CURSOR C IS SELECT rowid FROM fa_transfer_details
11: WHERE transfer_header_id = X_Transfer_Header_Id
12: AND distribution_id = X_Distribution_Id;
13: BEGIN

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

44: X_Transfer_Header_Id NUMBER,
45: X_Distribution_Id NUMBER,
46: X_Book_Header_Id NUMBER,
47: X_Calling_Fn VARCHAR2,
48: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
49: CURSOR C IS
50: SELECT transfer_header_id,
51: distribution_id,
52: book_header_id

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

78: X_Transfer_Header_Id NUMBER,
79: X_Distribution_Id NUMBER,
80: X_Book_Header_Id NUMBER,
81: X_Calling_Fn VARCHAR2,
82: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
83: BEGIN
84: UPDATE fa_transfer_details
85: SET
86: transfer_header_id = X_Transfer_Header_Id,

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

105:
106: PROCEDURE Delete_Row(X_Rowid VARCHAR2 DEFAULT NULL,
107: X_Transfer_Header_Id NUMBER DEFAULT NULL,
108: X_Calling_Fn VARCHAR2,
109: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
110: BEGIN
111: if X_Rowid is not null then
112: DELETE FROM fa_transfer_details
113: WHERE rowid = X_Rowid;