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_PARTY_RELATIONSHIPS_PVT dependencies on CSI_ITEM_INSTANCES

Line 1649: -- Verify if the instance_id exists in csi_item_instances

1645: RAISE FND_API.G_EXC_ERROR;
1646: END IF;
1647: END IF;
1648:
1649: -- Verify if the instance_id exists in csi_item_instances
1650: IF p_called_from_grp <> FND_API.G_TRUE THEN
1651: IF NOT(CSI_Instance_parties_vld_pvt.Is_InstanceID_Valid(p_party_rec.INSTANCE_ID)) THEN
1652: RAISE FND_API.G_EXC_ERROR;
1653: END IF;

Line 2010: -- If it is an owner party then update csi_item_instances

2006: END IF;
2007: END IF;
2008: --
2009: IF p_called_from_grp <> fnd_api.g_true THEN
2010: -- If it is an owner party then update csi_item_instances
2011: IF p_party_rec.RELATIONSHIP_TYPE_CODE = 'OWNER' THEN
2012: update csi_item_instances
2013: set owner_party_source_table = p_party_rec.party_source_table,
2014: owner_party_id = p_party_rec.party_id

Line 2012: update csi_item_instances

2008: --
2009: IF p_called_from_grp <> fnd_api.g_true THEN
2010: -- If it is an owner party then update csi_item_instances
2011: IF p_party_rec.RELATIONSHIP_TYPE_CODE = 'OWNER' THEN
2012: update csi_item_instances
2013: set owner_party_source_table = p_party_rec.party_source_table,
2014: owner_party_id = p_party_rec.party_id
2015: where instance_id = p_party_rec.instance_id;
2016:

Line 2490: FROM csi_item_instances

2486: NULL AREA_ID,
2487: NULL OWNER_PARTY_ID,
2488: NULL SOURCE_CODE, -- Bug 6407307, added Code for Siebel Genesis Project
2489: NULL REC_INDEX
2490: FROM csi_item_instances
2491: WHERE instance_id = p_instance_id;
2492:
2493: l_curr_instance_rec csi_datastructures_pub.instance_rec;
2494:

Line 2618: -- Verify if the instance_id exists in csi_item_instances

2614: END IF;
2615: --
2616: -- Check if the instance party id is valid
2617: -- End commentation by sk for bug 2232880
2618: -- Verify if the instance_id exists in csi_item_instances
2619: IF p_party_rec.INSTANCE_ID <> FND_API.G_MISS_NUM THEN
2620: --Added query for bug 7517240
2621: IF p_party_rec.ACTIVE_END_DATE IS NOT NULL AND p_party_rec.ACTIVE_END_DATE < SYSDATE THEN
2622: BEGIN

Line 2625: FROM CSI_ITEM_INSTANCES_H

2621: IF p_party_rec.ACTIVE_END_DATE IS NOT NULL AND p_party_rec.ACTIVE_END_DATE < SYSDATE THEN
2622: BEGIN
2623: SELECT 'T'
2624: INTO l_inst_just_expired
2625: FROM CSI_ITEM_INSTANCES_H
2626: WHERE INSTANCE_ID = p_party_rec.INSTANCE_ID
2627: AND TRANSACTION_ID = p_txn_rec.TRANSACTION_ID
2628: AND OLD_ACTIVE_END_DATE IS NULL
2629: AND NEW_ACTIVE_END_DATE < SYSDATE

Line 3081: update csi_item_instances

3077: END IF;
3078: --
3079: IF p_party_rec.relationship_type_code <> FND_API.G_MISS_CHAR THEN
3080: IF (p_party_rec.relationship_type_code = 'OWNER' ) THEN
3081: update csi_item_instances
3082: set owner_party_source_table = l_alt_pk_pty_source_tab, --p_party_rec.party_source_table,--bug 2769176
3083: owner_party_id = l_alt_pk_party_id, --p_party_rec.party_id, --bug 2769176
3084: last_update_date = sysdate,
3085: last_updated_by = fnd_global.user_id

Line 4197: -- Update accounting class code in csi_item_instances table

