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_II_RELATIONSHIPS_PVT dependencies on CSI_II_RELATIONSHIPS_PVT

Line 1: PACKAGE BODY csi_ii_relationships_pvt AS

1: PACKAGE BODY csi_ii_relationships_pvt AS
2: /* $Header: csiviirb.pls 120.29.12020000.4 2012/09/13 11:20:02 sjawaji ship $ */
3: -- start of comments
4: -- package name : csi_ii_relationships_pvt
5: -- purpose :

Line 4: -- package name : csi_ii_relationships_pvt

1: PACKAGE BODY csi_ii_relationships_pvt AS
2: /* $Header: csiviirb.pls 120.29.12020000.4 2012/09/13 11:20:02 sjawaji ship $ */
3: -- start of comments
4: -- package name : csi_ii_relationships_pvt
5: -- purpose :
6: -- history :
7: -- note :
8: -- END of comments

Line 11: g_pkg_name CONSTANT VARCHAR2(30) := 'csi_ii_relationships_pvt';

7: -- note :
8: -- END of comments
9:
10:
11: g_pkg_name CONSTANT VARCHAR2(30) := 'csi_ii_relationships_pvt';
12: g_file_name CONSTANT VARCHAR2(12) := 'csiviirb.pls';
13: p_rel_glbl_tbl csi_datastructures_pub.ii_relationship_tbl;
14: p_glbl_ctr NUMBER := 0;
15:

Line 16: p_ii_rel_level_glbl_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl; --bug 10321217

12: g_file_name CONSTANT VARCHAR2(12) := 'csiviirb.pls';
13: p_rel_glbl_tbl csi_datastructures_pub.ii_relationship_tbl;
14: p_glbl_ctr NUMBER := 0;
15:
16: p_ii_rel_level_glbl_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl; --bug 10321217
17:
18:
19: /* Cyclic Relationships */
20:

Line 1769: p_ii_relationship_level_tbl OUT NOCOPY csi_ii_relationships_pvt.ii_relationship_level_tbl,

1765: p_active_instances_only IN VARCHAR2,
1766: p_config_only IN VARCHAR2, -- if true will retrieve instances with config keys
1767: p_time_stamp IN DATE,
1768: p_get_dfs IN VARCHAR2,
1769: p_ii_relationship_level_tbl OUT NOCOPY csi_ii_relationships_pvt.ii_relationship_level_tbl,
1770: x_return_status OUT NOCOPY VARCHAR2,
1771: x_msg_count OUT NOCOPY NUMBER,
1772: x_msg_data OUT NOCOPY VARCHAR2
1773: ) IS

Line 2217: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;

2213: l_found2 BOOLEAN;
2214: l_expire BOOLEAN;
2215: l_exp_count NUMBER:=0;
2216: l_relationship_query_rec csi_datastructures_pub.relationship_query_rec;
2217: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;
2218:
2219: BEGIN
2220: -- standard start of api savepoint
2221: -- SAVEPOINT get_relationships_pvt;

