DBA Data[Home] [Help]

APPS.FTE_VEHICLE_PKG dependencies on FND_GLOBAL

Line 338: SYSDATE, FND_GLOBAL.USER_ID,

334: p_ef_volume_cap_two_pool, p_ef_volume_cap_three_pool,
335: p_usable_length, p_usable_width, p_usable_height,
336: p_suspension_type_code, p_temperature_control_code,
337: p_number_of_doors, p_door_height, p_door_width,
338: SYSDATE, FND_GLOBAL.USER_ID,
339: SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID)
340: RETURNING vehicle_type_id INTO x_vehicle_type_id;
341:
342: IF l_debug_on THEN

Line 339: SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID)

335: p_usable_length, p_usable_width, p_usable_height,
336: p_suspension_type_code, p_temperature_control_code,
337: p_number_of_doors, p_door_height, p_door_width,
338: SYSDATE, FND_GLOBAL.USER_ID,
339: SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID)
340: RETURNING vehicle_type_id INTO x_vehicle_type_id;
341:
342: IF l_debug_on THEN
343: WSH_DEBUG_SV.LOGMSG(l_module_name, 'AfterInsertType');

Line 354: SYSDATE, FND_GLOBAL.USER_ID,

350: CREATION_DATE, CREATED_BY,
351: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN)
352: VALUES (FTE_VEHICLE_FEATURES_S.NEXTVAL, x_vehicle_type_id,
353: p_features_table(i),
354: SYSDATE, FND_GLOBAL.USER_ID,
355: SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID);
356: END LOOP;
357: IF l_debug_on THEN
358: WSH_DEBUG_SV.LOGMSG(l_module_name, 'AfterInsertFeature');

Line 355: SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID);

351: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN)
352: VALUES (FTE_VEHICLE_FEATURES_S.NEXTVAL, x_vehicle_type_id,
353: p_features_table(i),
354: SYSDATE, FND_GLOBAL.USER_ID,
355: SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID);
356: END LOOP;
357: IF l_debug_on THEN
358: WSH_DEBUG_SV.LOGMSG(l_module_name, 'AfterInsertFeature');
359: END IF;

Line 396: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

392: NUMBER_OF_DOORS = p_number_of_doors,
393: DOOR_HEIGHT = p_door_height,
394: DOOR_WIDTH = p_door_width,
395: LAST_UPDATE_DATE = SYSDATE,
396: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
397: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
398: WHERE VEHICLE_TYPE_ID = p_vehicle_type_id;
399: IF l_debug_on THEN
400: WSH_DEBUG_SV.LOGMSG(l_module_name, 'AfterInsertType');

Line 397: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

393: DOOR_HEIGHT = p_door_height,
394: DOOR_WIDTH = p_door_width,
395: LAST_UPDATE_DATE = SYSDATE,
396: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
397: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
398: WHERE VEHICLE_TYPE_ID = p_vehicle_type_id;
399: IF l_debug_on THEN
400: WSH_DEBUG_SV.LOGMSG(l_module_name, 'AfterInsertType');
401: END IF;

Line 417: SYSDATE, FND_GLOBAL.USER_ID,

413: CREATION_DATE, CREATED_BY,
414: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN)
415: VALUES (FTE_VEHICLE_FEATURES_S.NEXTVAL, p_vehicle_type_id,
416: p_features_table(i),
417: SYSDATE, FND_GLOBAL.USER_ID,
418: SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID);
419: END LOOP;
420: IF l_debug_on THEN
421: WSH_DEBUG_SV.LOGMSG(l_module_name, 'AfterInsertFeature-Update');

Line 418: SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID);

414: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN)
415: VALUES (FTE_VEHICLE_FEATURES_S.NEXTVAL, p_vehicle_type_id,
416: p_features_table(i),
417: SYSDATE, FND_GLOBAL.USER_ID,
418: SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID);
419: END LOOP;
420: IF l_debug_on THEN
421: WSH_DEBUG_SV.LOGMSG(l_module_name, 'AfterInsertFeature-Update');
422: END IF;

Line 473: item_cur_rec.organization_id, SYSDATE, FND_GLOBAL.USER_ID,

469: (VEHICLE_TYPE_ID, INVENTORY_ITEM_ID,
470: ORGANIZATION_ID, CREATION_DATE, CREATED_BY,
471: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN)
472: VALUES (FTE_VEHICLE_TYPES_S.NEXTVAL, item_cur_rec.inventory_item_id,
473: item_cur_rec.organization_id, SYSDATE, FND_GLOBAL.USER_ID,
474: SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID);
475: END LOOP;
476:
477: EXCEPTION WHEN OTHERS THEN

Line 474: SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID);

470: ORGANIZATION_ID, CREATION_DATE, CREATED_BY,
471: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN)
472: VALUES (FTE_VEHICLE_TYPES_S.NEXTVAL, item_cur_rec.inventory_item_id,
473: item_cur_rec.organization_id, SYSDATE, FND_GLOBAL.USER_ID,
474: SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID);
475: END LOOP;
476:
477: EXCEPTION WHEN OTHERS THEN
478: x_return_status := 'E';