DBA Data[Home] [Help]

APPS.CSI_ITEM_INSTANCE_PVT dependencies on CSI_TRANSACTIONS

Line 6330: CSI_TRANSACTIONS_PVT.Create_transaction

6326: END IF;
6327: END IF;
6328: -- End code addition for eam integration
6329: -- Call create_transaction to create txn log
6330: CSI_TRANSACTIONS_PVT.Create_transaction
6331: (
6332: p_api_version => p_api_version
6333: ,p_commit => p_commit
6334: ,p_init_msg_list => p_init_msg_list

Line 10985: SELECT 'X' FROM CSI_TRANSACTIONS CST,

10981: WHERE instance_id = p_ins_id;
10982:
10983: --Start of: Added for bug 5615162
10984: CURSOR instance_txn_chk_csr(p_ins_id IN NUMBER,p_txn_id in NUMBER, p_src_txn_date in DATE) IS
10985: SELECT 'X' FROM CSI_TRANSACTIONS CST,
10986: (
10987: SELECT CIIH.TRANSACTION_ID TRANSACTION_ID, CIIH.INSTANCE_ID INSTANCE_ID
10988: FROM CSI_ITEM_INSTANCES_H CIIH
10989: WHERE INSTANCE_ID=p_ins_id AND TRANSACTION_ID<>p_txn_id

Line 11134: csi_transactions ct

11130: csi_gen_utility_pvt.put_line('l_exists : '||l_exists);
11131: SELECT 'Y'
11132: INTO l_exists
11133: FROM oe_order_lines_all ool,
11134: csi_transactions ct
11135: WHERE ool.line_id = l_instance_csr.last_oe_rma_line_id
11136: AND ct.transaction_id = p_transaction_id
11137: AND ool.header_id = ct.source_header_ref_id
11138: AND ROWNUM = 1;

Line 11619: FROM csi_transactions

11615: x_return_status := fnd_api.g_ret_sts_success;
11616:
11617: SELECT object_version_number
11618: INTO px_txn_rec.object_version_number
11619: FROM csi_transactions
11620: WHERE transaction_id = px_txn_rec.transaction_id;
11621:
11622: csi_transactions_pvt.update_transactions(
11623: p_api_version => 1.0,

Line 11622: csi_transactions_pvt.update_transactions(

11618: INTO px_txn_rec.object_version_number
11619: FROM csi_transactions
11620: WHERE transaction_id = px_txn_rec.transaction_id;
11621:
11622: csi_transactions_pvt.update_transactions(
11623: p_api_version => 1.0,
11624: p_init_msg_list => fnd_api.g_true,
11625: p_commit => fnd_api.g_false,
11626: p_validation_level => fnd_api.g_valid_level_full,

Line 15075: CSI_TRANSACTIONS_PVT.Create_transaction

15071: -- Ends here
15072:
15073:
15074: -- calling the transaction api
15075: CSI_TRANSACTIONS_PVT.Create_transaction
15076: (
15077: p_api_version => p_api_version
15078: ,p_commit => p_commit
15079: ,p_init_msg_list => p_init_msg_list

Line 19813: CSI_TRANSACTIONS_PVT.Create_transaction

19809: -- End addition of columns for FA Integration
19810: p_SOURCE_CODE => FND_API.G_MISS_CHAR -- Added Code for Siebel Genesis Project
19811: );
19812:
19813: CSI_TRANSACTIONS_PVT.Create_transaction
19814: (
19815: p_api_version => p_api_version
19816: ,p_commit => p_commit
19817: ,p_init_msg_list => p_init_msg_list

Line 21104: CSI_TRANSACTIONS_PVT.Create_transaction

21100: -- calling the transaction api
21101: --IF CSI_Item_Instance_vld_pvt.Is_Inst_creation_complete( l_instance_rec.INSTANCE_ID ) THEN
21102:
21103: -- Call create_transaction to create txn log
21104: CSI_TRANSACTIONS_PVT.Create_transaction
21105: (
21106: p_api_version => p_api_version
21107: ,p_commit => p_commit
21108: ,p_init_msg_list => p_init_msg_list

Line 22383: UPDATE CSI_TRANSACTIONS

22379: l_batch_id := NULL;
22380: l_batch_type := NULL;
22381: END IF;
22382: --
22383: UPDATE CSI_TRANSACTIONS
22384: set contracts_invoked = 'Y'
22385: where transaction_id = p_txn_rec.transaction_id;
22386: --
22387: OKS_IBINT_PUB.IB_interface

Line 22827: UPDATE CSI_TRANSACTIONS

22823: l_batch_id := NULL;
22824: l_batch_type := NULL;
22825: END IF;
22826: --
22827: UPDATE CSI_TRANSACTIONS
22828: set contracts_invoked = 'Y'
22829: where transaction_id = p_txn_rec.transaction_id;
22830: --
22831: OKS_IBINT_PUB.IB_interface

Line 23759: CSI_TRANSACTIONS_PVT.Create_transaction

23755: p_OBJECT_VERSION_NUMBER => 1 );
23756:
23757:
23758: -- Call create_transaction to create txn log
23759: CSI_TRANSACTIONS_PVT.Create_transaction
23760: (
23761: p_api_version => p_api_version
23762: ,p_commit => p_commit
23763: ,p_init_msg_list => p_init_msg_list

Line 24086: CSI_TRANSACTIONS_PVT.Create_transaction

24082:
24083: -- Call create_transaction to create txn log
24084: IF p_call_transaction=fnd_api.g_true
24085: THEN
24086: CSI_TRANSACTIONS_PVT.Create_transaction
24087: (
24088: p_api_version => p_api_version
24089: ,p_commit => p_commit
24090: ,p_init_msg_list => p_init_msg_list

Line 25202: CSI_TRANSACTIONS_PVT.Create_transaction

25198: p_OBJECT_VERSION_NUMBER => l_OBJECT_VERSION_NUMBER );
25199:
25200:
25201: -- Call create_transaction to create txn log
25202: CSI_TRANSACTIONS_PVT.Create_transaction
25203: (
25204: p_api_version => p_api_version
25205: ,p_commit => p_commit
25206: ,p_init_msg_list => p_init_msg_list

Line 26410: CSI_TRANSACTIONS_PVT.Create_transaction

26406:
26407: -- IF CSI_Instance_parties_vld_pvt.Is_Instance_creation_complete( p_ext_attrib_rec.INSTANCE_ID ) THEN
26408: -- Call create_transaction to create txn log
26409:
26410: CSI_TRANSACTIONS_PVT.Create_transaction
26411: ( p_api_version => p_api_version
26412: ,p_commit => fnd_api.g_false
26413: ,p_init_msg_list => p_init_msg_list
26414: ,p_validation_level => p_validation_level

Line 26775: CSI_TRANSACTIONS_PVT.Create_transaction

26771:
26772: -- IF CSI_Instance_parties_vld_pvt.Is_Instance_creation_complete( p_ext_attrib_rec.INSTANCE_ID ) THEN
26773: -- Call create_transaction to create txn log
26774:
26775: CSI_TRANSACTIONS_PVT.Create_transaction
26776: ( p_api_version => p_api_version
26777: ,p_commit => fnd_api.g_false
26778: ,p_init_msg_list => p_init_msg_list
26779: ,p_validation_level => p_validation_level

Line 29683: UPDATE CSI_TRANSACTIONS

29679: l_batch_id := NULL;
29680: l_batch_type := NULL;
29681: END IF;
29682: --
29683: UPDATE CSI_TRANSACTIONS
29684: set contracts_invoked = 'Y'
29685: where transaction_id = p_txn_rec.transaction_id;
29686: --
29687: OKS_IBINT_PUB.IB_interface

Line 34504: UPDATE CSI_TRANSACTIONS

34500: l_batch_id := NULL;
34501: l_batch_type := NULL;
34502: END IF;
34503: --
34504: UPDATE CSI_TRANSACTIONS
34505: set contracts_invoked = 'Y'
34506: where transaction_id = p_txn_rec.transaction_id;
34507: --
34508: OKS_IBINT_PUB.IB_interface

Line 35956: CSI_TRANSACTIONS_PVT.Create_transaction

35952: );
35953: END IF;
35954: END LOOP;
35955: /*
35956: CSI_TRANSACTIONS_PVT.Create_transaction
35957: (
35958: p_api_version => p_api_version
35959: ,p_commit => p_commit
35960: ,p_init_msg_list => p_init_msg_list