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_SOLUTION_PVT dependencies on CS_KB_SETS_B

Line 58: FROM CS_KB_SETS_B

54: BEGIN
55:
56: SELECT set_number, status, flow_details_id, locked_by
57: INTO X_SET_NUMBER, X_STATUS, X_FLOW_DETAILS_ID, X_LOCKED_BY
58: FROM CS_KB_SETS_B
59: WHERE set_id = p_set_id;
60:
61: END Get_Set_Details;
62:

Line 74: FROM CS_KB_SETS_B

70: BEGIN
71:
72: SELECT set_number
73: INTO l_set_number
74: FROM CS_KB_SETS_B
75: WHERE set_id = p_set_id;
76:
77: RETURN l_set_number;
78:

Line 89: FROM CS_KB_SETS_B

85: l_max_set_id NUMBER;
86:
87: CURSOR Get_Latest IS
88: SELECT set_id
89: FROM CS_KB_SETS_B
90: WHERE set_number = p_set_number
91: AND latest_version_flag = 'Y';
92:
93: BEGIN

Line 114: FROM CS_KB_SETS_B

110: BEGIN
111:
112: SELECT MAX(set_id)
113: INTO l_published_set_id
114: FROM CS_KB_SETS_B
115: WHERE set_number = p_set_number
116: AND status = 'PUB';
117:
118: IF (SQL%NOTFOUND) THEN RAISE NO_DATA_FOUND; END IF;

Line 139: FROM CS_KB_SETS_B

135: BEGIN
136:
137: SELECT MAX(set_id)
138: INTO l_obsoleted_set_id
139: FROM CS_KB_SETS_B
140: WHERE set_number = p_set_number
141: AND status = 'OBS';
142:
143: IF (SQL%NOTFOUND) THEN RAISE NO_DATA_FOUND; END IF;

Line 178: FROM CS_KB_SETS_B

174: IS
175: BEGIN
176: SELECT locked_by, lock_date
177: INTO X_LOCKED_BY, X_LOCK_DATE
178: FROM CS_KB_SETS_B
179: WHERE set_id = Get_Latest_Version_Id(p_set_number);
180: END Get_Lock_Info;
181:
182: PROCEDURE Set_Lock_Info(

Line 189: UPDATE CS_KB_SETS_B

185: P_LOCK_DATE IN DATE )
186: IS
187: BEGIN
188:
189: UPDATE CS_KB_SETS_B
190: SET locked_by = P_LOCKED_BY,
191: lock_date = P_LOCK_DATE
192: WHERE set_id = P_SET_ID;
193:

Line 221: FROM CS_KB_SETS_B

217: BEGIN
218:
219: SELECT locked_by
220: INTO l_locked_by
221: FROM CS_KB_SETS_B
222: WHERE set_id = P_SET_ID;
223:
224: RETURN l_locked_by;
225:

Line 247: FROM CS_KB_SETS_B

243: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
244:
245: SELECT locked_by
246: INTO l_locked_by
247: FROM CS_KB_SETS_B
248: WHERE set_id = P_SET_ID FOR UPDATE;
249:
250: l_latest_set_id := Get_Latest_Version_Id(P_SET_NUMBER);
251:

Line 257: UPDATE CS_KB_SETS_B

253: -- and if there is no other new version for this solution
254:
255: IF ( (l_locked_by = P_LOCKED_BY) AND (l_latest_set_id = P_SET_ID) )
256: THEN
257: UPDATE CS_KB_SETS_B
258: SET locked_by = P_USER_ID
259: WHERE set_id = P_SET_ID;
260:
261: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

Line 288: UPDATE CS_KB_SETS_B

284: P_SET_NUMBER IN VARCHAR2)
285: IS
286: BEGIN
287:
288: UPDATE CS_KB_SETS_B
289: SET locked_by = NULL
290: WHERE set_number = p_set_number;
291:
292: EXCEPTION

Line 308: UPDATE CS_KB_SETS_B

304:
305:
306: BEGIN
307:
308: UPDATE CS_KB_SETS_B
309: SET status = P_STATUS
310: WHERE set_id = P_SET_ID;
311:
312: END Update_Status;

