[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;
707:
708: -- Validation Cursors
709: CURSOR Validate_Link IS
710: SELECT sl.set_id, sl.object_code, sl.other_id, sb.set_number, sb.status
711: FROM CS_KB_SET_LINKS sl, CS_KB_SETS_B sb
712: WHERE sl.link_id = P_LINK_ID
713: AND sl.set_id = sb.set_id
714: AND ( sb.status = 'PUB' OR sb.latest_version_flag = 'Y' );
715:
716: -- Cursor to fetch link to latest in-progress version of a solution
717: CURSOR Get_Link_To_Latest_Ver(c_soln_number VARCHAR2, c_object_code VARCHAR2,
718: c_other_id NUMBER) IS
719: SELECT sl.link_id, sl.set_id
720: FROM CS_KB_SET_LINKS sl, CS_KB_SETS_B sb
721: WHERE sb.set_number = c_soln_number
722: AND sb.latest_version_flag = 'Y'
723: AND sb.set_id = sl.set_id
724: AND sl.object_code = c_object_code
727: -- Cursor to fetch link to published version of a solution
728: CURSOR Get_Link_To_Published_Ver(c_soln_number VARCHAR2, c_object_code VARCHAR2,
729: c_other_id NUMBER) IS
730: SELECT sl.link_id, sl.set_id
731: FROM CS_KB_SET_LINKS sl, CS_KB_SETS_B sb
732: WHERE sb.set_number = c_soln_number
733: AND sb.status = 'PUB'
734: AND sb.set_id = sl.set_id
735: AND sl.object_code = c_object_code
1025: -- Cursor to validate link exists and is to either a published solution
1026: -- version or an in-progress version.
1027: cursor Valid_Link IS
1028: select sb.set_number, sb.status, sl.object_code, sl.other_id
1029: from cs_kb_set_links sl, cs_kb_sets_b sb
1030: where sl.link_id = P_LINK_ID
1031: and sl.set_id = sb.set_id
1032: and ( sb.status = 'PUB' or sb.latest_version_flag = 'Y' );
1033:
1034: -- Cursor to fetch link to latest in-progress version of a solution
1035: CURSOR Get_Link_To_Other_Ver(c_soln_number VARCHAR2, c_object_code VARCHAR2,
1036: c_other_id NUMBER) IS
1037: SELECT sl.link_id
1038: FROM CS_KB_SET_LINKS sl, CS_KB_SETS_B sb
1039: WHERE sb.set_number = c_soln_number
1040: AND (sb.latest_version_flag = 'Y' or sb.status = 'PUB')
1041: AND sb.set_id = sl.set_id
1042: AND sl.object_code = c_object_code
1300: begin
1301: -- NOTE: access level for solutions has no meaning for 11510 and beyond.
1302: select set_number, access_level, status
1303: into l_set_number, l_access_level, l_status
1304: from CS_KB_SETS_B
1305: where set_id = p_set_id;
1306:
1307: /*** Set up the parameter list ***/
1308: wf_event.AddParameterToList(
1395: l_status VARCHAR2(30);
1396: begin
1397: select set_number, status
1398: into l_set_number, l_status
1399: from CS_KB_SETS_B
1400: where set_id = p_set_id;
1401:
1402: /*** Set up the parameter list ***/
1403: wf_event.AddParameterToList(