274: p_resource_assignment_id
275: ,DECODE( p_start_date, FND_API.G_MISS_DATE, to_date(NULL),
276: p_start_date)
277: ,sysdate
278: ,fnd_global.user_id
279: ,sysdate
280: ,fnd_global.user_id
281: ,fnd_global.login_id
282: ,DECODE( p_end_date, FND_API.G_MISS_DATE, to_date(NULL), p_end_date)
276: p_start_date)
277: ,sysdate
278: ,fnd_global.user_id
279: ,sysdate
280: ,fnd_global.user_id
281: ,fnd_global.login_id
282: ,DECODE( p_end_date, FND_API.G_MISS_DATE, to_date(NULL), p_end_date)
283: ,DECODE( p_period_name, FND_API.G_MISS_CHAR, NULL, p_period_name)
284: ,DECODE( p_quantity, FND_API.G_MISS_NUM, NULL, p_quantity)
277: ,sysdate
278: ,fnd_global.user_id
279: ,sysdate
280: ,fnd_global.user_id
281: ,fnd_global.login_id
282: ,DECODE( p_end_date, FND_API.G_MISS_DATE, to_date(NULL), p_end_date)
283: ,DECODE( p_period_name, FND_API.G_MISS_CHAR, NULL, p_period_name)
284: ,DECODE( p_quantity, FND_API.G_MISS_NUM, NULL, p_quantity)
285: ,DECODE( p_raw_cost, FND_API.G_MISS_NUM, NULL, p_raw_cost)
578: SET
579: start_date = DECODE( p_start_date, FND_API.G_MISS_DATE, start_date,
580: p_start_date)
581: ,last_update_date = sysdate
582: ,last_updated_by = fnd_global.user_id
583: ,last_update_login = fnd_global.login_id
584: ,end_date = DECODE( p_end_date, FND_API.G_MISS_DATE, end_date, p_end_date)
585: ,period_name = DECODE( p_period_name, FND_API.G_MISS_CHAR, period_name,
586: p_period_name)
579: start_date = DECODE( p_start_date, FND_API.G_MISS_DATE, start_date,
580: p_start_date)
581: ,last_update_date = sysdate
582: ,last_updated_by = fnd_global.user_id
583: ,last_update_login = fnd_global.login_id
584: ,end_date = DECODE( p_end_date, FND_API.G_MISS_DATE, end_date, p_end_date)
585: ,period_name = DECODE( p_period_name, FND_API.G_MISS_CHAR, period_name,
586: p_period_name)
587: ,quantity = DECODE( p_quantity, FND_API.G_MISS_NUM, quantity, p_quantity)