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.

[Home] [Help]

APPS.CSI_ITEM_INSTANCE_PVT dependencies on CSI_II_RELATIONSHIPS_PVT

Line 7467: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;

7463: l_last_vld_organization_id NUMBER;
7464: l_child_temp VARCHAR2(1);
7465: p_rel_query_rec csi_datastructures_pub.relationship_query_rec;
7466: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
7467: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;
7468: l_vld_org_id NUMBER;
7469: PROCESS_NEXT EXCEPTION;
7470: l_instance_status_id NUMBER;
7471: l_system_id NUMBER;

Line 7570: csi_ii_relationships_pvt.Get_Children

7566: IF p_rel_query_rec.object_id IS NOT NULL AND
7567: p_rel_query_rec.object_id <> FND_API.G_MISS_NUM THEN
7568: IF p_unexpire = FND_API.G_TRUE THEN
7569: csi_gen_utility_pvt.put_line ( 'Calling Get_Children for Un-expiry...');
7570: csi_ii_relationships_pvt.Get_Children
7571: ( p_relationship_query_rec => p_rel_query_rec,
7572: p_rel_tbl => l_rel_tbl,
7573: p_depth => NULL,
7574: p_active_relationship_only => FND_API.G_TRUE,

Line 7591: csi_ii_relationships_pvt.Get_Children

7587: RAISE FND_API.G_EXC_ERROR;
7588: END IF;
7589: ELSE
7590: csi_gen_utility_pvt.put_line ( 'Calling Get_Children for Regular Inheritance...');
7591: csi_ii_relationships_pvt.Get_Children
7592: ( p_relationship_query_rec => p_rel_query_rec,
7593: p_rel_tbl => l_rel_tbl,
7594: p_depth => NULL,
7595: p_active_relationship_only => FND_API.G_TRUE,

Line 7932: l_root_asset_id := csi_ii_relationships_pvt.Get_Root_Parent(l_rel_tbl(j).subject_id,

7928:
7929: --Added call to update instance event for bug 7699277
7930: --As the integration design requires a create event to create the asset
7931: --and an update event to create the relationship hierarchy
7932: l_root_asset_id := csi_ii_relationships_pvt.Get_Root_Parent(l_rel_tbl(j).subject_id,
7933: l_rel_tbl(j).relationship_type_code,
7934: l_rel_tbl(j).object_id);
7935: csi_gen_utility_pvt.put_line('l_rel_tbl(' || j || ').subject_id : ' || l_rel_tbl(j).subject_id);
7936: csi_gen_utility_pvt.put_line('l_rel_tbl(' || j || ').relationship_type_code : ' || l_rel_tbl(j).relationship_type_code);

Line 19356: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;

19352: l_mod_value NUMBER;
19353: l_dump_flag VARCHAR2(1);
19354: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
19355: p_rel_query_rec csi_datastructures_pub.relationship_query_rec;
19356: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;
19357:
19358: CURSOR curr_instance_rec(p_instance_id IN NUMBER) IS
19359: SELECT
19360: INSTANCE_ID,

Line 19537: csi_ii_relationships_pvt.Get_Children

19533: p_rel_query_rec.relationship_type_code := 'COMPONENT-OF';
19534: --
19535: IF p_rel_query_rec.object_id IS NOT NULL AND
19536: p_rel_query_rec.object_id <> FND_API.G_MISS_NUM THEN
19537: csi_ii_relationships_pvt.Get_Children
19538: ( p_relationship_query_rec => p_rel_query_rec,
19539: p_rel_tbl => l_rel_tbl,
19540: p_depth => NULL,
19541: p_active_relationship_only => FND_API.G_TRUE,

Line 20764: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;

20760: l_dummy NUMBER;
20761: l_has_unexpired_children BOOLEAN;
20762: p_rel_query_rec csi_datastructures_pub.relationship_query_rec;
20763: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
20764: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;
20765: BEGIN
20766: p_rel_query_rec.object_id := p_instance_rec.instance_id;
20767: p_rel_query_rec.relationship_type_code := 'COMPONENT-OF';
20768: --

Line 20771: csi_ii_relationships_pvt.Get_Children

20767: p_rel_query_rec.relationship_type_code := 'COMPONENT-OF';
20768: --
20769: IF p_rel_query_rec.object_id IS NOT NULL AND
20770: p_rel_query_rec.object_id <> FND_API.G_MISS_NUM THEN
20771: csi_ii_relationships_pvt.Get_Children
20772: ( p_relationship_query_rec => p_rel_query_rec,
20773: p_rel_tbl => l_rel_tbl,
20774: p_depth => NULL,
20775: p_active_relationship_only => FND_API.G_TRUE,

Line 28709: csi_ii_relationships_pvt.Get_Top_Most_Parent

28705: l_new_instance_rec.instance_usage_code := p_source_instance_rec.instance_usage_code;
28706: END IF;
28707: ELSE
28708: l_obj_id:=NULL;
28709: csi_ii_relationships_pvt.Get_Top_Most_Parent
28710: ( p_subject_id => p_source_instance_rec.instance_id,
28711: p_rel_type_code => 'COMPONENT-OF',
28712: p_object_id => l_obj_id
28713: );

Line 32781: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;

32777: l_version_label VARCHAR2(30);
32778: l_version_label_rec csi_datastructures_pub.version_label_rec;
32779: p_rel_query_rec csi_datastructures_pub.relationship_query_rec;
32780: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
32781: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;
32782: l_obj_id NUMBER;
32783: --
32784: px_oks_txn_inst_tbl oks_ibint_pub.txn_instance_tbl;
32785: l_batch_type VARCHAR2(50);

Line 33715: csi_ii_relationships_pvt.Get_Top_Most_Parent

33711: END IF;
33712:
33713: ELSE
33714: l_obj_id:=NULL;
33715: csi_ii_relationships_pvt.Get_Top_Most_Parent
33716: ( p_subject_id => p_source_instance_rec.instance_id,
33717: p_rel_type_code => 'COMPONENT-OF',
33718: p_object_id => l_obj_id
33719: );

Line 34549: csi_ii_relationships_pvt.Get_Children

34545: p_rel_query_rec.relationship_type_code := 'COMPONENT-OF';
34546: --
34547: IF p_rel_query_rec.object_id IS NOT NULL AND
34548: p_rel_query_rec.object_id <> FND_API.G_MISS_NUM THEN
34549: csi_ii_relationships_pvt.Get_Children
34550: ( p_relationship_query_rec => p_rel_query_rec,
34551: p_rel_tbl => l_rel_tbl,
34552: p_depth => NULL,
34553: p_active_relationship_only => FND_API.G_TRUE,

Line 34660: csi_ii_relationships_pvt.create_relationship

34656:
34657: -- Create the new configuration
34658: IF l_new_ii_relationship_tbl.count > 0
34659: THEN
34660: csi_ii_relationships_pvt.create_relationship
34661: ( p_api_version => p_api_version
34662: ,p_commit => p_commit
34663: ,p_init_msg_list => p_init_msg_list
34664: ,p_validation_level => p_validation_level

Line 35464: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;

35460: l_root_node NUMBER;
35461: l_config_tbl csi_cz_int.config_tbl := px_config_tbl;
35462: l_count NUMBER;
35463: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
35464: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;
35465: l_rel_query_rec csi_datastructures_pub.relationship_query_rec;
35466: l_lock_tbl CSI_ITEM_INSTANCE_PVT.lock_instances_tbl; --csi_cz_int.config_tbl;
35467: l_root NUMBER:=0;
35468: l_found VARCHAR2(1):='N';

Line 35647: csi_ii_relationships_pvt.get_top_most_parent

35643:
35644: IF l_found='N'
35645: THEN
35646:
35647: csi_ii_relationships_pvt.get_top_most_parent
35648: ( p_subject_id => px_config_tbl(i).instance_id,
35649: p_rel_type_code => l_rel_type_code,
35650: p_object_id => l_root_node
35651: );

Line 35657: csi_ii_relationships_pvt.get_children

35653:
35654: l_rel_query_rec.object_id := l_root_node;
35655: l_rel_query_rec.relationship_type_code := l_rel_type_code;
35656:
35657: csi_ii_relationships_pvt.get_children
35658: ( p_relationship_query_rec => l_rel_query_rec,
35659: p_rel_tbl => l_rel_tbl,
35660: p_depth => NULL,
35661: p_active_relationship_only => FND_API.G_TRUE,

Line 36238: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;

36234: l_api_name CONSTANT VARCHAR2(30) := 'UNLOCK_ITEM_INSTANCES';
36235: l_api_version CONSTANT NUMBER := 1.0;
36236: l_csi_debug_level NUMBER;
36237: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
36238: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;
36239: l_rel_query_rec csi_datastructures_pub.relationship_query_rec;
36240: l_rel_type_code VARCHAR2(30) := 'COMPONENT-OF';
36241: l_unlock_tbl csi_item_instance_pvt.lock_instances_tbl;
36242: l_unlock_ins_tbl csi_item_instance_pvt.lock_instances_tbl;