4193:
4194: END;
4195: -- End of Changes for Bug#2547034 on 09/20/02 - rtalluri
4196:
4197: -- Update accounting class code in csi_item_instances table
4198:
4199: csi_item_instance_pvt.get_and_update_acct_class
4200: ( p_api_version => p_api_version
4201: ,p_commit => p_commit

Line 4587: FROM csi_item_instances

4583: l_valid_flag VARCHAR2(1);
4584:
4585: CURSOR instance_csr (p_ins_id IN NUMBER) IS
4586: SELECT *
4587: FROM csi_item_instances
4588: WHERE instance_id = p_ins_id;
4589: l_instance_csr instance_csr%ROWTYPE;
4590: l_last_vld_org NUMBER; -- Added by sguthiva for bug 2307804
4591: BEGIN

Line 5061: -- If it is an owner party and owner account then update csi_item_instances

5057: l_party_rec)) THEN
5058: RAISE FND_API.G_EXC_ERROR;
5059: END IF;
5060:
5061: -- If it is an owner party and owner account then update csi_item_instances
5062: -- Account Rules check ensures that if the owner account is
5063: -- being created, the parent party is always a owner party
5064: IF ((p_party_account_rec.RELATIONSHIP_TYPE_CODE = 'OWNER')
5065: AND (l_party_rec.RELATIONSHIP_TYPE_CODE = 'OWNER')) THEN

Line 5067: update csi_item_instances

5063: -- being created, the parent party is always a owner party
5064: IF ((p_party_account_rec.RELATIONSHIP_TYPE_CODE = 'OWNER')
5065: AND (l_party_rec.RELATIONSHIP_TYPE_CODE = 'OWNER')) THEN
5066:
5067: update csi_item_instances
5068: set owner_party_account_id = p_party_account_rec.party_account_id
5069: where instance_id = l_party_rec.instance_id;
5070: END IF;
5071:

Line 5216: FROM csi_item_instances

5212: THEN
5213: BEGIN
5214: SELECT last_vld_organization_id
5215: INTO l_last_vld_org
5216: FROM csi_item_instances
5217: WHERE instance_id = l_party_rec.instance_id;
5218: EXCEPTION
5219: WHEN OTHERS THEN
5220: NULL;

Line 5357: FROM csi_item_instances

5353: l_old_party_id NUMBER;
5354: l_new_party_id NUMBER;
5355: CURSOR instance_csr (p_ins_id IN NUMBER) IS
5356: SELECT *
5357: FROM csi_item_instances
5358: WHERE instance_id = p_ins_id;
5359: l_instance_csr instance_csr%ROWTYPE;
5360:
5361: CURSOR get_curr_party_acct_rec (p_ip_account_id IN NUMBER) IS

Line 5864: -- If it is an owner party and owner account then update csi_item_instances

5860: l_party_rec)) THEN
5861: RAISE FND_API.G_EXC_ERROR;
5862: END IF;
5863:
5864: -- If it is an owner party and owner account then update csi_item_instances
5865: IF p_party_account_rec.relationship_type_code <> FND_API.G_MISS_CHAR THEN
5866: IF ((p_party_account_rec.relationship_type_code = 'OWNER')
5867: AND (l_party_relation = 'OWNER')) THEN
5868: -- Added by sguthiva for bug 2307804

Line 5872: update csi_item_instances

5868: -- Added by sguthiva for bug 2307804
5869: IF p_party_account_rec.party_account_id <> fnd_api.g_miss_num
5870: AND p_party_account_rec.party_account_id IS NOT NULL
5871: THEN
5872: update csi_item_instances
5873: set owner_party_account_id = p_party_account_rec.party_account_id
5874: where instance_id = l_party_rec.instance_id;
5875: END IF;
5876: END IF;

Line 6907: FROM csi_item_instances

6903: THEN
6904: BEGIN
6905: SELECT last_vld_organization_id
6906: INTO l_last_vld_org
6907: FROM csi_item_instances
6908: WHERE instance_id = l_party_rec.instance_id;
6909: EXCEPTION
6910: WHEN OTHERS THEN
6911: NULL;

Line 6989: UPDATE csi_item_instances

6985:
6986: l_old_pty_acct_id := NULL;
6987: l_new_pty_acct_id := NULL;
6988:
6989: UPDATE csi_item_instances
6990: SET owner_party_account_id = NULL
6991: WHERE instance_id = l_party_rec.instance_id;
6992: END IF;
6993: --