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.12 2008/03/08 01:08:26 fli 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.12 2008/03/08 01:08:26 fli 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:
14: /* Cyclic Relationships */
15:

Line 1688: p_ii_relationship_level_tbl OUT NOCOPY csi_ii_relationships_pvt.ii_relationship_level_tbl,

1684: p_active_instances_only IN VARCHAR2,
1685: p_config_only IN VARCHAR2, -- if true will retrieve instances with config keys
1686: p_time_stamp IN DATE,
1687: p_get_dfs IN VARCHAR2,
1688: p_ii_relationship_level_tbl OUT NOCOPY csi_ii_relationships_pvt.ii_relationship_level_tbl,
1689: x_return_status OUT NOCOPY VARCHAR2,
1690: x_msg_count OUT NOCOPY NUMBER,
1691: x_msg_data OUT NOCOPY VARCHAR2
1692: ) IS

Line 2092: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;

2088: l_found2 BOOLEAN;
2089: l_expire BOOLEAN;
2090: l_exp_count NUMBER:=0;
2091: l_relationship_query_rec csi_datastructures_pub.relationship_query_rec;
2092: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;
2093:
2094: BEGIN
2095: -- standard start of api savepoint
2096: -- SAVEPOINT get_relationships_pvt;

Line 2189: csi_ii_relationships_pvt.get_cyclic_relationships(

2185: l_instance_id := p_relationship_query_rec.object_id;
2186: END IF;
2187: END IF;
2188:
2189: csi_ii_relationships_pvt.get_cyclic_relationships(
2190: p_api_version => p_api_version,
2191: p_commit => fnd_api.g_false,
2192: p_init_msg_list => p_init_msg_list,
2193: p_validation_level => p_validation_level,

Line 2520: csi_ii_relationships_pvt.get_relationships

2516: THEN
2517: l_relationship_query_rec.object_id:=l_relationship_tbl(l_returned_rec_count).subject_id;
2518: l_relationship_query_rec.subject_id:=fnd_api.g_miss_num;
2519: csi_gen_utility_pvt.put_line('Into recurrsive call for get_relationships. ');
2520: csi_ii_relationships_pvt.get_relationships
2521: ( p_api_version => p_api_version
2522: ,p_commit => p_commit
2523: ,p_init_msg_list => p_init_msg_list
2524: ,p_validation_level => p_validation_level

Line 3307: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;

3303: )
3304: IS
3305: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
3306: p_relationship_query_rec csi_datastructures_pub.relationship_query_rec;
3307: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;
3308: /* CURSOR chk_obj_csr IS
3309: SELECT 'x'
3310: FROM csi_ii_relationships
3311: WHERE subject_id = p_object_id

Line 3333: csi_ii_relationships_pvt.Get_Children

3329: p_relationship_query_rec.object_id := p_subject_id; -- To check for Loop
3330: p_relationship_query_rec.relationship_type_code := p_relationship_type_code;
3331: --
3332: IF p_subject_id <> p_object_id THEN
3333: csi_ii_relationships_pvt.Get_Children
3334: ( p_relationship_query_rec => p_relationship_query_rec,
3335: p_rel_tbl => l_rel_tbl,
3336: p_depth => NULL,
3337: p_active_relationship_only => FND_API.G_TRUE,

Line 4428: csi_ii_relationships_pvt.Get_Immediate_Parents

4424:
4425: --To handle Case 1
4426: BEGIN
4427: --FOR update_instance_csr IN completeness_csr(l_ii_relationship_rec.subject_id)
4428: csi_ii_relationships_pvt.Get_Immediate_Parents
4429: ( p_subject_id => l_ii_relationship_rec.subject_id,
4430: p_rel_type_code => 'COMPONENT-OF',
4431: p_rel_tbl => l_rel_tbl
4432: );

Line 4803: csi_ii_relationships_pvt.check_for_object

4799: END IF;
4800:
4801: IF ((x_return_status=fnd_api.g_ret_sts_success) AND
4802: (p_relationship_tbl(l_count).object_id IS NOT NULL) ) THEN
4803: csi_ii_relationships_pvt.check_for_object
4804: (p_subject_id =>p_relationship_tbl(l_count).subject_id,
4805: p_object_id =>p_relationship_tbl(l_count).object_id,
4806: p_relationship_type_code =>p_relationship_tbl(l_count).relationship_type_code,
4807: x_return_status =>x_return_status,

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

4827: x_return_status:=fnd_api.g_ret_sts_error;
4828: RAISE fnd_api.g_exc_error;
4829: END IF;
4830: -- Start of att enhancements by sguthiva
4831: IF csi_ii_relationships_pvt.Is_link_type (p_instance_id => p_relationship_tbl(l_count).object_id )
4832: THEN
4833: IF csi_ii_relationships_pvt.relationship_for_link
4834: ( p_instance_id => p_relationship_tbl(l_count).object_id
4835: ,p_mode => 'CREATE'

Line 4833: IF csi_ii_relationships_pvt.relationship_for_link

4829: END IF;
4830: -- Start of att enhancements by sguthiva
4831: IF csi_ii_relationships_pvt.Is_link_type (p_instance_id => p_relationship_tbl(l_count).object_id )
4832: THEN
4833: IF csi_ii_relationships_pvt.relationship_for_link
4834: ( p_instance_id => p_relationship_tbl(l_count).object_id
4835: ,p_mode => 'CREATE'
4836: ,p_relationship_id => NULL )
4837: THEN

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

4841: RAISE fnd_api.g_exc_error;
4842: END IF;
4843: END IF;
4844:
4845: IF csi_ii_relationships_pvt.Is_link_type (p_instance_id => p_relationship_tbl(l_count).subject_id )
4846: THEN
4847: IF csi_ii_relationships_pvt.relationship_for_link
4848: ( p_instance_id => p_relationship_tbl(l_count).subject_id
4849: ,p_mode => 'CREATE'

Line 4847: IF csi_ii_relationships_pvt.relationship_for_link

4843: END IF;
4844:
4845: IF csi_ii_relationships_pvt.Is_link_type (p_instance_id => p_relationship_tbl(l_count).subject_id )
4846: THEN
4847: IF csi_ii_relationships_pvt.relationship_for_link
4848: ( p_instance_id => p_relationship_tbl(l_count).subject_id
4849: ,p_mode => 'CREATE'
4850: ,p_relationship_id => NULL )
4851: THEN

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

4887: LOOP
4888: x_msg_data := FND_MSG_PUB.GET
4889: ( l_msg_index,
4890: FND_API.G_FALSE );
4891: csi_gen_utility_pvt.put_line( ' Error from CSI_II_RELATIONSHIPS_PVT.CREATE_RELATIONSHIP');
4892: csi_gen_utility_pvt.put_line( ' Call to update_instance has errored ....');
4893: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
4894: l_msg_index := l_msg_index + 1;
4895: l_msg_count := l_msg_count - 1;

Line 5243: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;

5239: l_exists VARCHAR2(1);
5240: -- Added for cascade ownership change bug 2972082
5241: l_relationship_query_rec csi_datastructures_pub.relationship_query_rec;
5242: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
5243: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;
5244: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5245: l_party_tbl csi_datastructures_pub.party_tbl;
5246: l_account_tbl csi_datastructures_pub.party_account_tbl;
5247: l_temp_party_tbl csi_datastructures_pub.party_tbl;

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

5501: ELSE
5502: l_sub_id := p_relationship_tbl(l_count).subject_id;
5503: END IF;
5504: --
5505: IF csi_ii_relationships_pvt.Is_link_type (p_instance_id => l_obj_id )
5506: THEN
5507: IF csi_ii_relationships_pvt.relationship_for_link
5508: ( p_instance_id => l_obj_id
5509: ,p_mode => 'UPDATE'

Line 5507: IF csi_ii_relationships_pvt.relationship_for_link

5503: END IF;
5504: --
5505: IF csi_ii_relationships_pvt.Is_link_type (p_instance_id => l_obj_id )
5506: THEN
5507: IF csi_ii_relationships_pvt.relationship_for_link
5508: ( p_instance_id => l_obj_id
5509: ,p_mode => 'UPDATE'
5510: ,p_relationship_id => p_relationship_tbl(l_count).relationship_id )
5511: THEN

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

5515: RAISE fnd_api.g_exc_error;
5516: END IF;
5517: END IF;
5518: --
5519: IF csi_ii_relationships_pvt.Is_link_type (p_instance_id => l_sub_id )
5520: THEN
5521: IF csi_ii_relationships_pvt.relationship_for_link
5522: ( p_instance_id => l_sub_id
5523: ,p_mode => 'UPDATE'

Line 5521: IF csi_ii_relationships_pvt.relationship_for_link

5517: END IF;
5518: --
5519: IF csi_ii_relationships_pvt.Is_link_type (p_instance_id => l_sub_id )
5520: THEN
5521: IF csi_ii_relationships_pvt.relationship_for_link
5522: ( p_instance_id => l_sub_id
5523: ,p_mode => 'UPDATE'
5524: ,p_relationship_id => p_relationship_tbl(l_count).relationship_id )
5525: THEN

Line 5556: csi_ii_relationships_pvt.Get_Top_Most_Parent

5552: )
5553: THEN
5554: l_object_id := NULL;
5555: l_found:=FALSE;
5556: csi_ii_relationships_pvt.Get_Top_Most_Parent
5557: ( p_subject_id => l_relship_csr.subject_id,
5558: p_rel_type_code => 'COMPONENT-OF',
5559: p_object_id => l_object_id
5560: );

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

5668: LOOP
5669: x_msg_data := FND_MSG_PUB.GET
5670: ( l_msg_index,
5671: FND_API.G_FALSE );
5672: csi_gen_utility_pvt.put_line( ' Error from CSI_II_RELATIONSHIPS_PVT.UPDATE_RELATIONSHIP');
5673: csi_gen_utility_pvt.put_line( ' Call to update_instance has errored ....');
5674: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
5675: l_msg_index := l_msg_index + 1;
5676: l_msg_count := l_msg_count - 1;

Line 5720: csi_ii_relationships_pvt.expire_relationship

5716: END IF;
5717:
5718: /*
5719: ELSE
5720: csi_ii_relationships_pvt.expire_relationship
5721: (p_api_version => p_api_version,
5722: p_commit => fnd_api.g_false,
5723: p_init_msg_list => p_init_msg_list,
5724: p_validation_level => p_validation_level,

Line 5744: csi_ii_relationships_pvt.create_relationship(

5740: l_relationship_tbl(1).subject_has_child := 'Y' ;
5741: l_relationship_tbl(1).active_start_date := SYSDATE ;
5742: l_relationship_tbl(1).object_version_number:=1;
5743:
5744: csi_ii_relationships_pvt.create_relationship(
5745: p_api_version => p_api_version,
5746: p_commit => fnd_api.g_false,
5747: p_init_msg_list => p_init_msg_list,
5748: p_validation_level => p_validation_level,

Line 6156: csi_ii_relationships_pvt.Get_Top_Most_Parent

6152: THEN
6153: BEGIN
6154: l_object_id := NULL;
6155: l_found:=FALSE;
6156: csi_ii_relationships_pvt.Get_Top_Most_Parent
6157: ( p_subject_id => l_relship_csr.subject_id,
6158: p_rel_type_code => 'COMPONENT-OF',
6159: p_object_id => l_object_id
6160: );

Line 7402: csi_ii_relationships_pvt.Resolve_id_columns(x_rel_history_tbl);

7398: i := i + 1;
7399: END LOOP;
7400: -- srramakr moved outside the loop
7401: -- Resolve the id columns
7402: csi_ii_relationships_pvt.Resolve_id_columns(x_rel_history_tbl);
7403:
7404: -- End of API body
7405:
7406: -- Standard check of p_commit.

Line 7489: l_rel_color_tbl csi_ii_relationships_pvt.REL_COLOR_TBL;

7485: l_adj_node NUMBER;
7486: l_rel_tbl_final csi_datastructures_pub.ii_relationship_tbl;
7487: l_api_name CONSTANT VARCHAR2(50) := 'get_cyclic_node';
7488: --
7489: l_rel_color_tbl csi_ii_relationships_pvt.REL_COLOR_TBL;
7490: l_rel_color_ctr NUMBER := 0;
7491: --
7492: COMP_ERROR EXCEPTION;
7493: BEGIN

Line 7503: csi_ii_relationships_pvt.get_cyclic_relationships(

7499: IF (l_debug_level > 0) THEN
7500: CSI_gen_utility_pvt.put_line( 'Get_Cyclic_Node');
7501: END IF;
7502: --
7503: csi_ii_relationships_pvt.get_cyclic_relationships(
7504: p_api_version => 1.0,
7505: p_commit => fnd_api.g_false,
7506: p_init_msg_list => fnd_api.g_true,
7507: p_validation_level => fnd_api.g_valid_level_full,

Line 7728: END csi_ii_relationships_pvt;

7724: return l_root_object_id;
7725: END Get_Root_Parent;
7726: -- End Add Code for Siebel Genesis Project
7727:
7728: END csi_ii_relationships_pvt;