295: end loop;
296: end if;
297:
298: l_date := sysdate;
299: l_created_by := fnd_global.user_id;
300: l_login := fnd_global.login_id;
301:
302: -- Create the solution recommendation row
303: insert into CS_KB_SET_RECS
296: end if;
297:
298: l_date := sysdate;
299: l_created_by := fnd_global.user_id;
300: l_login := fnd_global.login_id;
301:
302: -- Create the solution recommendation row
303: insert into CS_KB_SET_RECS
304: ( SET_REC_ID,
400: CLOSE GET_STORED_SET;
401: */
402:
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,
401: */
402:
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,
520: where set_rec_id = p_set_rec_id_2;
521:
522: -- Initialize some who column data
523: l_date := sysdate;
524: l_user := fnd_global.user_id;
525: l_login := fnd_global.login_id;
526:
527: -- We swap the order number of the solution recommendations.
528: update cs_kb_set_recs
521:
522: -- Initialize some who column data
523: l_date := sysdate;
524: l_user := fnd_global.user_id;
525: l_login := fnd_global.login_id;
526:
527: -- We swap the order number of the solution recommendations.
528: update cs_kb_set_recs
529: set set_order = -100,