APPS.CS_KB_SET_RECS_PKG dependencies on CS_KB_SET_RECS_S

Line 62: from cs_kb_set_recs sr1 where sr1.set_order =

58: -- Note: we join the recommended solutions list with the
59: -- secure solutions view to filter out any solutions in
60: -- the recommended solutions list the user cannot access.
61: select sr1.set_rec_id, sr1.set_order into l_set_rec_id_prev, l_prev_order
62: from cs_kb_set_recs sr1 where sr1.set_order =
63: (select max(sr.set_order)
64: from cs_kb_set_recs sr, cs_kb_secure_solutions_view sv
65: where sr.set_number = sv.set_number
66: and sv.viewable_version_flag = 'Y'

Line 64: from cs_kb_set_recs sr, cs_kb_secure_solutions_view sv

60: -- the recommended solutions list the user cannot access.
61: select sr1.set_rec_id, sr1.set_order into l_set_rec_id_prev, l_prev_order
62: from cs_kb_set_recs sr1 where sr1.set_order =
63: (select max(sr.set_order)
64: from cs_kb_set_recs sr, cs_kb_secure_solutions_view sv
65: where sr.set_number = sv.set_number
66: and sv.viewable_version_flag = 'Y'
67: and sv.status = 'PUB'
68: and sr.set_order < l_order );

Line 134: from cs_kb_set_recs sr1 where sr1.set_order =

130: -- Note: we join the recommended solutions list with the
131: -- secure solutions view to filter out any solutions in
132: -- the recommended solutions list the user cannot access.
133: select sr1.set_rec_id, sr1.set_order into l_set_rec_id_next, l_next_order
134: from cs_kb_set_recs sr1 where sr1.set_order =
135: (select min(sr.set_order)
136: from cs_kb_set_recs sr, cs_kb_secure_solutions_view sv
137: where sr.set_number = sv.set_number
138: and sv.viewable_version_flag = 'Y'

Line 136: from cs_kb_set_recs sr, cs_kb_secure_solutions_view sv

132: -- the recommended solutions list the user cannot access.
133: select sr1.set_rec_id, sr1.set_order into l_set_rec_id_next, l_next_order
134: from cs_kb_set_recs sr1 where sr1.set_order =
135: (select min(sr.set_order)
136: from cs_kb_set_recs sr, cs_kb_secure_solutions_view sv
137: where sr.set_number = sv.set_number
138: and sv.viewable_version_flag = 'Y'
139: and sv.status = 'PUB'
140: and sr.set_order > l_order );

Line 219: select cs_kb_set_recs_s.currval into l_set_rec_id_seq_val from dual;

215:
216: -- Make sure the id sequence is always higher than the passed
217: -- in set rec id such that there will not be duplicate solution
218: -- recommendation id's created.
219: select cs_kb_set_recs_s.currval into l_set_rec_id_seq_val from dual;
220: while ( l_set_rec_id_seq_val < p_set_rec_id ) loop
221: select cs_kb_set_recs_s.nextval into l_set_rec_id_seq_val from dual;
222: end loop;
223:

Line 221: select cs_kb_set_recs_s.nextval into l_set_rec_id_seq_val from dual;

217: -- in set rec id such that there will not be duplicate solution
218: -- recommendation id's created.
219: select cs_kb_set_recs_s.currval into l_set_rec_id_seq_val from dual;
220: while ( l_set_rec_id_seq_val < p_set_rec_id ) loop
221: select cs_kb_set_recs_s.nextval into l_set_rec_id_seq_val from dual;
222: end loop;
223:
224: l_set_rec_id := p_set_rec_id;
225: else

Line 226: select cs_kb_set_recs_s.nextval into l_set_rec_id from dual;

222: end loop;
223:
224: l_set_rec_id := p_set_rec_id;
225: else
226: select cs_kb_set_recs_s.nextval into l_set_rec_id from dual;
227: end if;
228:
229: if(P_SET_NUMBER is null) then
230: fnd_message.set_name('CS', 'CS_KB_C_MISS_PARAM');

Line 407: update CS_KB_SET_RECS set

403: l_date := sysdate;
404: l_updated_by := fnd_global.user_id;
405: l_login := fnd_global.login_id;
406:
407: update CS_KB_SET_RECS set
408: SET_ORDER = P_SET_ORDER,
409: LAST_UPDATE_DATE = l_date,
410: LAST_UPDATED_BY = l_updated_by,
411: LAST_UPDATE_LOGIN = l_login,