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_PVT

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 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 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 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 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;