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.CS_KB_SET_LINKS_PKG dependencies on CS_KB_SET_LINKS

Line 1: PACKAGE BODY CS_KB_SET_LINKS_PKG AS

1: PACKAGE BODY CS_KB_SET_LINKS_PKG AS
2: /* $Header: cskbslb.pls 120.1 2005/07/27 19:05:29 appldev ship $ */
3:
4: --
5: -- Clone_link is to duplicate all data with previous verion set_id to new set_id

Line 17: select * from cs_kb_set_links

13: l_count number;
14: l_id number;
15: l_rowid varchar2(30);
16: cursor l_link_csr is
17: select * from cs_kb_set_links
18: where set_id = p_set_source_id;
19: BEGIN
20: -- Validate Set Id
21: select count(*) into l_count

Line 33: select cs_kb_set_links_s.nextval into l_id from dual;

29:
30: -- Copying data with previous set id to new set_id.
31: for rec_link in l_link_csr loop
32: -- dtian: use table handler instead
33: select cs_kb_set_links_s.nextval into l_id from dual;
34:
35: CS_KB_SET_LINKS_PKG.Insert_Row(
36: X_Rowid => l_rowid,
37: X_Link_Id => l_id,

Line 35: CS_KB_SET_LINKS_PKG.Insert_Row(

31: for rec_link in l_link_csr loop
32: -- dtian: use table handler instead
33: select cs_kb_set_links_s.nextval into l_id from dual;
34:
35: CS_KB_SET_LINKS_PKG.Insert_Row(
36: X_Rowid => l_rowid,
37: X_Link_Id => l_id,
38: X_Link_type => REC_LINK.LINK_TYPE,
39: X_Object_Code => REC_LINK.OBJECT_CODE,

Line 138: FROM CS_KB_SET_LINKS

134: l_ext_obj_count NUMBER;
135:
136: CURSOR Check_Duplicate IS
137: SELECT count(*)
138: FROM CS_KB_SET_LINKS
139: WHERE set_id = P_SET_ID
140: AND other_id = P_OTHER_ID
141: AND object_code = P_OBJECT_CODE;
142:

Line 170: FROM CS_KB_SET_LINKS

166: -- from a particular object
167: CURSOR Count_Links_to_Soln_Ver(c_soln_id NUMBER, c_object_code VARCHAR2,
168: c_other_id NUMBER) IS
169: SELECT count(*)
170: FROM CS_KB_SET_LINKS
171: WHERE set_id = c_soln_id
172: AND object_code = c_object_code
173: AND other_id = c_other_id;
174:

Line 274: select cs_kb_set_links_s.nextval into l_id from dual;

270: -- End of Validation
271:
272: --prepare data, then insert new set link
273: IF( x_link_id is null ) THEN
274: select cs_kb_set_links_s.nextval into l_id from dual;
275: ELSE
276: l_id := x_link_id;
277: END IF;
278:

Line 283: CS_KB_SET_LINKS_PKG.Insert_Row(

279: l_date := sysdate;
280: l_created_by := fnd_global.user_id;
281: l_login := fnd_global.login_id;
282:
283: CS_KB_SET_LINKS_PKG.Insert_Row(
284: X_Rowid => l_rowid,
285: X_Link_Id => l_id,
286: X_Link_type => p_link_type,
287: X_Object_Code => p_object_code,

Line 314: CS_KB_SET_LINKS_PKG.Raise_Solution_Linked_Event(

310: X_ATTRIBUTE15 => P_ATTRIBUTE15
311: );
312:
313: -- Raise Business Event when a solution is linked
314: CS_KB_SET_LINKS_PKG.Raise_Solution_Linked_Event(
315: p_set_id => p_set_id,
316: p_object_code => p_object_code,
317: p_object_id => p_other_id,
318: p_link_id => l_id,

Line 359: select cs_kb_set_links_s.nextval into l_other_link_id from dual;

355: p_other_id);
356: FETCH Count_Links_to_Soln_Ver into l_links_to_soln_ver_ct;
357: CLOSE Count_Links_to_Soln_Ver;
358: IF ( l_links_to_soln_ver_ct = 0 ) THEN
359: select cs_kb_set_links_s.nextval into l_other_link_id from dual;
360: CS_KB_SET_LINKS_PKG.Insert_Row(
361: X_Rowid => l_other_rowid,
362: X_Link_Id => l_other_link_id,
363: X_Link_type => p_link_type,

Line 360: CS_KB_SET_LINKS_PKG.Insert_Row(

356: FETCH Count_Links_to_Soln_Ver into l_links_to_soln_ver_ct;
357: CLOSE Count_Links_to_Soln_Ver;
358: IF ( l_links_to_soln_ver_ct = 0 ) THEN
359: select cs_kb_set_links_s.nextval into l_other_link_id from dual;
360: CS_KB_SET_LINKS_PKG.Insert_Row(
361: X_Rowid => l_other_rowid,
362: X_Link_Id => l_other_link_id,
363: X_Link_type => p_link_type,
364: X_Object_Code => p_object_code,

Line 401: fnd_log.string(fnd_log.LEVEL_UNEXPECTED, 'cs.plsql.cs_kb_set_links.create_set_link', SQLERRM );

397: WHEN OTHERS THEN
398: --dbms_output.put_line('in csl when others ');
399: ROLLBACK TO Create_Link_SP;
400: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
401: fnd_log.string(fnd_log.LEVEL_UNEXPECTED, 'cs.plsql.cs_kb_set_links.create_set_link', SQLERRM );
402: end if;
403: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');
404: FND_MSG_PUB.Add;
405: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 687: FROM CS_KB_SET_LINKS sl, CS_KB_SETS_B sb

683:
684: -- Validation Cursors
685: CURSOR Validate_Link IS
686: SELECT sl.set_id, sl.object_code, sl.other_id, sb.set_number, sb.status
687: FROM CS_KB_SET_LINKS sl, CS_KB_SETS_B sb
688: WHERE sl.link_id = P_LINK_ID
689: AND sl.set_id = sb.set_id
690: AND ( sb.status = 'PUB' OR sb.latest_version_flag = 'Y' );
691:

Line 696: FROM CS_KB_SET_LINKS sl, CS_KB_SETS_B sb

692: -- Cursor to fetch link to latest in-progress version of a solution
693: CURSOR Get_Link_To_Latest_Ver(c_soln_number VARCHAR2, c_object_code VARCHAR2,
694: c_other_id NUMBER) IS
695: SELECT sl.link_id, sl.set_id
696: FROM CS_KB_SET_LINKS sl, CS_KB_SETS_B sb
697: WHERE sb.set_number = c_soln_number
698: AND sb.latest_version_flag = 'Y'
699: AND sb.set_id = sl.set_id
700: AND sl.object_code = c_object_code

Line 707: FROM CS_KB_SET_LINKS sl, CS_KB_SETS_B sb

703: -- Cursor to fetch link to published version of a solution
704: CURSOR Get_Link_To_Published_Ver(c_soln_number VARCHAR2, c_object_code VARCHAR2,
705: c_other_id NUMBER) IS
706: SELECT sl.link_id, sl.set_id
707: FROM CS_KB_SET_LINKS sl, CS_KB_SETS_B sb
708: WHERE sb.set_number = c_soln_number
709: AND sb.status = 'PUB'
710: AND sb.set_id = sl.set_id
711: AND sl.object_code = c_object_code

Line 795: CS_KB_SET_LINKS_PKG.Update_Row(

791: l_date := sysdate;
792: l_updated_by := fnd_global.user_id;
793: l_login := fnd_global.login_id;
794:
795: CS_KB_SET_LINKS_PKG.Update_Row(
796: X_Link_Id => p_link_id,
797: X_Link_type => p_link_type,
798: X_Object_Code => p_object_code,
799: X_Set_Id => p_set_id,

Line 822: CS_KB_SET_LINKS_PKG.Raise_Soln_Link_Updated_Event(

818: X_ATTRIBUTE14 => P_ATTRIBUTE14,
819: X_ATTRIBUTE15 => P_ATTRIBUTE15);
820:
821: -- Raise Business Event when a solution link is updated
822: CS_KB_SET_LINKS_PKG.Raise_Soln_Link_Updated_Event(
823: p_set_id => p_set_id,
824: p_object_code => p_object_code,
825: p_object_id => p_other_id,
826: p_link_id => p_link_id,

Line 854: CS_KB_SET_LINKS_PKG.Update_Row(

850: CLOSE Get_Link_To_Published_Ver;
851: END IF;
852: IF ( l_other_link_id is not null
853: and l_other_link_id <> p_link_id ) THEN
854: CS_KB_SET_LINKS_PKG.Update_Row(
855: X_Link_Id => l_other_link_id,
856: X_Link_type => p_link_type,
857: X_Object_Code => p_object_code,
858: X_Set_Id => l_other_soln_id,

Line 886: fnd_log.string(fnd_log.LEVEL_UNEXPECTED, 'cs.plsql.cs_kb_set_links.update_set_link', SQLERRM );

882: exception
883: when others then
884: ROLLBACK TO Update_Link_SP;
885: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
886: fnd_log.string(fnd_log.LEVEL_UNEXPECTED, 'cs.plsql.cs_kb_set_links.update_set_link', SQLERRM );
887: end if;
888: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');
889: FND_MSG_PUB.Add;
890: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 964: from cs_kb_set_links

960: ) return number is
961: cursor get_link_id( c_set_id NUMBER, c_object_code VARCHAR2,
962: c_other_id NUMBER )IS
963: select link_id
964: from cs_kb_set_links
965: where set_id = c_set_id
966: and object_code = c_object_code
967: and other_id = c_other_id;
968:

Line 1005: from cs_kb_set_links sl, cs_kb_sets_b sb

1001: -- Cursor to validate link exists and is to either a published solution
1002: -- version or an in-progress version.
1003: cursor Valid_Link IS
1004: select sb.set_number, sb.status, sl.object_code, sl.other_id
1005: from cs_kb_set_links sl, cs_kb_sets_b sb
1006: where sl.link_id = P_LINK_ID
1007: and sl.set_id = sb.set_id
1008: and ( sb.status = 'PUB' or sb.latest_version_flag = 'Y' );
1009:

Line 1014: FROM CS_KB_SET_LINKS sl, CS_KB_SETS_B sb

1010: -- Cursor to fetch link to latest in-progress version of a solution
1011: CURSOR Get_Link_To_Other_Ver(c_soln_number VARCHAR2, c_object_code VARCHAR2,
1012: c_other_id NUMBER) IS
1013: SELECT sl.link_id
1014: FROM CS_KB_SET_LINKS sl, CS_KB_SETS_B sb
1015: WHERE sb.set_number = c_soln_number
1016: AND (sb.latest_version_flag = 'Y' or sb.status = 'PUB')
1017: AND sb.set_id = sl.set_id
1018: AND sl.object_code = c_object_code

Line 1057: delete from CS_KB_SET_LINKS

1053: CLOSE Valid_Link;
1054:
1055: -- End Validation
1056:
1057: delete from CS_KB_SET_LINKS
1058: where LINK_ID = P_LINK_ID;
1059:
1060: -- If the link being deleted is to the published version of a solution,
1061: -- see if there is a corresponding link to the latest in-progress version.

Line 1076: delete from CS_KB_SET_LINKS

1072:
1073: -- The link which link id is P_LINK_ID is already deleted. l_link_other_id is
1074: -- not null, then it must be the extra verion to be deleted.
1075: IF ( l_other_link_id is not null) THEN
1076: delete from CS_KB_SET_LINKS
1077: where LINK_ID = l_other_link_id;
1078: END IF;
1079:
1080: return OKAY_STATUS;

Line 1085: fnd_log.string(fnd_log.LEVEL_UNEXPECTED, 'cs.plsql.cs_kb_set_links.delete_set_link', SQLERRM );

1081: EXCEPTION
1082: WHEN OTHERS THEN
1083: ROLLBACK TO Delete_Link_SP;
1084: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1085: fnd_log.string(fnd_log.LEVEL_UNEXPECTED, 'cs.plsql.cs_kb_set_links.delete_set_link', SQLERRM );
1086: end if;
1087: if fnd_msg_pub.Check_Msg_Level( fnd_msg_pub.G_MSG_LVL_ERROR) then
1088: FND_MESSAGE.set_name('CS', 'CS_KB_C_UNEXP_ERR');
1089: FND_MSG_PUB.Add;

Line 1124: cursor C is select ROWID from CS_KB_SET_LINKS where LINK_ID = X_LINK_ID;

1120: X_ATTRIBUTE13 in VARCHAR2,
1121: X_ATTRIBUTE14 in VARCHAR2,
1122: X_ATTRIBUTE15 in VARCHAR2) IS
1123:
1124: cursor C is select ROWID from CS_KB_SET_LINKS where LINK_ID = X_LINK_ID;
1125:
1126:
1127: BEGIN
1128:

Line 1130: insert into CS_KB_SET_LINKS (

1126:
1127: BEGIN
1128:
1129:
1130: insert into CS_KB_SET_LINKS (
1131: LINK_ID,
1132: LINK_TYPE,
1133: OBJECT_CODE,
1134: SET_ID,

Line 1230: update CS_KB_SET_LINKS set

1226: ) IS
1227:
1228: BEGIN
1229:
1230: update CS_KB_SET_LINKS set
1231:
1232: LINK_TYPE = X_LINK_TYPE,
1233: OBJECT_CODE = X_OBJECT_CODE,
1234: SET_ID = X_SET_ID,

Line 1451: end CS_KB_SET_LINKS_PKG;

1447:
1448: end Raise_Soln_Link_Updated_Event;
1449:
1450:
1451: end CS_KB_SET_LINKS_PKG;