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_ITEM_INSTANCE_PVT dependencies on CSI_II_RELATIONSHIPS

Line 3260: ' UNION SELECT b.subject_id FROM csi_ii_relationships_h a, csi_ii_relationships b '||

3256: ' csi_ip_accounts_h c where a.instance_party_id = b.instance_party_id '||
3257: ' and b.ip_account_id = c.ip_account_id and c.transaction_id = :p_transaction_id UNION '||
3258: ' SELECT b.instance_id FROM csi_iea_values_h a, csi_iea_values b '||
3259: ' WHERE a.attribute_value_id = b.attribute_value_id AND a.transaction_id = :p_transaction_id '||
3260: ' UNION SELECT b.subject_id FROM csi_ii_relationships_h a, csi_ii_relationships b '||
3261: ' WHERE a.relationship_id = b.relationship_id AND a.transaction_id = :p_transaction_id '||
3262: ' UNION SELECT a.instance_id FROM csi_i_org_assignments a, csi_i_org_assignments_h b '||
3263: ' WHERE a.instance_ou_id = b.instance_ou_id and b.transaction_id = :p_transaction_id '||
3264: ' UNION SELECT a.instance_id FROM csi_i_pricing_attribs a , csi_i_pricing_attribs_h b '||

Line 7382: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;

7378: l_last_vld_organization_id NUMBER;
7379: l_child_temp VARCHAR2(1);
7380: p_rel_query_rec csi_datastructures_pub.relationship_query_rec;
7381: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
7382: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;
7383: l_vld_org_id NUMBER;
7384: PROCESS_NEXT EXCEPTION;
7385: l_instance_status_id NUMBER;
7386: l_system_id NUMBER;

Line 7484: csi_ii_relationships_pvt.Get_Children

