eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSI_TRANSACTIONS_PVT dependencies on CSI_TRANSACTIONS

Line 1: PACKAGE BODY csi_transactions_pvt AS

1: PACKAGE BODY csi_transactions_pvt AS
2: /* $Header: csivtrxb.pls 120.3 2005/12/15 13:41:57 brmanesh noship $ */
3: -- start of comments
4: -- PACKAGE name : csi_transactions_pvt
5: -- purpose :

Line 4: -- PACKAGE name : csi_transactions_pvt

1: PACKAGE BODY csi_transactions_pvt AS
2: /* $Header: csivtrxb.pls 120.3 2005/12/15 13:41:57 brmanesh noship $ */
3: -- start of comments
4: -- PACKAGE name : csi_transactions_pvt
5: -- purpose :
6: -- history :
7: -- note :
8: -- END of comments

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

7: -- note :
8: -- END of comments
9:
10:
11: g_pkg_name CONSTANT VARCHAR2(30):= 'csi_transactions_pvt';
12: g_file_name CONSTANT VARCHAR2(12) := 'csivtrxb.pls';
13:
14: /* ---------------------------------------------------------------------------------- */
15: /* --- This local procedure is used to validate --- */

Line 75: -- get all column values for csi_transactions table

71: x_txnfind_rec OUT NOCOPY csi_datastructures_pub.transaction_header_rec
72: )
73: IS
74: BEGIN
75: -- get all column values for csi_transactions table
76: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 1, x_txnfind_rec.transaction_id);
77: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 2, x_txnfind_rec.transaction_date);
78: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 3, x_txnfind_rec.source_transaction_date);
79: DBMS_SQL.COLUMN_VALUE(p_cur_get_transactions, 4, x_txnfind_rec.transaction_type_id);

Line 238: /* --- else from csi_transactions --- */

234: END bind;
235:
236: /* ---------------------------------------------------------------------------------- */
237: /* --- When instance_id is passed then select from csi_inst_trx_details_v --- */
238: /* --- else from csi_transactions --- */
239: /* ---------------------------------------------------------------------------------- */
240:
241: PROCEDURE gen_select(
242: p_txnfind_rec IN csi_datastructures_pub.transaction_query_rec,

Line 251: l_table_name:='csi_transactions';

247: BEGIN
248: IF ( (p_txnfind_rec.instance_id IS NOT NULL) AND (p_txnfind_rec.instance_id <> fnd_api.g_miss_num) ) THEN
249: l_table_name:='csi_inst_trx_details_v';
250: ELSE
251: l_table_name:='csi_transactions';
252: END IF;
253:
254: x_select_cl := 'SELECT transaction_id,transaction_date, source_transaction_date, '||
255: 'transaction_type_id, source_group_ref_id, source_group_ref, source_header_ref_id, '||

Line 1060: FROM csi_transactions

1056:
1057: BEGIN
1058: SELECT 'x'
1059: INTO l_dummy
1060: FROM csi_transactions
1061: WHERE transaction_id=p_transaction_rec.transaction_id
1062: AND rownum=1;
1063: IF SQL%FOUND THEN
1064: x_return_status := fnd_api.g_ret_sts_success;

Line 1099: FROM csi_transactions

1095: (p_transaction_rec.transaction_id <> fnd_api.g_miss_num)) THEN
1096: BEGIN
1097: SELECT 'x'
1098: INTO l_dummy
1099: FROM csi_transactions
1100: WHERE transaction_id=p_transaction_rec.transaction_id
1101: AND rownum=1;
1102:
1103: IF SQL%FOUND THEN

Line 1167: -- invoke table handler(csi_transactions_pkg.insert_row)

