338:
339: BEGIN
340:
341: l_creation_date := SYSDATE;
342: l_created_by := FND_GLOBAL.USER_ID;
343: l_last_update_date := SYSDATE;
344: l_last_updated_by := FND_GLOBAL.USER_ID;
345: l_last_update_login :=FND_GLOBAL.LOGIN_ID;
346:
340:
341: l_creation_date := SYSDATE;
342: l_created_by := FND_GLOBAL.USER_ID;
343: l_last_update_date := SYSDATE;
344: l_last_updated_by := FND_GLOBAL.USER_ID;
345: l_last_update_login :=FND_GLOBAL.LOGIN_ID;
346:
347: IF l_created_by IS NULL THEN
348: l_created_by := -1;
341: l_creation_date := SYSDATE;
342: l_created_by := FND_GLOBAL.USER_ID;
343: l_last_update_date := SYSDATE;
344: l_last_updated_by := FND_GLOBAL.USER_ID;
345: l_last_update_login :=FND_GLOBAL.LOGIN_ID;
346:
347: IF l_created_by IS NULL THEN
348: l_created_by := -1;
349: END IF;
355: IF l_last_update_login IS NULL THEN
356: l_last_update_login := -1;
357: END IF;
358:
359: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
360: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
361: l_program_application_id := FND_GLOBAL.PROG_APPL_ID;
362:
363: IF (l_request_id = -1) THEN
356: l_last_update_login := -1;
357: END IF;
358:
359: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
360: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
361: l_program_application_id := FND_GLOBAL.PROG_APPL_ID;
362:
363: IF (l_request_id = -1) THEN
364: l_request_id := NULL;
357: END IF;
358:
359: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
360: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
361: l_program_application_id := FND_GLOBAL.PROG_APPL_ID;
362:
363: IF (l_request_id = -1) THEN
364: l_request_id := NULL;
365: l_program_id := NULL;