153: )
154: VALUES (
155: l_timeout_setup_rec.timeout_id
156: ,SYSDATE -- LAST_UPDATE_DATE
157: ,NVL(FND_GLOBAL.user_id,-1) -- LAST_UPDATED_BY
158: ,SYSDATE -- CREATION_DATE
159: ,NVL(FND_GLOBAL.user_id,-1) -- CREATED_BY
160: ,NVL(FND_GLOBAL.conc_login_id,-1) -- LAST_UPDATE_LOGIN
161: ,l_timeout_setup_rec.timeout_period
155: l_timeout_setup_rec.timeout_id
156: ,SYSDATE -- LAST_UPDATE_DATE
157: ,NVL(FND_GLOBAL.user_id,-1) -- LAST_UPDATED_BY
158: ,SYSDATE -- CREATION_DATE
159: ,NVL(FND_GLOBAL.user_id,-1) -- CREATED_BY
160: ,NVL(FND_GLOBAL.conc_login_id,-1) -- LAST_UPDATE_LOGIN
161: ,l_timeout_setup_rec.timeout_period
162: ,l_timeout_setup_rec.timeout_type
163: ,l_timeout_setup_rec.country_code
156: ,SYSDATE -- LAST_UPDATE_DATE
157: ,NVL(FND_GLOBAL.user_id,-1) -- LAST_UPDATED_BY
158: ,SYSDATE -- CREATION_DATE
159: ,NVL(FND_GLOBAL.user_id,-1) -- CREATED_BY
160: ,NVL(FND_GLOBAL.conc_login_id,-1) -- LAST_UPDATE_LOGIN
161: ,l_timeout_setup_rec.timeout_period
162: ,l_timeout_setup_rec.timeout_type
163: ,l_timeout_setup_rec.country_code
164: ,l_object_version_number -- object_version_number
454:
455: UPDATE PV_COUNTRY_TIMEOUTS
456: SET
457: last_update_date = SYSDATE
458: ,last_updated_by = NVL(FND_GLOBAL.user_id,-1)
459: ,last_update_login = NVL(FND_GLOBAL.conc_login_id,-1)
460: ,timeout_period = l_timeout_setup_rec.timeout_period
461: ,timeout_type = l_timeout_setup_rec.timeout_type
462: ,country_code = l_timeout_setup_rec.country_code
455: UPDATE PV_COUNTRY_TIMEOUTS
456: SET
457: last_update_date = SYSDATE
458: ,last_updated_by = NVL(FND_GLOBAL.user_id,-1)
459: ,last_update_login = NVL(FND_GLOBAL.conc_login_id,-1)
460: ,timeout_period = l_timeout_setup_rec.timeout_period
461: ,timeout_type = l_timeout_setup_rec.timeout_type
462: ,country_code = l_timeout_setup_rec.country_code
463: ,object_version_number = l_timeout_setup_rec.object_version_number + 1