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) 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) 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 46: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS

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

Line 82: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS

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

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

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