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 60: FROM CS_KB_SETS_B

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

Line 76: FROM CS_KB_SETS_B

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

Line 91: FROM CS_KB_SETS_B

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

Line 116: FROM CS_KB_SETS_B

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

Line 141: FROM CS_KB_SETS_B

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

Line 180: FROM CS_KB_SETS_B

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

Line 191: UPDATE CS_KB_SETS_B

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

Line 223: FROM CS_KB_SETS_B

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

Line 249: FROM CS_KB_SETS_B

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

Line 259: UPDATE CS_KB_SETS_B

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

Line 290: UPDATE CS_KB_SETS_B

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

Line 310: UPDATE CS_KB_SETS_B

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

Line 338: UPDATE CS_KB_SETS_B

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

Line 366: b_rec CS_KB_SETS_B%ROWTYPE;

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

Line 385: FROM CS_KB_SETS_B

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

Line 390: UPDATE CS_KB_SETS_B

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

Line 396: INSERT INTO CS_KB_SETS_B (

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

Line 473: UPDATE CS_KB_SETS_B

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

Line 477: UPDATE CS_KB_SETS_B s

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

Line 483: FROM CS_KB_SETS_B s3

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

Line 857: FROM CS_KB_SETS_B

853:
854: SELECT TO_CHAR(CS_KB_SET_NUMBER_S.NEXTVAL) INTO x_set_number FROM DUAL;
855: LOOP
856: SELECT COUNT(set_number) INTO l_count
857: FROM CS_KB_SETS_B
858: WHERE set_number = x_set_number;
859: EXIT WHEN l_count = 0;
860: SELECT TO_CHAR(CS_KB_SET_NUMBER_S.NEXTVAL) INTO x_set_number FROM DUAL;
861: END LOOP;

Line 920: UPDATE CS_KB_SETS_B

916: x_visibility_id => p_visibility_id );
917:
918: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
919:
920: UPDATE CS_KB_SETS_B
921: SET LATEST_VERSION_FLAG = null --'N'
922: WHERE SET_NUMBER = x_set_number
923: AND SET_ID <> x_set_id;
924:

Line 925: UPDATE CS_KB_SETS_B

921: SET LATEST_VERSION_FLAG = null --'N'
922: WHERE SET_NUMBER = x_set_number
923: AND SET_ID <> x_set_id;
924:
925: UPDATE CS_KB_SETS_B
926: SET VIEWABLE_VERSION_FLAG = decode(status, 'PUB','Y',null) --'N')
927: WHERE SET_NUMBER = x_set_number;
928:
929: -- BugFix 4013998 - Sequence Id Fix

Line 930: UPDATE CS_KB_SETS_B s

926: SET VIEWABLE_VERSION_FLAG = decode(status, 'PUB','Y',null) --'N')
927: WHERE SET_NUMBER = x_set_number;
928:
929: -- BugFix 4013998 - Sequence Id Fix
930: UPDATE CS_KB_SETS_B s
931: SET s.VIEWABLE_VERSION_FLAG = 'Y'
932: WHERE s.SET_NUMBER = x_set_number
933: AND s.STATUS <> 'OBS'
934: AND s.latest_version_flag = 'Y'

Line 936: FROM CS_KB_SETS_B s3

932: WHERE s.SET_NUMBER = x_set_number
933: AND s.STATUS <> 'OBS'
934: AND s.latest_version_flag = 'Y'
935: AND NOT EXISTS (SELECT 'x'
936: FROM CS_KB_SETS_B s3
937: WHERE s3.set_number = s.set_number
938: AND s3.STATUS = 'PUB');
939:
940: END IF;

Line 1008: select 'x' from CS_KB_SETS_B

1004: and trunc(sysdate) between trunc(nvl(start_date_active, sysdate))
1005: and trunc(nvl(end_date_active, sysdate));
1006:
1007: Cursor validate_old_type_used_csr(p_type_id IN NUMBER, p_set_id IN NUMBER) Is
1008: select 'x' from CS_KB_SETS_B
1009: where set_id = p_set_id
1010: and set_type_id = p_type_id;
1011:
1012: Cursor Check_Visibility IS

Line 1340: FROM CS_KB_SETS_B

1336:
1337: -- Changed to use lvf, removed select max
1338: CURSOR Get_Latest_Soln_From_Id IS
1339: SELECT Set_Id
1340: FROM CS_KB_SETS_B
1341: WHERE Set_Number = (SELECT Set_Number
1342: FROM CS_KB_SETS_B
1343: WHERE Set_Id = P_SET_ID)
1344: AND latest_version_flag = 'Y';

Line 1342: FROM CS_KB_SETS_B

1338: CURSOR Get_Latest_Soln_From_Id IS
1339: SELECT Set_Id
1340: FROM CS_KB_SETS_B
1341: WHERE Set_Number = (SELECT Set_Number
1342: FROM CS_KB_SETS_B
1343: WHERE Set_Id = P_SET_ID)
1344: AND latest_version_flag = 'Y';
1345:
1346: -- Changed to use lvf, removed select max

