990: l_task_id,
991: p_labor_multiplier,
992: p_effective_from_date,
993: l_effective_to_date,
994: FND_GLOBAL.USER_ID,
995: SYSDATE,
996: FND_GLOBAL.USER_ID,
997: SYSDATE,
998: FND_GLOBAl.LOGIN_ID,
992: p_effective_from_date,
993: l_effective_to_date,
994: FND_GLOBAL.USER_ID,
995: SYSDATE,
996: FND_GLOBAL.USER_ID,
997: SYSDATE,
998: FND_GLOBAl.LOGIN_ID,
999: 1
1000: );
994: FND_GLOBAL.USER_ID,
995: SYSDATE,
996: FND_GLOBAL.USER_ID,
997: SYSDATE,
998: FND_GLOBAl.LOGIN_ID,
999: 1
1000: );
1001:
1002:
1253: UPDATE pa_labor_multipliers
1254: SET LABOR_MULTIPLIER = p_labor_multiplier,
1255: START_DATE_ACTIVE = p_effective_from_date,
1256: END_DATE_ACTIVE = l_effective_to_date,
1257: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1258: LAST_UPDATE_DATE = SYSDATE,
1259: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
1260: RECORD_VERSION_NUMBER = NVL( RECORD_VERSION_NUMBER, 0 ) + 1
1261: WHERE labor_multiplier_id = p_labor_multiplier_id
1255: START_DATE_ACTIVE = p_effective_from_date,
1256: END_DATE_ACTIVE = l_effective_to_date,
1257: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1258: LAST_UPDATE_DATE = SYSDATE,
1259: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
1260: RECORD_VERSION_NUMBER = NVL( RECORD_VERSION_NUMBER, 0 ) + 1
1261: WHERE labor_multiplier_id = p_labor_multiplier_id
1262: AND RECORD_VERSION_NUMBER = p_RECORD_VERSION_NUMBER;
1263: ELSE