Line 336: UPDATE CS_KB_SETS_B

332: P_SET_NUMBER IN VARCHAR2,
333: P_CURRENT_SET_ID IN NUMBER )
334: IS
335: BEGIN
336: UPDATE CS_KB_SETS_B
337: SET status = 'OUT',
338: --viewable_version_flag = 'N'
339: viewable_version_flag = null
340: WHERE set_number = P_SET_NUMBER

Line 364: b_rec CS_KB_SETS_B%ROWTYPE;

360: l_new_set_id NUMBER;
361: l_SYSDATE DATE;
362: l_user_id NUMBER;
363: l_login_id NUMBER;
364: b_rec CS_KB_SETS_B%ROWTYPE;
365: l_dummy_rowid VARCHAR2(30);
366:
367: CURSOR get_tl_rows( v_set_id IN NUMBER) IS
368: SELECT language,

Line 382: FROM CS_KB_SETS_B

378: BEGIN
379: l_old_set_id := P_ORIG_SET_ID; --Get_Latest_Version_Id(p_set_number);
380:
381: SELECT * INTO b_rec
382: FROM CS_KB_SETS_B
383: WHERE set_id = l_old_set_id;
384:
385: Get_Who(l_SYSDATE, l_user_id, l_login_id);
386:

Line 387: UPDATE CS_KB_SETS_B

383: WHERE set_id = l_old_set_id;
384:
385: Get_Who(l_SYSDATE, l_user_id, l_login_id);
386:
387: UPDATE CS_KB_SETS_B
388: SET LATEST_VERSION_FLAG = null --'N'
389: WHERE SET_NUMBER = b_rec.set_number
390: AND SET_ID = l_old_set_id;
391:

Line 393: INSERT INTO CS_KB_SETS_B (

389: WHERE SET_NUMBER = b_rec.set_number
390: AND SET_ID = l_old_set_id;
391:
392:
393: INSERT INTO CS_KB_SETS_B (
394: set_id,
395: set_number,
396: set_type_id,
397: status,

Line 470: UPDATE CS_KB_SETS_B

466: RETURNING SET_ID INTO l_new_set_id;
467:
468: -- 17-Dec-2003 Perf change - Use DML Returning
469:
470: UPDATE CS_KB_SETS_B
471: SET VIEWABLE_VERSION_FLAG = decode(status, 'PUB','Y',null)
472: WHERE SET_NUMBER = b_rec.set_number;
473:
474: UPDATE CS_KB_SETS_B s

Line 474: UPDATE CS_KB_SETS_B s

470: UPDATE CS_KB_SETS_B
471: SET VIEWABLE_VERSION_FLAG = decode(status, 'PUB','Y',null)
472: WHERE SET_NUMBER = b_rec.set_number;
473:
474: UPDATE CS_KB_SETS_B s
475: SET s.VIEWABLE_VERSION_FLAG = 'Y'
476: WHERE s.SET_NUMBER = b_rec.set_number
477: AND s.STATUS <> 'OBS'
478: AND s.LATEST_VERSION_FLAG = 'Y'

Line 480: FROM CS_KB_SETS_B s3

476: WHERE s.SET_NUMBER = b_rec.set_number
477: AND s.STATUS <> 'OBS'
478: AND s.LATEST_VERSION_FLAG = 'Y'
479: AND NOT EXISTS (SELECT 'x'
480: FROM CS_KB_SETS_B s3
481: WHERE s3.set_number = s.set_number
482: AND s3.STATUS = 'PUB');
483:
484: FOR tl_rec IN get_tl_rows(l_old_set_id) LOOP

Line 843: FROM CS_KB_SETS_B

839:
840: SELECT TO_CHAR(CS_KB_SET_NUMBER_S.NEXTVAL) INTO x_set_number FROM DUAL;
841: LOOP
842: SELECT COUNT(set_number) INTO l_count
843: FROM CS_KB_SETS_B
844: WHERE set_number = x_set_number;
845: EXIT WHEN l_count = 0;
846: SELECT TO_CHAR(CS_KB_SET_NUMBER_S.NEXTVAL) INTO x_set_number FROM DUAL;
847: END LOOP;

Line 906: UPDATE CS_KB_SETS_B

902: x_visibility_id => p_visibility_id );
903:
904: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
905:
906: UPDATE CS_KB_SETS_B
907: SET LATEST_VERSION_FLAG = null --'N'
908: WHERE SET_NUMBER = x_set_number
909: AND SET_ID <> x_set_id;
910:

Line 911: UPDATE CS_KB_SETS_B

907: SET LATEST_VERSION_FLAG = null --'N'
908: WHERE SET_NUMBER = x_set_number
909: AND SET_ID <> x_set_id;
910:
911: UPDATE CS_KB_SETS_B
912: SET VIEWABLE_VERSION_FLAG = decode(status, 'PUB','Y',null) --'N')
913: WHERE SET_NUMBER = x_set_number;
914:
915: -- BugFix 4013998 - Sequence Id Fix