Line 2314: csi_ii_relationships_pvt.get_cyclic_relationships(

2310: l_instance_id := p_relationship_query_rec.object_id;
2311: END IF;
2312: END IF;
2313:
2314: csi_ii_relationships_pvt.get_cyclic_relationships(
2315: p_api_version => p_api_version,
2316: p_commit => fnd_api.g_false,
2317: p_init_msg_list => p_init_msg_list,
2318: p_validation_level => p_validation_level,

Line 2647: csi_ii_relationships_pvt.get_relationships

2643: THEN
2644: l_relationship_query_rec.object_id:=l_relationship_tbl(l_returned_rec_count).subject_id;
2645: l_relationship_query_rec.subject_id:=fnd_api.g_miss_num;
2646: csi_gen_utility_pvt.put_line('Into recurrsive call for get_relationships. ');
2647: csi_ii_relationships_pvt.get_relationships
2648: ( p_api_version => p_api_version
2649: ,p_commit => p_commit
2650: ,p_init_msg_list => p_init_msg_list
2651: ,p_validation_level => p_validation_level

Line 3455: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;

3451: )
3452: IS
3453: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
3454: p_relationship_query_rec csi_datastructures_pub.relationship_query_rec;
3455: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;
3456: /* CURSOR chk_obj_csr IS
3457: SELECT 'x'
3458: FROM csi_ii_relationships
3459: WHERE subject_id = p_object_id

Line 3481: csi_ii_relationships_pvt.Get_Children

3477: p_relationship_query_rec.object_id := p_subject_id; -- To check for Loop
3478: p_relationship_query_rec.relationship_type_code := p_relationship_type_code;
3479: --
3480: IF p_subject_id <> p_object_id THEN
3481: csi_ii_relationships_pvt.Get_Children
3482: ( p_relationship_query_rec => p_relationship_query_rec,
3483: p_rel_tbl => l_rel_tbl,
3484: p_depth => NULL,
3485: p_active_relationship_only => FND_API.G_TRUE,

Line 4588: csi_ii_relationships_pvt.Get_Immediate_Parents

4584:
4585: --To handle Case 1
4586: BEGIN
4587: --FOR update_instance_csr IN completeness_csr(l_ii_relationship_rec.subject_id)
4588: csi_ii_relationships_pvt.Get_Immediate_Parents
4589: ( p_subject_id => l_ii_relationship_rec.subject_id,
4590: p_rel_type_code => 'COMPONENT-OF',
4591: p_rel_tbl => l_rel_tbl
4592: );

Line 4971: csi_ii_relationships_pvt.check_for_object

4967: END IF;
4968:
4969: IF ((x_return_status=fnd_api.g_ret_sts_success) AND
4970: (p_relationship_tbl(l_count).object_id IS NOT NULL) ) THEN
4971: csi_ii_relationships_pvt.check_for_object
4972: (p_subject_id =>p_relationship_tbl(l_count).subject_id,
4973: p_object_id =>p_relationship_tbl(l_count).object_id,
4974: p_relationship_type_code =>p_relationship_tbl(l_count).relationship_type_code,
4975: x_return_status =>x_return_status,

Line 4999: IF csi_ii_relationships_pvt.Is_link_type (p_instance_id => p_relationship_tbl(l_count).object_id )

4995: x_return_status:=fnd_api.g_ret_sts_error;
4996: RAISE fnd_api.g_exc_error;
4997: END IF;
4998: -- Start of att enhancements by sguthiva
4999: IF csi_ii_relationships_pvt.Is_link_type (p_instance_id => p_relationship_tbl(l_count).object_id )
5000: THEN
5001: IF csi_ii_relationships_pvt.relationship_for_link
5002: ( p_instance_id => p_relationship_tbl(l_count).object_id
5003: ,p_mode => 'CREATE'

Line 5001: IF csi_ii_relationships_pvt.relationship_for_link

4997: END IF;
4998: -- Start of att enhancements by sguthiva
4999: IF csi_ii_relationships_pvt.Is_link_type (p_instance_id => p_relationship_tbl(l_count).object_id )
5000: THEN
5001: IF csi_ii_relationships_pvt.relationship_for_link
5002: ( p_instance_id => p_relationship_tbl(l_count).object_id
5003: ,p_mode => 'CREATE'
5004: ,p_relationship_id => NULL )
5005: THEN

Line 5013: IF csi_ii_relationships_pvt.Is_link_type (p_instance_id => p_relationship_tbl(l_count).subject_id )

5009: RAISE fnd_api.g_exc_error;
5010: END IF;
5011: END IF;
5012:
5013: IF csi_ii_relationships_pvt.Is_link_type (p_instance_id => p_relationship_tbl(l_count).subject_id )
5014: THEN
5015: IF csi_ii_relationships_pvt.relationship_for_link
5016: ( p_instance_id => p_relationship_tbl(l_count).subject_id
5017: ,p_mode => 'CREATE'

Line 5015: IF csi_ii_relationships_pvt.relationship_for_link

5011: END IF;
5012:
5013: IF csi_ii_relationships_pvt.Is_link_type (p_instance_id => p_relationship_tbl(l_count).subject_id )
5014: THEN
5015: IF csi_ii_relationships_pvt.relationship_for_link
5016: ( p_instance_id => p_relationship_tbl(l_count).subject_id
5017: ,p_mode => 'CREATE'
5018: ,p_relationship_id => NULL )
5019: THEN

Line 5059: csi_gen_utility_pvt.put_line( ' Error from CSI_II_RELATIONSHIPS_PVT.CREATE_RELATIONSHIP');

5055: LOOP
5056: x_msg_data := FND_MSG_PUB.GET
5057: ( l_msg_index,
5058: FND_API.G_FALSE );
5059: csi_gen_utility_pvt.put_line( ' Error from CSI_II_RELATIONSHIPS_PVT.CREATE_RELATIONSHIP');
5060: csi_gen_utility_pvt.put_line( ' Call to update_instance has errored ....');
5061: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
5062: l_msg_index := l_msg_index + 1;
5063: l_msg_count := l_msg_count - 1;

Line 5415: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;

5411: l_exists VARCHAR2(1);
5412: -- Added for cascade ownership change bug 2972082
5413: l_relationship_query_rec csi_datastructures_pub.relationship_query_rec;
5414: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
5415: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;
5416: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5417: l_party_tbl csi_datastructures_pub.party_tbl;
5418: l_account_tbl csi_datastructures_pub.party_account_tbl;
5419: l_temp_party_tbl csi_datastructures_pub.party_tbl;

Line 5682: IF csi_ii_relationships_pvt.Is_link_type (p_instance_id => l_obj_id )

5678: ELSE
5679: l_sub_id := p_relationship_tbl(l_count).subject_id;
5680: END IF;
5681: --
5682: IF csi_ii_relationships_pvt.Is_link_type (p_instance_id => l_obj_id )
5683: THEN
5684: IF csi_ii_relationships_pvt.relationship_for_link
5685: ( p_instance_id => l_obj_id
5686: ,p_mode => 'UPDATE'

Line 5684: IF csi_ii_relationships_pvt.relationship_for_link

5680: END IF;
5681: --
5682: IF csi_ii_relationships_pvt.Is_link_type (p_instance_id => l_obj_id )
5683: THEN
5684: IF csi_ii_relationships_pvt.relationship_for_link
5685: ( p_instance_id => l_obj_id
5686: ,p_mode => 'UPDATE'
5687: ,p_relationship_id => p_relationship_tbl(l_count).relationship_id )
5688: THEN

Line 5696: IF csi_ii_relationships_pvt.Is_link_type (p_instance_id => l_sub_id )

5692: RAISE fnd_api.g_exc_error;
5693: END IF;
5694: END IF;
5695: --
5696: IF csi_ii_relationships_pvt.Is_link_type (p_instance_id => l_sub_id )
5697: THEN
5698: IF csi_ii_relationships_pvt.relationship_for_link
5699: ( p_instance_id => l_sub_id
5700: ,p_mode => 'UPDATE'

Line 5698: IF csi_ii_relationships_pvt.relationship_for_link

5694: END IF;
5695: --
5696: IF csi_ii_relationships_pvt.Is_link_type (p_instance_id => l_sub_id )
5697: THEN
5698: IF csi_ii_relationships_pvt.relationship_for_link
5699: ( p_instance_id => l_sub_id
5700: ,p_mode => 'UPDATE'
5701: ,p_relationship_id => p_relationship_tbl(l_count).relationship_id )
5702: THEN

Line 5733: csi_ii_relationships_pvt.Get_Top_Most_Parent

5729: )
5730: THEN
5731: l_object_id := NULL;
5732: l_found:=FALSE;
5733: csi_ii_relationships_pvt.Get_Top_Most_Parent
5734: ( p_subject_id => l_relship_csr.subject_id,
5735: p_rel_type_code => 'COMPONENT-OF',
5736: p_object_id => l_object_id
5737: );

Line 5849: csi_gen_utility_pvt.put_line( ' Error from CSI_II_RELATIONSHIPS_PVT.UPDATE_RELATIONSHIP');

5845: LOOP
5846: x_msg_data := FND_MSG_PUB.GET
5847: ( l_msg_index,
5848: FND_API.G_FALSE );
5849: csi_gen_utility_pvt.put_line( ' Error from CSI_II_RELATIONSHIPS_PVT.UPDATE_RELATIONSHIP');
5850: csi_gen_utility_pvt.put_line( ' Call to update_instance has errored ....');
5851: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
5852: l_msg_index := l_msg_index + 1;
5853: l_msg_count := l_msg_count - 1;

Line 5897: csi_ii_relationships_pvt.expire_relationship

5893: END IF;
5894:
5895: /*
5896: ELSE
5897: csi_ii_relationships_pvt.expire_relationship
5898: (p_api_version => p_api_version,
5899: p_commit => fnd_api.g_false,
5900: p_init_msg_list => p_init_msg_list,
5901: p_validation_level => p_validation_level,

Line 5921: csi_ii_relationships_pvt.create_relationship(

5917: l_relationship_tbl(1).subject_has_child := 'Y' ;
5918: l_relationship_tbl(1).active_start_date := SYSDATE ;
5919: l_relationship_tbl(1).object_version_number:=1;
5920:
5921: csi_ii_relationships_pvt.create_relationship(
5922: p_api_version => p_api_version,
5923: p_commit => fnd_api.g_false,
5924: p_init_msg_list => p_init_msg_list,
5925: p_validation_level => p_validation_level,

Line 6365: csi_ii_relationships_pvt.Get_Top_Most_Parent

6361: THEN
6362: BEGIN
6363: l_object_id := NULL;
6364: l_found:=FALSE;
6365: csi_ii_relationships_pvt.Get_Top_Most_Parent
6366: ( p_subject_id => l_relship_csr.subject_id,
6367: p_rel_type_code => 'COMPONENT-OF',
6368: p_object_id => l_object_id
6369: );

Line 7669: csi_ii_relationships_pvt.Resolve_id_columns(x_rel_history_tbl);

7665: i := i + 1;
7666: END LOOP;
7667: -- srramakr moved outside the loop
7668: -- Resolve the id columns
7669: csi_ii_relationships_pvt.Resolve_id_columns(x_rel_history_tbl);
7670:
7671: -- End of API body
7672:
7673: -- Standard check of p_commit.

Line 7760: l_rel_color_tbl csi_ii_relationships_pvt.REL_COLOR_TBL;

7756: l_adj_node NUMBER;
7757: l_rel_tbl_final csi_datastructures_pub.ii_relationship_tbl;
7758: l_api_name CONSTANT VARCHAR2(50) := 'get_cyclic_node';
7759: --
7760: l_rel_color_tbl csi_ii_relationships_pvt.REL_COLOR_TBL;
7761: l_rel_color_ctr NUMBER := 0;
7762: --
7763: COMP_ERROR EXCEPTION;
7764: BEGIN

Line 7774: csi_ii_relationships_pvt.get_cyclic_relationships(

7770: IF (l_debug_level > 0) THEN
7771: CSI_gen_utility_pvt.put_line( 'Get_Cyclic_Node');
7772: END IF;
7773: --
7774: csi_ii_relationships_pvt.get_cyclic_relationships(
7775: p_api_version => 1.0,
7776: p_commit => fnd_api.g_false,
7777: p_init_msg_list => fnd_api.g_true,
7778: p_validation_level => fnd_api.g_valid_level_full,

Line 8002: END csi_ii_relationships_pvt;

7998: return l_root_object_id;
7999: END Get_Root_Parent;
8000: -- End Add Code for Siebel Genesis Project
8001:
8002: END csi_ii_relationships_pvt;