DBA Data[Home] [Help]

APPS.CSI_ITEM_INSTANCE_PVT dependencies on CSI_TRANSACTIONS

Line 6257: CSI_TRANSACTIONS_PVT.Create_transaction

6253: END IF;
6254: END IF;
6255: -- End code addition for eam integration
6256: -- Call create_transaction to create txn log
6257: CSI_TRANSACTIONS_PVT.Create_transaction
6258: (
6259: p_api_version => p_api_version
6260: ,p_commit => p_commit
6261: ,p_init_msg_list => p_init_msg_list

Line 10734: SELECT 'X' FROM CSI_TRANSACTIONS CST,

10730: WHERE instance_id = p_ins_id;
10731:
10732: --Start of: Added for bug 5615162
10733: CURSOR instance_txn_chk_csr(p_ins_id IN NUMBER,p_txn_id in NUMBER, p_src_txn_date in DATE) IS
10734: SELECT 'X' FROM CSI_TRANSACTIONS CST,
10735: (
10736: SELECT CIIH.TRANSACTION_ID TRANSACTION_ID, CIIH.INSTANCE_ID INSTANCE_ID
10737: FROM CSI_ITEM_INSTANCES_H CIIH
10738: WHERE INSTANCE_ID=p_ins_id AND TRANSACTION_ID<>p_txn_id

Line 11328: FROM csi_transactions

11324: x_return_status := fnd_api.g_ret_sts_success;
11325:
11326: SELECT object_version_number
11327: INTO px_txn_rec.object_version_number
11328: FROM csi_transactions
11329: WHERE transaction_id = px_txn_rec.transaction_id;
11330:
11331: csi_transactions_pvt.update_transactions(
11332: p_api_version => 1.0,

Line 11331: csi_transactions_pvt.update_transactions(

11327: INTO px_txn_rec.object_version_number
11328: FROM csi_transactions
11329: WHERE transaction_id = px_txn_rec.transaction_id;
11330:
11331: csi_transactions_pvt.update_transactions(
11332: p_api_version => 1.0,
11333: p_init_msg_list => fnd_api.g_true,
11334: p_commit => fnd_api.g_false,
11335: p_validation_level => fnd_api.g_valid_level_full,

Line 14619: CSI_TRANSACTIONS_PVT.Create_transaction

14615: -- Ends here
14616:
14617:
14618: -- calling the transaction api
14619: CSI_TRANSACTIONS_PVT.Create_transaction
14620: (
14621: p_api_version => p_api_version
14622: ,p_commit => p_commit
14623: ,p_init_msg_list => p_init_msg_list

Line 19316: CSI_TRANSACTIONS_PVT.Create_transaction

19312: -- End addition of columns for FA Integration
19313: p_SOURCE_CODE => FND_API.G_MISS_CHAR -- Added Code for Siebel Genesis Project
19314: );
19315:
19316: CSI_TRANSACTIONS_PVT.Create_transaction
19317: (
19318: p_api_version => p_api_version
19319: ,p_commit => p_commit
19320: ,p_init_msg_list => p_init_msg_list

Line 20567: CSI_TRANSACTIONS_PVT.Create_transaction

20563: -- calling the transaction api
20564: --IF CSI_Item_Instance_vld_pvt.Is_Inst_creation_complete( l_instance_rec.INSTANCE_ID ) THEN
20565:
20566: -- Call create_transaction to create txn log
20567: CSI_TRANSACTIONS_PVT.Create_transaction
20568: (
20569: p_api_version => p_api_version
20570: ,p_commit => p_commit
20571: ,p_init_msg_list => p_init_msg_list

Line 21842: UPDATE CSI_TRANSACTIONS

21838: l_batch_id := NULL;
21839: l_batch_type := NULL;
21840: END IF;
21841: --
21842: UPDATE CSI_TRANSACTIONS
21843: set contracts_invoked = 'Y'
21844: where transaction_id = p_txn_rec.transaction_id;
21845: --
21846: OKS_IBINT_PUB.IB_interface

Line 22282: UPDATE CSI_TRANSACTIONS

22278: l_batch_id := NULL;
22279: l_batch_type := NULL;
22280: END IF;
22281: --
22282: UPDATE CSI_TRANSACTIONS
22283: set contracts_invoked = 'Y'
22284: where transaction_id = p_txn_rec.transaction_id;
22285: --
22286: OKS_IBINT_PUB.IB_interface

Line 23206: CSI_TRANSACTIONS_PVT.Create_transaction

23202: p_OBJECT_VERSION_NUMBER => 1 );
23203:
23204:
23205: -- Call create_transaction to create txn log
23206: CSI_TRANSACTIONS_PVT.Create_transaction
23207: (
23208: p_api_version => p_api_version
23209: ,p_commit => p_commit
23210: ,p_init_msg_list => p_init_msg_list

Line 23529: CSI_TRANSACTIONS_PVT.Create_transaction

23525:
23526: -- Call create_transaction to create txn log
23527: IF p_call_transaction=fnd_api.g_true
23528: THEN
23529: CSI_TRANSACTIONS_PVT.Create_transaction
23530: (
23531: p_api_version => p_api_version
23532: ,p_commit => p_commit
23533: ,p_init_msg_list => p_init_msg_list

Line 24641: CSI_TRANSACTIONS_PVT.Create_transaction

24637: p_OBJECT_VERSION_NUMBER => l_OBJECT_VERSION_NUMBER );
24638:
24639:
24640: -- Call create_transaction to create txn log
24641: CSI_TRANSACTIONS_PVT.Create_transaction
24642: (
24643: p_api_version => p_api_version
24644: ,p_commit => p_commit
24645: ,p_init_msg_list => p_init_msg_list

Line 25845: CSI_TRANSACTIONS_PVT.Create_transaction

25841:
25842: -- IF CSI_Instance_parties_vld_pvt.Is_Instance_creation_complete( p_ext_attrib_rec.INSTANCE_ID ) THEN
25843: -- Call create_transaction to create txn log
25844:
25845: CSI_TRANSACTIONS_PVT.Create_transaction
25846: ( p_api_version => p_api_version
25847: ,p_commit => fnd_api.g_false
25848: ,p_init_msg_list => p_init_msg_list
25849: ,p_validation_level => p_validation_level

Line 26206: CSI_TRANSACTIONS_PVT.Create_transaction

26202:
26203: -- IF CSI_Instance_parties_vld_pvt.Is_Instance_creation_complete( p_ext_attrib_rec.INSTANCE_ID ) THEN
26204: -- Call create_transaction to create txn log
26205:
26206: CSI_TRANSACTIONS_PVT.Create_transaction
26207: ( p_api_version => p_api_version
26208: ,p_commit => fnd_api.g_false
26209: ,p_init_msg_list => p_init_msg_list
26210: ,p_validation_level => p_validation_level

Line 29106: UPDATE CSI_TRANSACTIONS

29102: l_batch_id := NULL;
29103: l_batch_type := NULL;
29104: END IF;
29105: --
29106: UPDATE CSI_TRANSACTIONS
29107: set contracts_invoked = 'Y'
29108: where transaction_id = p_txn_rec.transaction_id;
29109: --
29110: OKS_IBINT_PUB.IB_interface

Line 33861: UPDATE CSI_TRANSACTIONS

33857: l_batch_id := NULL;
33858: l_batch_type := NULL;
33859: END IF;
33860: --
33861: UPDATE CSI_TRANSACTIONS
33862: set contracts_invoked = 'Y'
33863: where transaction_id = p_txn_rec.transaction_id;
33864: --
33865: OKS_IBINT_PUB.IB_interface

Line 35299: CSI_TRANSACTIONS_PVT.Create_transaction

35295: );
35296: END IF;
35297: END LOOP;
35298: /*
35299: CSI_TRANSACTIONS_PVT.Create_transaction
35300: (
35301: p_api_version => p_api_version
35302: ,p_commit => p_commit
35303: ,p_init_msg_list => p_init_msg_list