Line 916: UPDATE CS_KB_SETS_B s

912: SET VIEWABLE_VERSION_FLAG = decode(status, 'PUB','Y',null) --'N')
913: WHERE SET_NUMBER = x_set_number;
914:
915: -- BugFix 4013998 - Sequence Id Fix
916: UPDATE CS_KB_SETS_B s
917: SET s.VIEWABLE_VERSION_FLAG = 'Y'
918: WHERE s.SET_NUMBER = x_set_number
919: AND s.STATUS <> 'OBS'
920: AND s.latest_version_flag = 'Y'

Line 922: FROM CS_KB_SETS_B s3

918: WHERE s.SET_NUMBER = x_set_number
919: AND s.STATUS <> 'OBS'
920: AND s.latest_version_flag = 'Y'
921: AND NOT EXISTS (SELECT 'x'
922: FROM CS_KB_SETS_B s3
923: WHERE s3.set_number = s.set_number
924: AND s3.STATUS = 'PUB');
925:
926: END IF;

Line 994: select 'x' from CS_KB_SETS_B

990: and trunc(sysdate) between trunc(nvl(start_date_active, sysdate))
991: and trunc(nvl(end_date_active, sysdate));
992:
993: Cursor validate_old_type_used_csr(p_type_id IN NUMBER, p_set_id IN NUMBER) Is
994: select 'x' from CS_KB_SETS_B
995: where set_id = p_set_id
996: and set_type_id = p_type_id;
997:
998: Cursor Check_Visibility IS

Line 1326: FROM CS_KB_SETS_B

1322:
1323: -- Changed to use lvf, removed select max
1324: CURSOR Get_Latest_Soln_From_Id IS
1325: SELECT Set_Id
1326: FROM CS_KB_SETS_B
1327: WHERE Set_Number = (SELECT Set_Number
1328: FROM CS_KB_SETS_B
1329: WHERE Set_Id = P_SET_ID)
1330: AND latest_version_flag = 'Y';

Line 1328: FROM CS_KB_SETS_B

1324: CURSOR Get_Latest_Soln_From_Id IS
1325: SELECT Set_Id
1326: FROM CS_KB_SETS_B
1327: WHERE Set_Number = (SELECT Set_Number
1328: FROM CS_KB_SETS_B
1329: WHERE Set_Id = P_SET_ID)
1330: AND latest_version_flag = 'Y';
1331:
1332: -- Changed to use lvf, removed select max

Line 1335: FROM CS_KB_SETS_B

1331:
1332: -- Changed to use lvf, removed select max
1333: CURSOR Get_Latest_Soln_From_Num IS
1334: SELECT Set_Id
1335: FROM CS_KB_SETS_B
1336: WHERE Set_Number = P_SET_NUMBER
1337: AND latest_version_flag = 'Y';
1338:
1339: CURSOR Get_Soln_Attributes (v_set_id NUMBER) IS

Line 1341: FROM CS_KB_SETS_B

