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 2489: FROM csi_item_instances

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

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

2611: END IF;
2612: --
2613: -- Check if the instance party id is valid
2614: -- End commentation by sk for bug 2232880
2615: -- Verify if the instance_id exists in csi_item_instances
2616: IF p_party_rec.INSTANCE_ID <> FND_API.G_MISS_NUM THEN
2617: IF NOT(CSI_Instance_parties_vld_pvt.Is_InstanceID_Valid(p_party_rec.INSTANCE_ID)) THEN
2618: RAISE FND_API.G_EXC_ERROR;
2619: END IF;

Line 3042: update csi_item_instances

3038: END IF;
3039: --
3040: IF p_party_rec.relationship_type_code <> FND_API.G_MISS_CHAR THEN
3041: IF (p_party_rec.relationship_type_code = 'OWNER' ) THEN
3042: update csi_item_instances
3043: set owner_party_source_table = l_alt_pk_pty_source_tab, --p_party_rec.party_source_table,--bug 2769176
3044: owner_party_id = l_alt_pk_party_id, --p_party_rec.party_id, --bug 2769176
3045: last_update_date = sysdate,
3046: last_updated_by = fnd_global.user_id

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

4154:
4155: END;
4156: -- End of Changes for Bug#2547034 on 09/20/02 - rtalluri
4157:
4158: -- Update accounting class code in csi_item_instances table
4159:
4160: csi_item_instance_pvt.get_and_update_acct_class
4161: ( p_api_version => p_api_version
4162: ,p_commit => p_commit

Line 4548: FROM csi_item_instances

4544: l_valid_flag VARCHAR2(1);
4545:
4546: CURSOR instance_csr (p_ins_id IN NUMBER) IS
4547: SELECT *
4548: FROM csi_item_instances
4549: WHERE instance_id = p_ins_id;
4550: l_instance_csr instance_csr%ROWTYPE;
4551: l_last_vld_org NUMBER; -- Added by sguthiva for bug 2307804
4552: BEGIN

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

5018: l_party_rec)) THEN
5019: RAISE FND_API.G_EXC_ERROR;
5020: END IF;
5021:
5022: -- If it is an owner party and owner account then update csi_item_instances
5023: -- Account Rules check ensures that if the owner account is
5024: -- being created, the parent party is always a owner party
5025: IF ((p_party_account_rec.RELATIONSHIP_TYPE_CODE = 'OWNER')
5026: AND (l_party_rec.RELATIONSHIP_TYPE_CODE = 'OWNER')) THEN

Line 5028: update csi_item_instances

5024: -- being created, the parent party is always a owner party
5025: IF ((p_party_account_rec.RELATIONSHIP_TYPE_CODE = 'OWNER')
5026: AND (l_party_rec.RELATIONSHIP_TYPE_CODE = 'OWNER')) THEN
5027:
5028: update csi_item_instances
5029: set owner_party_account_id = p_party_account_rec.party_account_id
5030: where instance_id = l_party_rec.instance_id;
5031: END IF;
5032:

Line 5177: FROM csi_item_instances

5173: THEN
5174: BEGIN
5175: SELECT last_vld_organization_id
5176: INTO l_last_vld_org
5177: FROM csi_item_instances
5178: WHERE instance_id = l_party_rec.instance_id;
5179: EXCEPTION
5180: WHEN OTHERS THEN
5181: NULL;

Line 5316: FROM csi_item_instances

5312: l_old_party_id NUMBER;
5313: l_new_party_id NUMBER;
5314: CURSOR instance_csr (p_ins_id IN NUMBER) IS
5315: SELECT *
5316: FROM csi_item_instances
5317: WHERE instance_id = p_ins_id;
5318: l_instance_csr instance_csr%ROWTYPE;
5319:
5320: CURSOR get_curr_party_acct_rec (p_ip_account_id IN NUMBER) IS

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

5819: l_party_rec)) THEN
5820: RAISE FND_API.G_EXC_ERROR;
5821: END IF;
5822:
5823: -- If it is an owner party and owner account then update csi_item_instances
5824: IF p_party_account_rec.relationship_type_code <> FND_API.G_MISS_CHAR THEN
5825: IF ((p_party_account_rec.relationship_type_code = 'OWNER')
5826: AND (l_party_relation = 'OWNER')) THEN
5827: -- Added by sguthiva for bug 2307804

Line 5831: update csi_item_instances

5827: -- Added by sguthiva for bug 2307804
5828: IF p_party_account_rec.party_account_id <> fnd_api.g_miss_num
5829: AND p_party_account_rec.party_account_id IS NOT NULL
5830: THEN
5831: update csi_item_instances
5832: set owner_party_account_id = p_party_account_rec.party_account_id
5833: where instance_id = l_party_rec.instance_id;
5834: END IF;
5835: END IF;

Line 6866: FROM csi_item_instances

6862: THEN
6863: BEGIN
6864: SELECT last_vld_organization_id
6865: INTO l_last_vld_org
6866: FROM csi_item_instances
6867: WHERE instance_id = l_party_rec.instance_id;
6868: EXCEPTION
6869: WHEN OTHERS THEN
6870: NULL;

Line 6941: UPDATE csi_item_instances

6937:
6938: l_old_pty_acct_id := NULL;
6939: l_new_pty_acct_id := NULL;
6940:
6941: UPDATE csi_item_instances
6942: SET owner_party_account_id = NULL
6943: WHERE instance_id = l_party_rec.instance_id;
6944: END IF;
6945: --