244:
245: -- Default who columns
246: IF p_xprt_question_rec.created_by = okc_api.g_miss_num
247: THEN
248: p_xprt_question_rec.created_by := fnd_global.user_id;
249: END IF;
250:
251: IF p_xprt_question_rec.creation_date = okc_api.g_miss_date
252: THEN
254: END IF;
255:
256: -- Default Who Coulmns
257: p_xprt_question_rec.last_update_date := SYSDATE;
258: p_xprt_question_rec.last_updated_by := fnd_global.user_id;
259: p_xprt_question_rec.last_update_login := fnd_global.login_id;
260:
261:
262: IF fnd_global.conc_request_id = -1
255:
256: -- Default Who Coulmns
257: p_xprt_question_rec.last_update_date := SYSDATE;
258: p_xprt_question_rec.last_updated_by := fnd_global.user_id;
259: p_xprt_question_rec.last_update_login := fnd_global.login_id;
260:
261:
262: IF fnd_global.conc_request_id = -1
263: THEN
258: p_xprt_question_rec.last_updated_by := fnd_global.user_id;
259: p_xprt_question_rec.last_update_login := fnd_global.login_id;
260:
261:
262: IF fnd_global.conc_request_id = -1
263: THEN
264: p_xprt_question_rec.request_id := NULL;
265: ELSE
266: p_xprt_question_rec.request_id := fnd_global.conc_request_id;
262: IF fnd_global.conc_request_id = -1
263: THEN
264: p_xprt_question_rec.request_id := NULL;
265: ELSE
266: p_xprt_question_rec.request_id := fnd_global.conc_request_id;
267: END IF;
268:
269: IF fnd_global.conc_program_id = -1
270: THEN
265: ELSE
266: p_xprt_question_rec.request_id := fnd_global.conc_request_id;
267: END IF;
268:
269: IF fnd_global.conc_program_id = -1
270: THEN
271: p_xprt_question_rec.program_id := NULL;
272: p_xprt_question_rec.program_update_date := NULL;
273: ELSE
270: THEN
271: p_xprt_question_rec.program_id := NULL;
272: p_xprt_question_rec.program_update_date := NULL;
273: ELSE
274: p_xprt_question_rec.program_id := fnd_global.conc_program_id;
275: -- Directly initializing it to the sysdate
276: p_xprt_question_rec.program_update_date := SYSDATE;
277: END IF;
278:
275: -- Directly initializing it to the sysdate
276: p_xprt_question_rec.program_update_date := SYSDATE;
277: END IF;
278:
279: IF fnd_global.prog_appl_id = -1
280: THEN
281: p_xprt_question_rec.program_application_id := NULL;
282: ELSE
283: p_xprt_question_rec.program_application_id :=
280: THEN
281: p_xprt_question_rec.program_application_id := NULL;
282: ELSE
283: p_xprt_question_rec.program_application_id :=
284: fnd_global.prog_appl_id;
285: END IF;
286:
287: IF (p_xprt_question_rec.source_lang = okc_api.g_miss_char)
288: THEN
1144:
1145:
1146:
1147: -- Default the attributes
1148: p_xprt_update_question_rec.last_updated_by := fnd_global.user_id;
1149: p_xprt_update_question_rec.last_update_date := SYSDATE;
1150: p_xprt_update_question_rec.last_update_login := fnd_global.login_id;
1151:
1152: IF p_xprt_update_question_rec.qn_const_type = OKC_API.G_MISS_CHAR THEN
1146:
1147: -- Default the attributes
1148: p_xprt_update_question_rec.last_updated_by := fnd_global.user_id;
1149: p_xprt_update_question_rec.last_update_date := SYSDATE;
1150: p_xprt_update_question_rec.last_update_login := fnd_global.login_id;
1151:
1152: IF p_xprt_update_question_rec.qn_const_type = OKC_API.G_MISS_CHAR THEN
1153: p_xprt_update_question_rec.qn_const_type := l_question_type;
1154: END IF;