1337: AND latest_version_flag = 'Y';
1338:
1339: CURSOR Get_Soln_Attributes (v_set_id NUMBER) IS
1340: SELECT Status, locked_by, flow_details_id
1341: FROM CS_KB_SETS_B
1342: WHERE Set_Id = v_set_id;
1343:
1344: l_default_user NUMBER := -1;
1345: l_current_user NUMBER := FND_GLOBAL.user_id;

Line 1476: FROM CS_KB_SETS_B

1472: IS
1473:
1474: CURSOR Get_Soln_Attributes (v_set_id NUMBER) IS
1475: SELECT Status, locked_by
1476: FROM CS_KB_SETS_B
1477: WHERE Set_Id = v_set_id;
1478:
1479: l_current_user NUMBER := FND_GLOBAL.user_id;
1480: l_locked_by NUMBER;

Line 1729: FROM cs_kb_sets_b

1725: SAVEPOINT CS_KB_ULOCK_SOLUTION;
1726:
1727: SELECT set_number
1728: INTO l_set_number
1729: FROM cs_kb_sets_b
1730: WHERE set_id = p_set_id;
1731:
1732: SELECT
1733: COUNT(*)

Line 1737: cs_kb_sets_b

1733: COUNT(*)
1734: INTO
1735: l_pub_count
1736: FROM
1737: cs_kb_sets_b
1738: WHERE
1739: status = 'PUB' AND
1740: set_number = l_set_number;
1741:

Line 1743: SELECT status INTO l_current_status FROM cs_kb_sets_b WHERE set_id = p_set_id;

1739: status = 'PUB' AND
1740: set_number = l_set_number;
1741:
1742: IF l_pub_count > 0 THEN
1743: SELECT status INTO l_current_status FROM cs_kb_sets_b WHERE set_id = p_set_id;
1744: IF l_current_status = 'NOT' THEN
1745: UPDATE CS_KB_SETS_B SET locked_by = - 1 WHERE set_id = p_set_id;
1746: ELSIF l_current_status = 'SAV' THEN
1747: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments(

Line 1745: UPDATE CS_KB_SETS_B SET locked_by = - 1 WHERE set_id = p_set_id;

1741:
1742: IF l_pub_count > 0 THEN
1743: SELECT status INTO l_current_status FROM cs_kb_sets_b WHERE set_id = p_set_id;
1744: IF l_current_status = 'NOT' THEN
1745: UPDATE CS_KB_SETS_B SET locked_by = - 1 WHERE set_id = p_set_id;
1746: ELSIF l_current_status = 'SAV' THEN
1747: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments(
1748: x_entity_name => 'CS_KB_SETS_B',
1749: x_pk1_value => TO_CHAR(p_set_id),

Line 1748: x_entity_name => 'CS_KB_SETS_B',

1744: IF l_current_status = 'NOT' THEN
1745: UPDATE CS_KB_SETS_B SET locked_by = - 1 WHERE set_id = p_set_id;
1746: ELSIF l_current_status = 'SAV' THEN
1747: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments(
1748: x_entity_name => 'CS_KB_SETS_B',
1749: x_pk1_value => TO_CHAR(p_set_id),
1750: x_delete_document_flag => 'Y'
1751: ) ;
1752: DELETE FROM CS_KB_SET_CATEGORIES WHERE set_id = p_set_id;

Line 1759: CS_KB_SETS_B

1755: DELETE FROM CS_KB_SET_LINKS WHERE set_id = p_set_id;
1756: DELETE FROM CS_KB_SET_ELES WHERE set_id = p_set_id;
1757: DELETE FROM CS_KB_SETS_TL WHERE set_id = p_set_id;
1758: UPDATE
1759: CS_KB_SETS_B
1760: SET
1761: latest_version_flag = 'Y'
1762: WHERE
1763: status = 'PUB' AND

Line 1765: DELETE FROM CS_KB_SETS_B WHERE set_id = p_set_id;

1761: latest_version_flag = 'Y'
1762: WHERE
1763: status = 'PUB' AND
1764: set_number = l_set_number;
1765: DELETE FROM CS_KB_SETS_B WHERE set_id = p_set_id;
1766: END IF;
1767: IF p_commit = 'Y' THEN
1768: COMMIT;
1769: END IF;