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

Line 1: PACKAGE BODY csi_ii_relationships_pub AS

1: PACKAGE BODY csi_ii_relationships_pub AS
2: /* $Header: csipiirb.pls 120.2 2007/10/20 00:43:12 fli ship $ */
3: -- start of comments
4: -- package name : csi_ii_relationships_pub
5: -- purpose :

Line 4: -- package name : csi_ii_relationships_pub

1: PACKAGE BODY csi_ii_relationships_pub AS
2: /* $Header: csipiirb.pls 120.2 2007/10/20 00:43:12 fli ship $ */
3: -- start of comments
4: -- package name : csi_ii_relationships_pub
5: -- purpose :
6: -- history :
7: -- note :
8: -- END of comments

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

7: -- note :
8: -- END of comments
9:
10:
11: g_pkg_name CONSTANT VARCHAR2(30) := 'csi_ii_relationships_pub';
12: g_file_name CONSTANT VARCHAR2(12) := 'csipiirb.pls';
13:
14:
15: PROCEDURE get_relationships

Line 99: csi_ii_relationships_pvt.get_relationships(

95: -- api body
96: --
97: -- debug message
98:
99: csi_ii_relationships_pvt.get_relationships(
100: p_api_version => p_api_version,
101: p_commit => fnd_api.g_false,
102: p_init_msg_list => p_init_msg_list,
103: p_validation_level => p_validation_level,

Line 272: FROM csi_ii_relationships

268: SELECT relationship_id,
269: object_version_number
270: INTO l_relationship_id,
271: l_object_version_number
272: FROM csi_ii_relationships
273: where relationship_id = (select max(relationship_id)
274: from CSI_II_RELATIONSHIPS
275: WHERE object_id=p_relationship_tbl(l_count).object_id
276: AND subject_id=p_relationship_tbl(l_count).subject_id -- sguthiva added for bug 2370120

Line 274: from CSI_II_RELATIONSHIPS

270: INTO l_relationship_id,
271: l_object_version_number
272: FROM csi_ii_relationships
273: where relationship_id = (select max(relationship_id)
274: from CSI_II_RELATIONSHIPS
275: WHERE object_id=p_relationship_tbl(l_count).object_id
276: AND subject_id=p_relationship_tbl(l_count).subject_id -- sguthiva added for bug 2370120
277: AND nvl(position_reference,fnd_api.g_miss_char) =
278: nvl(p_relationship_tbl(l_count).position_reference,fnd_api.g_miss_char)

Line 293: csi_ii_relationships_pvt.update_relationship(

289: THEN
290: l_relationship_tbl(1).active_end_date:=NULL;
291: END IF;
292:
293: csi_ii_relationships_pvt.update_relationship(
294: p_api_version => p_api_version,
295: p_commit => fnd_api.g_false,
296: p_init_msg_list => p_init_msg_list,
297: p_validation_level => p_validation_level,

Line 323: csi_ii_relationships_pvt.create_relationship(

319: EXCEPTION
320: WHEN NO_DATA_FOUND THEN
321: -- l_relationship_tbl:=l_dummy_tbl;
322: l_relationship_tbl(1):=p_relationship_tbl(l_count);
323: csi_ii_relationships_pvt.create_relationship(
324: p_api_version => p_api_version,
325: p_commit => fnd_api.g_false,
326: p_init_msg_list => p_init_msg_list,
327: p_validation_level => p_validation_level,

Line 380: FROM csi_ii_relationships

376: -- Check if relationships is already been built then allow update
377: BEGIN
378: SELECT 'Y'
379: INTO l_relationship_exists
380: FROM csi_ii_relationships
381: WHERE relationship_type_code = 'COMPONENT-OF'
382: AND nvl(active_end_date, sysdate + 1) >= sysdate
383: AND (object_id = p_relationship_tbl(l_count).object_id OR
384: subject_id = p_relationship_tbl(l_count).object_id);

Line 398: l_root_asset_id :=csi_ii_relationships_pvt.Get_Root_Parent(p_relationship_tbl(l_count).subject_id,

394: csi_gen_utility_pvt.put_line('The Subject Id '||p_relationship_tbl(l_count).subject_id);
395: csi_gen_utility_pvt.put_line('The Object Id '||p_relationship_tbl(l_count).object_id);
396: csi_gen_utility_pvt.put_line('The relationship_type_code '||p_relationship_tbl(l_count).relationship_type_code);
397:
398: l_root_asset_id :=csi_ii_relationships_pvt.Get_Root_Parent(p_relationship_tbl(l_count).subject_id,
399: p_relationship_tbl(l_count).relationship_type_code,
400: p_relationship_tbl(l_count).object_id);
401: END IF;
402: CSI_BUSINESS_EVENT_PVT.CREATE_INSTANCE_EVENT

Line 640: csi_ii_relationships_pvt.update_relationship(

636: l_rel_tbl.delete;
637: l_rel_tbl(1):=l_relationship_tbl(l_count);
638: csi_gen_utility_pvt.put_line('Value of relationship_id is : '||l_rel_tbl(1).relationship_id);
639: csi_gen_utility_pvt.put_line('Value of replace_flag is :'||l_replace_flag);
640: csi_ii_relationships_pvt.update_relationship(
641: p_api_version => p_api_version,
642: p_commit => fnd_api.g_false,
643: p_init_msg_list => p_init_msg_list,
644: p_validation_level => p_validation_level,

Line 664: csi_gen_utility_pvt.put_line( ' Error from csi_ii_relationships_pvt.update_relationship..');

660: WHILE l_msg_count > 0 LOOP
661: x_msg_data := FND_MSG_PUB.GET
662: ( l_msg_index,
663: FND_API.G_FALSE );
664: csi_gen_utility_pvt.put_line( ' Error from csi_ii_relationships_pvt.update_relationship..');
665: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
666: l_msg_index := l_msg_index + 1;
667: l_msg_count := l_msg_count - 1;
668: END LOOP;

Line 682: csi_ii_relationships_pvt.create_relationship(

678: x_return_status = FND_API.G_RET_STS_SUCCESS
679: THEN
680: l_rel_tbl.delete;
681: l_rel_tbl(1):=l_relationship_tbl(l_count);
682: csi_ii_relationships_pvt.create_relationship(
683: p_api_version => p_api_version,
684: p_commit => fnd_api.g_false,
685: p_init_msg_list => p_init_msg_list,
686: p_validation_level => p_validation_level,

Line 704: csi_gen_utility_pvt.put_line( ' Error from csi_ii_relationships_pvt.create_relationship..');

700: LOOP
701: x_msg_data := FND_MSG_PUB.GET
702: ( l_msg_index,
703: FND_API.G_FALSE );
704: csi_gen_utility_pvt.put_line( ' Error from csi_ii_relationships_pvt.create_relationship..');
705: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
706: l_msg_index := l_msg_index + 1;
707: l_msg_count := l_msg_count - 1;
708: END LOOP;

Line 878: csi_ii_relationships_pvt.expire_relationship(

874: l_flag:=csi_gen_utility_pvt.enable_trace(l_trace_flag => l_flag);
875: -- END enable trace
876: *****/
877:
878: csi_ii_relationships_pvt.expire_relationship(
879: p_api_version => p_api_version,
880: p_commit => fnd_api.g_false,
881: p_init_msg_list => p_init_msg_list,
882: p_validation_level => p_validation_level,

Line 952: END csi_ii_relationships_pub;

948: END expire_relationship;
949:
950:
951:
952: END csi_ii_relationships_pub;