Line 1349: FROM CS_KB_SETS_B

1345:
1346: -- Changed to use lvf, removed select max
1347: CURSOR Get_Latest_Soln_From_Num IS
1348: SELECT Set_Id
1349: FROM CS_KB_SETS_B
1350: WHERE Set_Number = P_SET_NUMBER
1351: AND latest_version_flag = 'Y';
1352:
1353: CURSOR Get_Soln_Attributes (v_set_id NUMBER) IS

Line 1355: FROM CS_KB_SETS_B

1351: AND latest_version_flag = 'Y';
1352:
1353: CURSOR Get_Soln_Attributes (v_set_id NUMBER) IS
1354: SELECT Status, locked_by, flow_details_id
1355: FROM CS_KB_SETS_B
1356: WHERE Set_Id = v_set_id;
1357:
1358: l_default_user NUMBER := -1;
1359: l_current_user NUMBER := FND_GLOBAL.user_id;

Line 1490: FROM CS_KB_SETS_B

1486: IS
1487:
1488: CURSOR Get_Soln_Attributes (v_set_id NUMBER) IS
1489: SELECT Status, locked_by
1490: FROM CS_KB_SETS_B
1491: WHERE Set_Id = v_set_id;
1492:
1493: l_current_user NUMBER := FND_GLOBAL.user_id;
1494: l_locked_by NUMBER;

Line 1743: FROM cs_kb_sets_b

1739: SAVEPOINT CS_KB_ULOCK_SOLUTION;
1740:
1741: SELECT set_number
1742: INTO l_set_number
1743: FROM cs_kb_sets_b
1744: WHERE set_id = p_set_id;
1745:
1746: SELECT
1747: COUNT(*)

Line 1751: cs_kb_sets_b

1747: COUNT(*)
1748: INTO
1749: l_pub_count
1750: FROM
1751: cs_kb_sets_b
1752: WHERE
1753: status = 'PUB' AND
1754: set_number = l_set_number;
1755:

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

1753: status = 'PUB' AND
1754: set_number = l_set_number;
1755:
1756: IF l_pub_count > 0 THEN
1757: SELECT status INTO l_current_status FROM cs_kb_sets_b WHERE set_id = p_set_id;
1758: IF l_current_status = 'NOT' THEN
1759: UPDATE CS_KB_SETS_B SET locked_by = - 1 WHERE set_id = p_set_id;
1760: ELSIF( l_current_status = 'SAV' OR l_current_status = 'REJ') THEN -- bugfix 12751807
1761: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments(

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

1755:
1756: IF l_pub_count > 0 THEN
1757: SELECT status INTO l_current_status FROM cs_kb_sets_b WHERE set_id = p_set_id;
1758: IF l_current_status = 'NOT' THEN
1759: UPDATE CS_KB_SETS_B SET locked_by = - 1 WHERE set_id = p_set_id;
1760: ELSIF( l_current_status = 'SAV' OR l_current_status = 'REJ') THEN -- bugfix 12751807
1761: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments(
1762: x_entity_name => 'CS_KB_SETS_B',
1763: x_pk1_value => TO_CHAR(p_set_id),

Line 1762: x_entity_name => 'CS_KB_SETS_B',

1758: IF l_current_status = 'NOT' THEN
1759: UPDATE CS_KB_SETS_B SET locked_by = - 1 WHERE set_id = p_set_id;
1760: ELSIF( l_current_status = 'SAV' OR l_current_status = 'REJ') THEN -- bugfix 12751807
1761: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments(
1762: x_entity_name => 'CS_KB_SETS_B',
1763: x_pk1_value => TO_CHAR(p_set_id),
1764: x_delete_document_flag => 'Y'
1765: ) ;
1766: DELETE FROM CS_KB_SET_CATEGORIES WHERE set_id = p_set_id;

Line 1773: CS_KB_SETS_B

1769: DELETE FROM CS_KB_SET_LINKS WHERE set_id = p_set_id;
1770: DELETE FROM CS_KB_SET_ELES WHERE set_id = p_set_id;
1771: DELETE FROM CS_KB_SETS_TL WHERE set_id = p_set_id;
1772: UPDATE
1773: CS_KB_SETS_B
1774: SET
1775: latest_version_flag = 'Y'
1776: WHERE
1777: status = 'PUB' AND

Line 1779: DELETE FROM CS_KB_SETS_B WHERE set_id = p_set_id;

1775: latest_version_flag = 'Y'
1776: WHERE
1777: status = 'PUB' AND
1778: set_number = l_set_number;
1779: DELETE FROM CS_KB_SETS_B WHERE set_id = p_set_id;
1780: END IF;
1781: IF p_commit = 'Y' THEN
1782: COMMIT;
1783: END IF;