APPS.CSI_T_TXN_SYSTEMS_PKG dependencies on CSI_T_TXN_SYSTEMS

Line 1: PACKAGE BODY CSI_T_TXN_SYSTEMS_PKG AS

1: PACKAGE BODY CSI_T_TXN_SYSTEMS_PKG AS
2: /* $Header: csittsyb.pls 115.2 2002/11/12 00:26:21 rmamidip noship $ */
3: -- Start of Comments
4: -- Package name : CSI_T_TXN_SYSTEMS_PKG
5: -- Purpose :

Line 4: -- Package name : CSI_T_TXN_SYSTEMS_PKG

1: PACKAGE BODY CSI_T_TXN_SYSTEMS_PKG AS
2: /* $Header: csittsyb.pls 115.2 2002/11/12 00:26:21 rmamidip noship $ */
3: -- Start of Comments
4: -- Package name : CSI_T_TXN_SYSTEMS_PKG
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- END of Comments

Line 11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSI_T_TXN_SYSTEMS_PKG';

7: -- NOTE :
8: -- END of Comments
9:
10:
11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSI_T_TXN_SYSTEMS_PKG';
12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csittsyb.pls';
13:
14: PROCEDURE Insert_Row(
15: px_transaction_system_id IN OUT NOCOPY NUMBER,

Line 57: CURSOR c2 IS SELECT csi_t_txn_systems_s.nextval FROM sys.dual;

53: p_last_update_login NUMBER,
54: p_object_version_number NUMBER)
55:
56: IS
57: CURSOR c2 IS SELECT csi_t_txn_systems_s.nextval FROM sys.dual;
58: BEGIN
59: IF (px_transaction_system_id IS NULL) OR (px_transaction_system_id = fnd_api.g_miss_num) THEN
60: OPEN c2;
61: FETCH c2 INTO px_transaction_system_id;

Line 64: INSERT INTO csi_t_txn_systems(

60: OPEN c2;
61: FETCH c2 INTO px_transaction_system_id;
62: CLOSE c2;
63: END IF;
64: INSERT INTO csi_t_txn_systems(
65: transaction_system_id,
66: transaction_line_id,
67: system_name,
68: description,

Line 192: UPDATE csi_t_txn_systems

188: p_object_version_number NUMBER)
189:
190: IS
191: BEGIN
192: UPDATE csi_t_txn_systems
193: SET
194: transaction_line_id = DECODE( p_transaction_line_id, fnd_api.g_miss_num, transaction_line_id, p_transaction_line_id),
195: system_name = DECODE( p_system_name, fnd_api.g_miss_char, system_name, p_system_name),
196: description = DECODE( p_description, fnd_api.g_miss_char, description, p_description),

Line 244: DELETE FROM csi_t_txn_systems

240: PROCEDURE Delete_Row(
241: p_TRANSACTION_SYSTEM_ID NUMBER)
242: IS
243: BEGIN
244: DELETE FROM csi_t_txn_systems
245: WHERE transaction_system_id = p_transaction_system_id;
246: IF (SQL%NOTFOUND) THEN
247: RAISE no_data_found;
248: END IF;

Line 296: FROM csi_t_txn_systems

292:
293: IS
294: CURSOR c IS
295: SELECT *
296: FROM csi_t_txn_systems
297: WHERE transaction_system_id = p_transaction_system_id
298: FOR UPDATE of transaction_system_id NOWAIT;
299: recinfo c%ROWTYPE;
300: BEGIN

Line 430: END CSI_T_TXN_SYSTEMS_PKG;

426: app_exception.raise_exception;
427: END IF;
428: END Lock_Row;
429:
430: END CSI_T_TXN_SYSTEMS_PKG;