APPS.FTE_VEHICLE_PKG dependencies on FTE_VEHICLE_FEATURES

Line 128: -- 2) Insert/Update/Delete FTE_VEHICLE_FEATURES

124:
125: -- Procecure : CREATE_UPDATE_VEHICLE_TYPE (public API)
126: -- Purpose : Create or update a Vehicle Type
127: -- 1) Insert/Update FTE_VEHICLE_TYPES
128: -- 2) Insert/Update/Delete FTE_VEHICLE_FEATURES
129: -- 3) Call INV_ITEM_GRP.CREATE_ITEM/UPDATE_ITEM
130: -- to create/update an inventory master item
131:
132: PROCEDURE CREATE_UPDATE_VEHICLE_TYPE

Line 347: INSERT INTO FTE_VEHICLE_FEATURES

343: WSH_DEBUG_SV.LOGMSG(l_module_name, 'AfterInsertType');
344: END IF;
345:
346: FOR i IN 1..p_features_table.COUNT LOOP
347: INSERT INTO FTE_VEHICLE_FEATURES
348: (VEHICLE_TYPE_FEATURE_ID, VEHICLE_TYPE_ID,
349: VEHICLE_FEATURE_CODE,
350: CREATION_DATE, CREATED_BY,
351: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN)

Line 352: VALUES (FTE_VEHICLE_FEATURES_S.NEXTVAL, x_vehicle_type_id,

348: (VEHICLE_TYPE_FEATURE_ID, VEHICLE_TYPE_ID,
349: VEHICLE_FEATURE_CODE,
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;

Line 403: DELETE FTE_VEHICLE_FEATURES

399: IF l_debug_on THEN
400: WSH_DEBUG_SV.LOGMSG(l_module_name, 'AfterInsertType');
401: END IF;
402:
403: DELETE FTE_VEHICLE_FEATURES
404: WHERE VEHICLE_TYPE_ID = p_vehicle_type_id;
405: IF l_debug_on THEN
406: WSH_DEBUG_SV.LOGMSG(l_module_name, 'AfterDeleteFeature');
407: END IF;

Line 410: INSERT INTO FTE_VEHICLE_FEATURES

406: WSH_DEBUG_SV.LOGMSG(l_module_name, 'AfterDeleteFeature');
407: END IF;
408:
409: FOR i IN 1..p_features_table.COUNT LOOP
410: INSERT INTO FTE_VEHICLE_FEATURES
411: (VEHICLE_TYPE_FEATURE_ID, VEHICLE_TYPE_ID,
412: VEHICLE_FEATURE_CODE,
413: CREATION_DATE, CREATED_BY,
414: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN)

Line 415: VALUES (FTE_VEHICLE_FEATURES_S.NEXTVAL, p_vehicle_type_id,

411: (VEHICLE_TYPE_FEATURE_ID, VEHICLE_TYPE_ID,
412: VEHICLE_FEATURE_CODE,
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;