1163: END IF;
1164: END IF;
1165:
1166: --x_transaction_id:=p_transaction_rec.transaction_id;
1167: -- invoke table handler(csi_transactions_pkg.insert_row)
1168: IF l_create_flag ='Y' THEN
1169: p_transaction_rec.object_version_number:=1;
1170: csi_transactions_pkg.insert_row(
1171: px_transaction_id => p_transaction_rec.transaction_id,

Line 1170: csi_transactions_pkg.insert_row(

1166: --x_transaction_id:=p_transaction_rec.transaction_id;
1167: -- invoke table handler(csi_transactions_pkg.insert_row)
1168: IF l_create_flag ='Y' THEN
1169: p_transaction_rec.object_version_number:=1;
1170: csi_transactions_pkg.insert_row(
1171: px_transaction_id => p_transaction_rec.transaction_id,
1172: p_transaction_date => l_transaction_date,
1173: p_source_transaction_date => p_transaction_rec.source_transaction_date,
1174: p_transaction_type_id => p_transaction_rec.transaction_type_id,

Line 1304: FROM csi_transactions

1300:
1301: IS
1302: CURSOR lock_csr (p_transaction_rec IN csi_datastructures_pub.transaction_rec) IS
1303: SELECT object_version_number
1304: FROM csi_transactions
1305: WHERE transaction_id = p_transaction_rec.transaction_id
1306: FOR UPDATE OF object_version_number;
1307:
1308:

Line 1414: -- invoke table handler(csi_transactions_pkg.update_row)

1410: FND_MSG_PUB.Add;
1411: RAISE fnd_api.g_exc_error;
1412: END IF;
1413:
1414: -- invoke table handler(csi_transactions_pkg.update_row)
1415: csi_transactions_pkg.update_row(
1416: p_transaction_id => p_transaction_rec.transaction_id,
1417: p_transaction_status_code => p_transaction_rec.transaction_status_code,
1418: p_transaction_action_code => p_transaction_rec.transaction_action_code,

Line 1415: csi_transactions_pkg.update_row(

1411: RAISE fnd_api.g_exc_error;
1412: END IF;
1413:
1414: -- invoke table handler(csi_transactions_pkg.update_row)
1415: csi_transactions_pkg.update_row(
1416: p_transaction_id => p_transaction_rec.transaction_id,
1417: p_transaction_status_code => p_transaction_rec.transaction_status_code,
1418: p_transaction_action_code => p_transaction_rec.transaction_action_code,
1419: p_source_group_ref => p_transaction_rec.source_group_ref,

Line 1667: /* --- csi_transactions table --- */

1663: /* ---------------------------------------------------------------------------------- */
1664: /* --- This procedure is used to validate transaction_id --- */
1665: /* --- 1. for validation_mode='CREATE' return success or no validation --- */
1666: /* --- 2. for validation_mode='UPDATE' check for not null and validate against --- */
1667: /* --- csi_transactions table --- */
1668: /* ---------------------------------------------------------------------------------- */
1669:
1670:
1671: PROCEDURE validate_transaction_id (

Line 1705: FROM csi_transactions

1701: ELSE
1702: BEGIN
1703: SELECT 'x'
1704: INTO l_dummy
1705: FROM csi_transactions
1706: WHERE transaction_id=p_transaction_id;
1707: EXCEPTION
1708: WHEN no_data_found THEN
1709: fnd_message.set_name('CSI', 'CSI_INVALID_TXN_ID');

Line 1940: /* --- csi_transactions table --- */

1936: /* ---------------------------------------------------------------------------------- */
1937: /* --- this procedure is used to validate transaction_id --- */
1938: /* --- 1. for validation_mode='CREATE' return success or no validation --- */
1939: /* --- 2. for validation_mode='UPDATE' check for not null and validate against --- */
1940: /* --- csi_transactions table --- */
1941: /* ---------------------------------------------------------------------------------- */
1942:
1943:
1944: PROCEDURE validate_object_version_num (

Line 2113: END csi_transactions_pvt;

2109: END IF;
2110:
2111: END validate_transactions;
2112:
2113: END csi_transactions_pvt;