APPS.CSI_TRANSACTIONS_PKG dependencies on CSI_TRANSACTIONS

Line 1: PACKAGE BODY csi_transactions_pkg AS

1: PACKAGE BODY csi_transactions_pkg AS
2: /* $Header: csittrxb.pls 120.1 2005/07/06 18:47:58 sguthiva noship $ */
3: -- start of comments
4: -- package name : csi_transactions_pkg
5: -- purpose :

Line 4: -- package name : csi_transactions_pkg

1: PACKAGE BODY csi_transactions_pkg AS
2: /* $Header: csittrxb.pls 120.1 2005/07/06 18:47:58 sguthiva noship $ */
3: -- start of comments
4: -- package name : csi_transactions_pkg
5: -- purpose :
6: -- history :
7: -- note :
8: -- end of comments

Line 11: g_pkg_name CONSTANT VARCHAR2(30):= 'csi_transactions_pkg';

7: -- note :
8: -- end of comments
9:
10:
11: g_pkg_name CONSTANT VARCHAR2(30):= 'csi_transactions_pkg';
12: g_file_name CONSTANT VARCHAR2(12) := 'csittrxb.pls';
13:
14: /* ---------------------------------------------------------------------------------- */
15: /* --- this PROCEDURE is used to insert the record INTO csi_transactions table. --- */

Line 15: /* --- this PROCEDURE is used to insert the record INTO csi_transactions table. --- */

11: g_pkg_name CONSTANT VARCHAR2(30):= 'csi_transactions_pkg';
12: g_file_name CONSTANT VARCHAR2(12) := 'csittrxb.pls';
13:
14: /* ---------------------------------------------------------------------------------- */
15: /* --- this PROCEDURE is used to insert the record INTO csi_transactions table. --- */
16: /* ---------------------------------------------------------------------------------- */
17:
18: PROCEDURE insert_row(
19: px_transaction_id IN OUT NOCOPY NUMBER ,

Line 65: CURSOR c2 IS SELECT csi_transactions_s.nextval FROM sys.dual;

61: p_split_reason_code VARCHAR2,
62: p_gl_interface_status_code NUMBER )
63:
64: IS
65: CURSOR c2 IS SELECT csi_transactions_s.nextval FROM sys.dual;
66: BEGIN
67: IF (px_transaction_id IS NULL) or (px_transaction_id = fnd_api.g_miss_num) THEN
68: OPEN c2;
69: FETCH c2 INTO px_transaction_id;

Line 74: insert INTO csi_transactions(

70: CLOSE c2;
71: END IF;
72:
73:
74: insert INTO csi_transactions(
75: transaction_id,
76: transaction_date,
77: source_transaction_date,
78: transaction_type_id,

Line 170: /* --- this procedure is used to update the record into csi_transactions table. --- */

166: -- commit;
167: end insert_row;
168:
169: /* ---------------------------------------------------------------------------------- */
170: /* --- this procedure is used to update the record into csi_transactions table. --- */
171: /* ---------------------------------------------------------------------------------- */
172:
173: PROCEDURE update_row(
174: p_transaction_id NUMBER := fnd_api.g_miss_num ,

Line 221: update csi_transactions

217: p_gl_interface_status_code NUMBER := fnd_api.g_miss_num
218: )
219: is
220: BEGIN
221: update csi_transactions
222: set
223: transaction_date = decode( p_transaction_date, fnd_api.g_miss_date, transaction_date, p_transaction_date),
224: source_transaction_date = decode( p_source_transaction_date, fnd_api.g_miss_date, source_transaction_date, p_source_transaction_date),
225: transaction_type_id = decode( p_transaction_type_id, fnd_api.g_miss_num, transaction_type_id, p_transaction_type_id),

Line 281: delete FROM csi_transactions

277: PROCEDURE delete_row(
278: p_transaction_id NUMBER)
279: is
280: BEGIN
281: delete FROM csi_transactions
282: WHERE transaction_id = p_transaction_id;
283: IF (SQL%NOTFOUND) THEN
284: raise no_data_found;
285: END IF;

Line 334: FROM csi_transactions

330:
331: is
332: CURSOR c is
333: SELECT *
334: FROM csi_transactions
335: WHERE transaction_id = p_transaction_id
336: for update of transaction_id nowait;
337: recinfo c%rowtype;
338: BEGIN

Line 477: END csi_transactions_pkg;

473: app_exception.raise_exception;
474: END IF;
475: end lock_row;
476: */
477: END csi_transactions_pkg;