APPS.GMS_TRANSACTIONS_PUB dependencies on GMS_TRANSACTION_INTERFACE_ALL

Line 66: -- Common Table handler for Table GMS_transaction Interface all

62: End AWARD_REQUIRED;
63: -- ============= END of AWARD_REQUIRED ===================
64:
65: -- -------------------------------------------------------------
66: -- Common Table handler for Table GMS_transaction Interface all
67: -- -------------------------------------------------------------
68:
69: PROCEDURE LOAD_GMS_XFACE_API ( p_rec gms_transaction_interface_all%ROWTYPE,
70: p_outcome OUT NOCOPY varchar2 ) is

Line 69: PROCEDURE LOAD_GMS_XFACE_API ( p_rec gms_transaction_interface_all%ROWTYPE,

65: -- -------------------------------------------------------------
66: -- Common Table handler for Table GMS_transaction Interface all
67: -- -------------------------------------------------------------
68:
69: PROCEDURE LOAD_GMS_XFACE_API ( p_rec gms_transaction_interface_all%ROWTYPE,
70: p_outcome OUT NOCOPY varchar2 ) is
71: x_rec gms_transaction_interface_all%ROWTYPE ;
72: p_err_code NUMBER ;
73: p_err_buf varchar2(2000) ;

Line 71: x_rec gms_transaction_interface_all%ROWTYPE ;

67: -- -------------------------------------------------------------
68:
69: PROCEDURE LOAD_GMS_XFACE_API ( p_rec gms_transaction_interface_all%ROWTYPE,
70: p_outcome OUT NOCOPY varchar2 ) is
71: x_rec gms_transaction_interface_all%ROWTYPE ;
72: p_err_code NUMBER ;
73: p_err_buf varchar2(2000) ;
74:
75: BEGIN

Line 98: insert into gms_transaction_interface_all (

94:
95: -- Bug 3465939 :Modified code to insert original_encumbrance_item_id
96: -- passed by Oracle Labor distribution system/External system.
97:
98: insert into gms_transaction_interface_all (
99: TXN_INTERFACE_ID,
100: BATCH_NAME,
101: TRANSACTION_SOURCE,
102: EXPENDITURE_ENDING_DATE,

Line 160: PROCEDURE UPDATE_GMS_XFACE_API ( p_rec gms_transaction_interface_all%ROWTYPE

156: ) ;
157: p_outcome := 'GMS_UNEXPECTED_ERROR';
158: END LOAD_GMS_XFACE_API ;
159:
160: PROCEDURE UPDATE_GMS_XFACE_API ( p_rec gms_transaction_interface_all%ROWTYPE
161: , p_outcome OUT NOCOPY varchar2 ) is
162: x_rec gms_transaction_interface_all%ROWTYPE ;
163: p_err_code NUMBER ;
164: p_err_buf varchar2(2000) ;

Line 162: x_rec gms_transaction_interface_all%ROWTYPE ;

158: END LOAD_GMS_XFACE_API ;
159:
160: PROCEDURE UPDATE_GMS_XFACE_API ( p_rec gms_transaction_interface_all%ROWTYPE
161: , p_outcome OUT NOCOPY varchar2 ) is
162: x_rec gms_transaction_interface_all%ROWTYPE ;
163: p_err_code NUMBER ;
164: p_err_buf varchar2(2000) ;
165: BEGIN
166: x_rec := p_rec ;

Line 187: UPDATE gms_transaction_interface_all

183:
184: -- Bug 3465939 :Modified code to update original_encumbrance_item_id
185: -- passed by Oracle Labor distribution system/External system.
186:
187: UPDATE gms_transaction_interface_all
188: SET BATCH_NAME = x_rec.BATCH_NAME,
189: TRANSACTION_SOURCE = x_rec.TRANSACTION_SOURCE,
190: EXPENDITURE_ENDING_DATE = x_rec.EXPENDITURE_ENDING_DATE,
191: EXPENDITURE_ITEM_DATE = x_rec.EXPENDITURE_ITEM_DATE,

Line 224: PROCEDURE DELETE_GMS_XFACE_API ( p_rec gms_transaction_interface_all%ROWTYPE

220: p_outcome := 'GMS_UNEXPECTED_ERROR';
221: END UPDATE_GMS_XFACE_API ;
222:
223:
224: PROCEDURE DELETE_GMS_XFACE_API ( p_rec gms_transaction_interface_all%ROWTYPE
225: , p_outcome OUT NOCOPY varchar2 ) is
226: x_rec gms_transaction_interface_all%ROWTYPE ;
227: p_err_code NUMBER ;
228: p_err_buf varchar2(2000) ;

Line 226: x_rec gms_transaction_interface_all%ROWTYPE ;

222:
223:
224: PROCEDURE DELETE_GMS_XFACE_API ( p_rec gms_transaction_interface_all%ROWTYPE
225: , p_outcome OUT NOCOPY varchar2 ) is
226: x_rec gms_transaction_interface_all%ROWTYPE ;
227: p_err_code NUMBER ;
228: p_err_buf varchar2(2000) ;
229: BEGIN
230: x_rec := p_rec ;

Line 232: delete from gms_transaction_interface_all

228: p_err_buf varchar2(2000) ;
229: BEGIN
230: x_rec := p_rec ;
231:
232: delete from gms_transaction_interface_all
233: WHERE TXN_INTERFACE_ID = x_rec.TXN_INTERFACE_ID ;
234:
235: EXCEPTION
236: When others then