[Home] [Help]
18: where set_id = p_set_source_id;
19: BEGIN
20: -- Validate Set Id
21: select count(*) into l_count
22: from cs_kb_sets_b
23: where set_id = p_set_source_id;
24: if(l_count <= 0) then
25: fnd_message.set_name('CS', 'CS_KB_C_INVALID_SET_ID');
26: fnd_msg_pub.Add;
109: l_other_rowid varchar2(30);
110: -- Validation Cursors
111: CURSOR Validate_Solution IS
112: SELECT set_number, status
113: FROM CS_KB_SETS_B
114: WHERE set_id = P_SET_ID
115: AND ( status = 'PUB' or latest_version_flag = 'Y' );
116:
117: l_set_number NUMBER;
144:
145: -- Cursor to fetch id of the latest version of a solution
146: CURSOR Get_Link_To_Latest_Ver(c_soln_number VARCHAR2) IS
147: SELECT sb.set_id
148: FROM CS_KB_SETS_B sb
149: WHERE sb.set_number = c_soln_number
150: AND sb.latest_version_flag = 'Y';
151:
152: l_latest_soln_ver_id NUMBER;
153:
154: -- Cursor to fetch id of the published version of a solution
155: CURSOR Get_Link_To_Published_Ver(c_soln_number VARCHAR2) IS
156: SELECT sb.set_id
157: FROM CS_KB_SETS_B sb
158: WHERE sb.set_number = c_soln_number
159: AND sb.status = 'PUB';
160:
161: l_published_soln_ver_id NUMBER;
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:
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
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
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:
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
1276: begin
1277: -- NOTE: access level for solutions has no meaning for 11510 and beyond.
1278: select set_number, access_level, status
1279: into l_set_number, l_access_level, l_status
1280: from CS_KB_SETS_B
1281: where set_id = p_set_id;
1282:
1283: /*** Set up the parameter list ***/
1284: wf_event.AddParameterToList(
1371: l_status VARCHAR2(30);
1372: begin
1373: select set_number, status
1374: into l_set_number, l_status
1375: from CS_KB_SETS_B
1376: where set_id = p_set_id;
1377:
1378: /*** Set up the parameter list ***/
1379: wf_event.AddParameterToList(