APPS.CSI_T_TXN_SYSTEMS_PVT dependencies on CSI_T_TXN_SYSTEMS

Line 1: PACKAGE BODY csi_t_txn_systems_pvt AS

1: PACKAGE BODY csi_t_txn_systems_pvt AS
2: /* $Header: csivtsyb.pls 120.1 2006/02/09 14:54:24 shegde noship $ */
3: -- start of comments
4: -- package name : csi_t_txn_systems_pvt
5: -- purpose :

Line 4: -- package name : csi_t_txn_systems_pvt

1: PACKAGE BODY csi_t_txn_systems_pvt AS
2: /* $Header: csivtsyb.pls 120.1 2006/02/09 14:54:24 shegde noship $ */
3: -- start of comments
4: -- package name : csi_t_txn_systems_pvt
5: -- purpose :
6: -- history :
7: -- note :
8: -- END of comments

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

7: -- note :
8: -- END of comments
9:
10:
11: g_pkg_name CONSTANT VARCHAR2(30) := 'csi_t_txn_systems_pvt';
12: g_file_name CONSTANT VARCHAR2(12) := 'csivtsyb.pls';
13:
14: PROCEDURE dmsg (
15: p_msg IN VARCHAR2

Line 43: FROM csi_t_txn_systems txn, csi_systems_vl sys

39: x_msg_data OUT NOCOPY VARCHAR2) IS
40: /* split out and commented the 2 cursors for perf Bug 4907908
41: CURSOR dup_cur IS
42: SELECT 'x'
43: FROM csi_t_txn_systems txn, csi_systems_vl sys
44: WHERE txn.system_name = p_system_name
45: AND txn.customer_id = p_Customer_ID
46: AND (txn.system_number IS NULL OR
47: txn.system_number = p_System_number)

Line 55: FROM csi_t_txn_systems txn, csi_systems_vl sys

51: sys.system_number = p_System_number);
52:
53: CURSOR dup_cur1 IS
54: SELECT 'x'
55: FROM csi_t_txn_systems txn, csi_systems_vl sys
56: WHERE txn.system_name = p_system_name
57: AND txn.customer_id = p_Customer_ID
58: AND (txn.system_number IS NULL OR
59: txn.system_number = p_System_number)

Line 114: FROM csi_t_txn_systems txn

110: Begin
111: IF p_validation_level = fnd_api.g_valid_level_full THEN
112: SELECT 'Y'
113: INTO l_dummy
114: FROM csi_t_txn_systems txn
115: WHERE txn.system_name = p_system_name
116: AND txn.customer_id = p_Customer_ID
117: AND (txn.system_number IS NULL OR
118: txn.system_number = p_System_number);

Line 122: FROM csi_t_txn_systems txn

118: txn.system_number = p_System_number);
119: ELSE -- validation level <> full
120: SELECT 'Y'
121: INTO l_dummy
122: FROM csi_t_txn_systems txn
123: WHERE txn.system_name = p_system_name
124: AND txn.customer_id = p_Customer_ID
125: AND txn.transaction_line_id =p_txn_line_id
126: AND (txn.system_number IS NULL OR

Line 272: csi_t_txn_systems_pkg.insert_row(

268: END IF;
269:
270: IF x_return_status = fnd_api.g_ret_sts_success THEN
271:
272: csi_t_txn_systems_pkg.insert_row(
273: px_transaction_system_id => x_txn_system_id,
274: p_transaction_line_id => p_txn_system_rec.transaction_line_id,
275: p_system_name => p_txn_system_rec.system_name,
276: p_description => p_txn_system_rec.description,

Line 390: FROM csi_t_txn_systems

386: SELECT customer_id
387: ,object_version_number
388: ,start_date_active
389: ,end_date_active
390: FROM csi_t_txn_systems
391: WHERE transaction_system_id=sys_id
392: FOR UPDATE NOWAIT;
393:
394: l_api_name CONSTANT VARCHAR2(30) := 'update_txn_system';

Line 536: csi_t_txn_systems_pkg.update_row(

532:
533: IF x_return_status = fnd_api.g_ret_sts_success THEN
534:
535:
536: csi_t_txn_systems_pkg.update_row(
537: p_transaction_system_id => p_txn_system_rec.transaction_system_id,
538: p_transaction_line_id => p_txn_system_rec.transaction_line_id,
539: p_system_name => p_txn_system_rec.system_name,
540: p_description => p_txn_system_rec.description,

Line 693: csi_t_txn_systems_pkg.Delete_Row(p_txn_system_id );

689: RAISE fnd_api.g_exc_error;
690: END IF;
691:
692:
693: csi_t_txn_systems_pkg.Delete_Row(p_txn_system_id );
694:
695:
696: IF x_return_status <> fnd_api.g_ret_sts_success THEN
697: RAISE fnd_api.g_exc_error;

Line 762: FROM csi_t_txn_systems

758: IF ( (p_txn_system_id IS NOT NULL) AND (p_txn_system_id<>fnd_api.g_miss_num) ) THEN
759: BEGIN
760: SELECT 'x'
761: INTO l_dummy
762: FROM csi_t_txn_systems
763: WHERE transaction_system_id=p_txn_system_id;
764: EXCEPTION
765: WHEN no_data_found THEN
766: fnd_message.set_name('CSI', 'CSI_INVALID_TXN_SYSTEM_ID');

Line 778: FROM csi_t_txn_systems

774: IF ( (p_txn_system_id IS NOT NULL) AND (p_txn_system_id<>fnd_api.g_miss_num) ) THEN
775: BEGIN
776: SELECT 'x'
777: INTO l_dummy
778: FROM csi_t_txn_systems
779: WHERE transaction_system_id=p_txn_system_id;
780: EXCEPTION
781: WHEN no_data_found THEN
782: fnd_message.set_name('CSI', 'CSI_INVALID_TXN_SYSTEM_ID');

Line 1009: END csi_t_txn_systems_pvt;

1005:
1006: END IF;
1007: END validate_txn_systems;
1008:
1009: END csi_t_txn_systems_pvt;