DBA Data[Home] [Help]

APPS.CS_KB_SET_RECS_PKG dependencies on FND_GLOBAL

Line 299: l_created_by := fnd_global.user_id;

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

Line 300: l_login := fnd_global.login_id;

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,

Line 404: l_updated_by := fnd_global.user_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,

Line 405: l_login := fnd_global.login_id;

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,

Line 524: l_user := fnd_global.user_id;

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

Line 525: l_login := fnd_global.login_id;

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,