252: /* init object version number */
253: l_object_version_number := NVL(p_object_version_number, g_object_version_number);
254:
255: /* init last_update_login */
256: IF (FND_GLOBAL.conc_login_id = -1) OR (FND_GLOBAL.conc_login_id IS NULL) THEN
257: l_last_update_login := FND_GLOBAL.login_id;
258: ELSE
259: l_last_update_login := FND_GLOBAL.conc_login_id;
260: END IF;
253: l_object_version_number := NVL(p_object_version_number, g_object_version_number);
254:
255: /* init last_update_login */
256: IF (FND_GLOBAL.conc_login_id = -1) OR (FND_GLOBAL.conc_login_id IS NULL) THEN
257: l_last_update_login := FND_GLOBAL.login_id;
258: ELSE
259: l_last_update_login := FND_GLOBAL.conc_login_id;
260: END IF;
261:
255: /* init last_update_login */
256: IF (FND_GLOBAL.conc_login_id = -1) OR (FND_GLOBAL.conc_login_id IS NULL) THEN
257: l_last_update_login := FND_GLOBAL.login_id;
258: ELSE
259: l_last_update_login := FND_GLOBAL.conc_login_id;
260: END IF;
261:
262: -- dbms_output.put_line('l_old_access_id = ' || l_old_access_id);
263: -- dbms_output.put_line('l_new_access_id = ' || l_new_access_id);
280: p_additional_value3,
281: p_additional_value4,
282: p_additional_value5,
283: l_object_version_number,
284: nvl(FND_GLOBAL.user_id, -1), /* Created by */
285: SYSDATE, /* Creation date */
286: nvl(FND_GLOBAL.user_id, -1), /* Last updated by */
287: SYSDATE, /* Last update date */
288: l_last_update_login /* Last update login */
282: p_additional_value5,
283: l_object_version_number,
284: nvl(FND_GLOBAL.user_id, -1), /* Created by */
285: SYSDATE, /* Creation date */
286: nvl(FND_GLOBAL.user_id, -1), /* Last updated by */
287: SYSDATE, /* Last update date */
288: l_last_update_login /* Last update login */
289: );
290:
298: /* init object version number */
299: l_object_version_number := NVL(p_object_version_number, g_object_version_number);
300:
301: /* init last_update_login */
302: IF (FND_GLOBAL.conc_login_id = -1) OR (FND_GLOBAL.conc_login_id IS NULL) THEN
303: l_last_update_login := FND_GLOBAL.login_id;
304: ELSE
305: l_last_update_login := FND_GLOBAL.conc_login_id;
306: END IF;
299: l_object_version_number := NVL(p_object_version_number, g_object_version_number);
300:
301: /* init last_update_login */
302: IF (FND_GLOBAL.conc_login_id = -1) OR (FND_GLOBAL.conc_login_id IS NULL) THEN
303: l_last_update_login := FND_GLOBAL.login_id;
304: ELSE
305: l_last_update_login := FND_GLOBAL.conc_login_id;
306: END IF;
307:
301: /* init last_update_login */
302: IF (FND_GLOBAL.conc_login_id = -1) OR (FND_GLOBAL.conc_login_id IS NULL) THEN
303: l_last_update_login := FND_GLOBAL.login_id;
304: ELSE
305: l_last_update_login := FND_GLOBAL.conc_login_id;
306: END IF;
307:
308: -- dbms_output.put_line('l_new_access_id = ' || l_new_access_id);
309: -- dbms_output.put_line('l_object_version_number = ' || l_object_version_number);
344: p_additional_value3,
345: p_additional_value4,
346: p_additional_value5,
347: l_object_version_number,
348: nvl(FND_GLOBAL.user_id, -1), /* Created by */
349: SYSDATE, /* Creation date */
350: nvl(FND_GLOBAL.user_id, -1), /* Last updated by */
351: SYSDATE, /* Last update date */
352: l_last_update_login /* Last update login */
346: p_additional_value5,
347: l_object_version_number,
348: nvl(FND_GLOBAL.user_id, -1), /* Created by */
349: SYSDATE, /* Creation date */
350: nvl(FND_GLOBAL.user_id, -1), /* Last updated by */
351: SYSDATE, /* Last update date */
352: l_last_update_login /* Last update login */
353: );
354: ELSE
373: p_additional_value3,
374: p_additional_value4,
375: p_additional_value5,
376: l_object_version_number,
377: nvl(FND_GLOBAL.user_id, -1), /* Created by */
378: SYSDATE, /* Creation date */
379: nvl(FND_GLOBAL.user_id, -1), /* Last updated by */
380: SYSDATE, /* Last update date */
381: l_last_update_login /* Last update login */
375: p_additional_value5,
376: l_object_version_number,
377: nvl(FND_GLOBAL.user_id, -1), /* Created by */
378: SYSDATE, /* Creation date */
379: nvl(FND_GLOBAL.user_id, -1), /* Last updated by */
380: SYSDATE, /* Last update date */
381: l_last_update_login /* Last update login */
382: );
383:
402: p_additional_value3,
403: p_additional_value4,
404: p_additional_value5,
405: l_object_version_number,
406: nvl(FND_GLOBAL.user_id, -1), /* Created by */
407: SYSDATE, /* Creation date */
408: nvl(FND_GLOBAL.user_id, -1), /* Last updated by */
409: SYSDATE, /* Last update date */
410: l_last_update_login /* Last update login */
404: p_additional_value5,
405: l_object_version_number,
406: nvl(FND_GLOBAL.user_id, -1), /* Created by */
407: SYSDATE, /* Creation date */
408: nvl(FND_GLOBAL.user_id, -1), /* Last updated by */
409: SYSDATE, /* Last update date */
410: l_last_update_login /* Last update login */
411: );
412: END IF;