APPS.FA_TRANSFER_DETAILS_PKG dependencies on FA_TRANSFER_DETAILS

Line 1: PACKAGE BODY FA_TRANSFER_DETAILS_PKG as

1: PACKAGE BODY FA_TRANSFER_DETAILS_PKG as
2: /* $Header: faxitdb.pls 120.3 2005/07/25 10:00:44 yyoon ship $ */
3:
4: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
5: X_Transfer_Header_Id NUMBER,

Line 10: CURSOR C IS SELECT rowid FROM fa_transfer_details

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
14: INSERT INTO fa_transfer_details(

Line 14: INSERT INTO fa_transfer_details(

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
14: INSERT INTO fa_transfer_details(
15: transfer_header_id,
16: distribution_id,
17: book_header_id
18: ) VALUES (

Line 34: calling_fn => 'FA_TRANSFER_DETAILS_PKG.insert_row'

30: CLOSE C;
31: EXCEPTION
32: WHEN Others THEN
33: fa_srvr_msg.add_sql_error(
34: calling_fn => 'FA_TRANSFER_DETAILS_PKG.insert_row'
35: ,p_log_level_rec => p_log_level_rec);
36: raise;
37: /* FA_STANDARD_PKG.RAISE_ERROR
38: (Called_Fn => 'FA_TRANSFER_DETAILS_PKG.Insert_Row',

Line 38: (Called_Fn => 'FA_TRANSFER_DETAILS_PKG.Insert_Row',

34: calling_fn => 'FA_TRANSFER_DETAILS_PKG.insert_row'
35: ,p_log_level_rec => p_log_level_rec);
36: raise;
37: /* FA_STANDARD_PKG.RAISE_ERROR
38: (Called_Fn => 'FA_TRANSFER_DETAILS_PKG.Insert_Row',
39: Calling_Fn => X_Calling_Fn
40: ,p_log_level_rec => p_log_level_rec); */
41: END Insert_Row;
42:

Line 53: FROM fa_transfer_details

49: CURSOR C IS
50: SELECT transfer_header_id,
51: distribution_id,
52: book_header_id
53: FROM fa_transfer_details
54: WHERE rowid = X_Rowid
55: FOR UPDATE of Transfer_Header_Id NOWAIT;
56: Recinfo C%ROWTYPE;
57:

Line 84: UPDATE fa_transfer_details

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,
87: distribution_id = X_Distribution_Id,
88: book_header_id = X_Book_Header_Id

Line 97: calling_fn => 'FA_TRANSFER_DETAILS_PKG.update_row'

93: end if;
94: EXCEPTION
95: WHEN Others THEN
96: fa_srvr_msg.add_sql_error(
97: calling_fn => 'FA_TRANSFER_DETAILS_PKG.update_row'
98: ,p_log_level_rec => p_log_level_rec);
99: raise;
100: /* FA_STANDARD_PKG.RAISE_ERROR
101: (Called_Fn => 'FA_TRANSFER_DETAILS_PKG.Update_Row',

Line 101: (Called_Fn => 'FA_TRANSFER_DETAILS_PKG.Update_Row',

97: calling_fn => 'FA_TRANSFER_DETAILS_PKG.update_row'
98: ,p_log_level_rec => p_log_level_rec);
99: raise;
100: /* FA_STANDARD_PKG.RAISE_ERROR
101: (Called_Fn => 'FA_TRANSFER_DETAILS_PKG.Update_Row',
102: Calling_Fn => X_Calling_Fn
103: ,p_log_level_rec => p_log_level_rec); */
104: END Update_Row;
105:

Line 112: DELETE FROM fa_transfer_details

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;
114: elsif X_Transfer_Header_Id is not null then
115: DELETE FROM fa_transfer_details
116: WHERE transfer_header_id = X_Transfer_Header_Id;

Line 115: DELETE FROM fa_transfer_details

111: if X_Rowid is not null then
112: DELETE FROM fa_transfer_details
113: WHERE rowid = X_Rowid;
114: elsif X_Transfer_Header_Id is not null then
115: DELETE FROM fa_transfer_details
116: WHERE transfer_header_id = X_Transfer_Header_Id;
117: else
118: -- print some error message
119: null;

Line 127: calling_fn => 'FA_TRANSFER_DETAILS_PKG.delete_row'

123: end if;
124: EXCEPTION
125: WHEN Others THEN
126: fa_srvr_msg.add_sql_error(
127: calling_fn => 'FA_TRANSFER_DETAILS_PKG.delete_row'
128: ,p_log_level_rec => p_log_level_rec);
129: raise;
130: /* FA_STANDARD_PKG.RAISE_ERROR
131: (Called_Fn => 'FA_TRANSFER_DETAILS_PKG.Delete_Row',

Line 131: (Called_Fn => 'FA_TRANSFER_DETAILS_PKG.Delete_Row',

127: calling_fn => 'FA_TRANSFER_DETAILS_PKG.delete_row'
128: ,p_log_level_rec => p_log_level_rec);
129: raise;
130: /* FA_STANDARD_PKG.RAISE_ERROR
131: (Called_Fn => 'FA_TRANSFER_DETAILS_PKG.Delete_Row',
132: Calling_Fn => X_Calling_Fn
133: ,p_log_level_rec => p_log_level_rec); */
134: END Delete_Row;
135:

Line 137: END FA_TRANSFER_DETAILS_PKG;

133: ,p_log_level_rec => p_log_level_rec); */
134: END Delete_Row;
135:
136:
137: END FA_TRANSFER_DETAILS_PKG;