7480: IF p_rel_query_rec.object_id IS NOT NULL AND
7481: p_rel_query_rec.object_id <> FND_API.G_MISS_NUM THEN
7482: IF p_unexpire = FND_API.G_TRUE THEN
7483: csi_gen_utility_pvt.put_line ( 'Calling Get_Children for Un-expiry...');
7484: csi_ii_relationships_pvt.Get_Children
7485: ( p_relationship_query_rec => p_rel_query_rec,
7486: p_rel_tbl => l_rel_tbl,
7487: p_depth => NULL,
7488: p_active_relationship_only => FND_API.G_TRUE,

Line 7505: csi_ii_relationships_pvt.Get_Children

7501: RAISE FND_API.G_EXC_ERROR;
7502: END IF;
7503: ELSE
7504: csi_gen_utility_pvt.put_line ( 'Calling Get_Children for Regular Inheritance...');
7505: csi_ii_relationships_pvt.Get_Children
7506: ( p_relationship_query_rec => p_rel_query_rec,
7507: p_rel_tbl => l_rel_tbl,
7508: p_depth => NULL,
7509: p_active_relationship_only => FND_API.G_TRUE,

Line 10748: FROM CSI_II_RELATIONSHIPS_H CIRH, CSI_II_RELATIONSHIPS CIR

10744: AND INSTANCE_ID=p_ins_id AND TRANSACTION_ID<>p_txn_id
10745: UNION ALL
10746:
10747: SELECT CIRH.TRANSACTION_ID TRANSACTION_ID, CIR.SUBJECT_ID INSTANCE_ID
10748: FROM CSI_II_RELATIONSHIPS_H CIRH, CSI_II_RELATIONSHIPS CIR
10749: WHERE CIRH.RELATIONSHIP_ID = CIR.RELATIONSHIP_ID
10750: AND subject_ID=p_ins_id AND TRANSACTION_ID<>p_txn_id
10751: UNION ALL
10752:

Line 10754: FROM CSI_II_RELATIONSHIPS_H CIRH, CSI_II_RELATIONSHIPS CIR

10750: AND subject_ID=p_ins_id AND TRANSACTION_ID<>p_txn_id
10751: UNION ALL
10752:
10753: SELECT CIRH.TRANSACTION_ID TRANSACTION_ID, CIR.OBJECT_ID INSTANCE_ID
10754: FROM CSI_II_RELATIONSHIPS_H CIRH, CSI_II_RELATIONSHIPS CIR
10755: WHERE CIRH.RELATIONSHIP_ID = CIR.RELATIONSHIP_ID
10756: AND object_ID=p_ins_id AND TRANSACTION_ID<>p_txn_id
10757: UNION ALL
10758:

Line 13671: -- then check if this record has been existing as a subject in csi_ii_relationships

13667:
13668: -- Start of bug fix 2151750 by sk on 02/04/02
13669:
13670: -- If location_type_code has been changing from something to INVENTORY
13671: -- then check if this record has been existing as a subject in csi_ii_relationships
13672: -- of COMPONENT-OF relationship_type_code and if exists then if
13673: -- l_get_instance_rec.instance_usage_code is not equal to
13674: -- IN_RELATIONSHIP then raise an error.
13675:

Line 13683: FROM csi_ii_relationships

13679: l_temp_rec := null;
13680: BEGIN
13681: SELECT 'x'
13682: INTO l_temp_rec
13683: FROM csi_ii_relationships
13684: WHERE relationship_type_code = 'COMPONENT-OF'
13685: AND subject_id = p_instance_rec.instance_id
13686: AND (active_end_date IS NULL OR active_end_date > SYSDATE);
13687: EXCEPTION

Line 13720: FROM csi_ii_relationships

13716: l_temp_rec1 := NULL;
13717: BEGIN
13718: SELECT 'x'
13719: INTO l_temp_rec1
13720: FROM csi_ii_relationships
13721: WHERE relationship_type_code = 'COMPONENT-OF'
13722: AND subject_id = p_instance_rec.instance_id
13723: AND (active_end_date IS NULL OR active_end_date > SYSDATE);
13724:

Line 18516: -- Check for any child instances in the csi ii relationships table by passing the parent instance id. If there exists

18512: RAISE fnd_api.g_exc_error;
18513: END IF;
18514: END IF;
18515: -- Calling eam API to log instance update event
18516: -- Check for any child instances in the csi ii relationships table by passing the parent instance id. If there exists
18517: -- any child instances then inherit the changed attributes with the changes in parent.
18518:
18519: IF l_curr_instance_rec.active_end_date IS NULL
18520: THEN l_curr_instance_rec.active_end_date:=FND_API.G_MISS_DATE;

Line 18859: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;

18855: l_mod_value NUMBER;
18856: l_dump_flag VARCHAR2(1);
18857: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
18858: p_rel_query_rec csi_datastructures_pub.relationship_query_rec;
18859: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;
18860:
18861: CURSOR curr_instance_rec(p_instance_id IN NUMBER) IS
18862: SELECT
18863: INSTANCE_ID,

Line 19040: csi_ii_relationships_pvt.Get_Children

19036: p_rel_query_rec.relationship_type_code := 'COMPONENT-OF';
19037: --
19038: IF p_rel_query_rec.object_id IS NOT NULL AND
19039: p_rel_query_rec.object_id <> FND_API.G_MISS_NUM THEN
19040: csi_ii_relationships_pvt.Get_Children
19041: ( p_relationship_query_rec => p_rel_query_rec,
19042: p_rel_tbl => l_rel_tbl,
19043: p_depth => NULL,
19044: p_active_relationship_only => FND_API.G_TRUE,

Line 20092: FROM csi_ii_relationships

20088:
20089: -- Added cursor for bug 6788183
20090: CURSOR relationship_csr (p_subject_id IN NUMBER) IS
20091: SELECT relationship_id,object_version_number
20092: FROM csi_ii_relationships
20093: WHERE subject_id = p_subject_id;
20094:
20095: l_instance_csr instance_csr%ROWTYPE;
20096:

Line 20191: -- checking for any unexpired children in csi_ii_relationships table

20187: RAISE FND_API.G_EXC_ERROR;
20188: END IF;
20189: CLOSE get_instance_rec;
20190:
20191: -- checking for any unexpired children in csi_ii_relationships table
20192:
20193: -- Added by sk for bug 2151760
20194: IF (( p_instance_rec.active_end_date IS NOT NULL) AND (p_instance_rec.active_end_date < SYSDATE))
20195: AND p_instance_rec.active_end_date <> fnd_api.g_miss_date

Line 20230: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;

20226: l_dummy NUMBER;
20227: l_has_unexpired_children BOOLEAN;
20228: p_rel_query_rec csi_datastructures_pub.relationship_query_rec;
20229: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
20230: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;
20231: BEGIN
20232: p_rel_query_rec.object_id := p_instance_rec.instance_id;
20233: p_rel_query_rec.relationship_type_code := 'COMPONENT-OF';
20234: --

Line 20237: csi_ii_relationships_pvt.Get_Children

20233: p_rel_query_rec.relationship_type_code := 'COMPONENT-OF';
20234: --
20235: IF p_rel_query_rec.object_id IS NOT NULL AND
20236: p_rel_query_rec.object_id <> FND_API.G_MISS_NUM THEN
20237: csi_ii_relationships_pvt.Get_Children
20238: ( p_relationship_query_rec => p_rel_query_rec,
20239: p_rel_tbl => l_rel_tbl,
20240: p_depth => NULL,
20241: p_active_relationship_only => FND_API.G_TRUE,

Line 20353: p_pkg_name => 'csi_ii_relationships_pub',

20349: l_exp_rltns_rec.relationship_id := l_inst_relationship_rec.relationship_id;
20350: l_exp_rltns_rec.object_version_number := l_inst_relationship_rec.object_version_number;
20351:
20352: csi_t_gen_utility_pvt.dump_api_info(
20353: p_pkg_name => 'csi_ii_relationships_pub',
20354: p_api_name => 'expire_relationship');
20355:
20356: csi_ii_relationships_pub.expire_relationship(
20357: p_api_version => 1.0,

Line 20356: csi_ii_relationships_pub.expire_relationship(

20352: csi_t_gen_utility_pvt.dump_api_info(
20353: p_pkg_name => 'csi_ii_relationships_pub',
20354: p_api_name => 'expire_relationship');
20355:
20356: csi_ii_relationships_pub.expire_relationship(
20357: p_api_version => 1.0,
20358: p_commit => fnd_api.g_false,
20359: p_init_msg_list => fnd_api.g_false,
20360: p_validation_level => fnd_api.g_valid_level_full,

Line 21719: FROM csi_ii_relationships

21715: ,l_relationship_tbl(1).attribute12
21716: ,l_relationship_tbl(1).attribute13
21717: ,l_relationship_tbl(1).attribute14
21718: ,l_relationship_tbl(1).attribute15
21719: FROM csi_ii_relationships
21720: WHERE subject_id=p_source_instance_rec.instance_id
21721: AND relationship_type_code='COMPONENT-OF'
21722: AND (SYSDATE BETWEEN NVL(active_start_date, SYSDATE) AND NVL(active_end_date, SYSDATE));
21723: EXCEPTION

Line 21733: csi_ii_relationships_pub.create_relationship(

21729: IF l_relationship_tbl(1).object_id IS NOT NULL
21730: AND l_relationship_tbl(1).object_id<>fnd_api.g_miss_num
21731: THEN
21732: l_relationship_tbl(1).subject_id:=l_new_instance_tbl(1).instance_id;
21733: csi_ii_relationships_pub.create_relationship(
21734: p_api_version => 1.0,
21735: p_commit => fnd_api.g_false,
21736: p_init_msg_list => fnd_api.g_true,
21737: p_validation_level => fnd_api.g_valid_level_full,

Line 22205: FROM csi_ii_relationships

22201: ,l_relationship_tbl(1).attribute12
22202: ,l_relationship_tbl(1).attribute13
22203: ,l_relationship_tbl(1).attribute14
22204: ,l_relationship_tbl(1).attribute15
22205: FROM csi_ii_relationships
22206: WHERE subject_id=p_source_instance_rec.instance_id
22207: AND relationship_type_code='COMPONENT-OF'
22208: AND (SYSDATE BETWEEN NVL(active_start_date, SYSDATE) AND NVL(active_end_date, SYSDATE));
22209: EXCEPTION

Line 22220: csi_ii_relationships_pub.create_relationship(

22216: AND l_relationship_tbl(1).object_id<>fnd_api.g_miss_num
22217: THEN
22218: l_relationship_tbl(1).relationship_id:=fnd_api.g_miss_num;
22219: l_relationship_tbl(1).subject_id:=l_new_instance_tbl(1).instance_id;
22220: csi_ii_relationships_pub.create_relationship(
22221: p_api_version => 1.0,
22222: p_commit => fnd_api.g_false,
22223: p_init_msg_list => fnd_api.g_true,
22224: p_validation_level => fnd_api.g_valid_level_full,

Line 28132: csi_ii_relationships_pvt.Get_Top_Most_Parent

28128: l_new_instance_rec.instance_usage_code := p_source_instance_rec.instance_usage_code;
28129: END IF;
28130: ELSE
28131: l_obj_id:=NULL;
28132: csi_ii_relationships_pvt.Get_Top_Most_Parent
28133: ( p_subject_id => p_source_instance_rec.instance_id,
28134: p_rel_type_code => 'COMPONENT-OF',
28135: p_object_id => l_obj_id
28136: );

Line 29692: csi_ii_relationships_pub.create_relationship

29688: End Loop;
29689: --
29690: IF x_rel_tbl.count > 0 THEN
29691: csi_gen_utility_pvt.put_line('Calling II Relationship PUB...');
29692: csi_ii_relationships_pub.create_relationship
29693: (
29694: p_api_version => 1.0,
29695: p_commit => fnd_api.g_false,
29696: p_init_msg_list => fnd_api.g_true,

Line 32161: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;

32157: l_version_label VARCHAR2(30);
32158: l_version_label_rec csi_datastructures_pub.version_label_rec;
32159: p_rel_query_rec csi_datastructures_pub.relationship_query_rec;
32160: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
32161: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;
32162: l_obj_id NUMBER;
32163: --
32164: px_oks_txn_inst_tbl oks_ibint_pub.txn_instance_tbl;
32165: l_batch_type VARCHAR2(50);

Line 33093: csi_ii_relationships_pvt.Get_Top_Most_Parent

33089: END IF;
33090:
33091: ELSE
33092: l_obj_id:=NULL;
33093: csi_ii_relationships_pvt.Get_Top_Most_Parent
33094: ( p_subject_id => p_source_instance_rec.instance_id,
33095: p_rel_type_code => 'COMPONENT-OF',
33096: p_object_id => l_obj_id
33097: );

Line 33906: csi_ii_relationships_pvt.Get_Children

33902: p_rel_query_rec.relationship_type_code := 'COMPONENT-OF';
33903: --
33904: IF p_rel_query_rec.object_id IS NOT NULL AND
33905: p_rel_query_rec.object_id <> FND_API.G_MISS_NUM THEN
33906: csi_ii_relationships_pvt.Get_Children
33907: ( p_relationship_query_rec => p_rel_query_rec,
33908: p_rel_tbl => l_rel_tbl,
33909: p_depth => NULL,
33910: p_active_relationship_only => FND_API.G_TRUE,

Line 34017: csi_ii_relationships_pvt.create_relationship

34013:
34014: -- Create the new configuration
34015: IF l_new_ii_relationship_tbl.count > 0
34016: THEN
34017: csi_ii_relationships_pvt.create_relationship
34018: ( p_api_version => p_api_version
34019: ,p_commit => p_commit
34020: ,p_init_msg_list => p_init_msg_list
34021: ,p_validation_level => p_validation_level

Line 34807: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;

34803: l_root_node NUMBER;
34804: l_config_tbl csi_cz_int.config_tbl := px_config_tbl;
34805: l_count NUMBER;
34806: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
34807: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;
34808: l_rel_query_rec csi_datastructures_pub.relationship_query_rec;
34809: l_lock_tbl CSI_ITEM_INSTANCE_PVT.lock_instances_tbl; --csi_cz_int.config_tbl;
34810: l_root NUMBER:=0;
34811: l_found VARCHAR2(1):='N';

Line 34990: csi_ii_relationships_pvt.get_top_most_parent

34986:
34987: IF l_found='N'
34988: THEN
34989:
34990: csi_ii_relationships_pvt.get_top_most_parent
34991: ( p_subject_id => px_config_tbl(i).instance_id,
34992: p_rel_type_code => l_rel_type_code,
34993: p_object_id => l_root_node
34994: );

Line 35000: csi_ii_relationships_pvt.get_children

34996:
34997: l_rel_query_rec.object_id := l_root_node;
34998: l_rel_query_rec.relationship_type_code := l_rel_type_code;
34999:
35000: csi_ii_relationships_pvt.get_children
35001: ( p_relationship_query_rec => l_rel_query_rec,
35002: p_rel_tbl => l_rel_tbl,
35003: p_depth => NULL,
35004: p_active_relationship_only => FND_API.G_TRUE,

Line 35577: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;

35573: l_api_name CONSTANT VARCHAR2(30) := 'UNLOCK_ITEM_INSTANCES';
35574: l_api_version CONSTANT NUMBER := 1.0;
35575: l_csi_debug_level NUMBER;
35576: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
35577: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;
35578: l_rel_query_rec csi_datastructures_pub.relationship_query_rec;
35579: l_rel_type_code VARCHAR2(30) := 'COMPONENT-OF';
35580: l_unlock_tbl csi_item_instance_pvt.lock_instances_tbl;
35581: l_unlock_ins_tbl csi_item_instance_pvt.lock_instances_tbl;