257: p_attribute27 => p_attribute27 ,
258: p_attribute28 => p_attribute28 ,
259: p_attribute29 => p_attribute29 ,
260: p_attribute30 => p_attribute30 ,
261: p_created_by => FND_GLOBAL.USER_ID,
262: p_creation_date => SYSDATE,
263: p_last_updated_by => FND_GLOBAL.USER_ID,
264: p_last_update_date => SYSDATE,
265: p_last_update_login => l_last_update_login,
259: p_attribute29 => p_attribute29 ,
260: p_attribute30 => p_attribute30 ,
261: p_created_by => FND_GLOBAL.USER_ID,
262: p_creation_date => SYSDATE,
263: p_last_updated_by => FND_GLOBAL.USER_ID,
264: p_last_update_date => SYSDATE,
265: p_last_update_login => l_last_update_login,
266: x_rowid => row_id,
267: x_return_status => return_status,
279: p_safety_phrase_code => p_phrase_code,
280: p_language => p_language,
281: p_source_language => p_source_language,
282: p_safety_phrase_description => p_phrase_text,
283: p_created_by => fnd_global.user_id,
284: p_creation_date => sysdate,
285: p_last_updated_by => fnd_global.user_id,
286: p_last_update_date => sysdate,
287: p_last_update_login => l_last_update_login,
281: p_source_language => p_source_language,
282: p_safety_phrase_description => p_phrase_text,
283: p_created_by => fnd_global.user_id,
284: p_creation_date => sysdate,
285: p_last_updated_by => fnd_global.user_id,
286: p_last_update_date => sysdate,
287: p_last_update_login => l_last_update_login,
288: x_rowid => row_id,
289: x_return_status => return_status,
348: p_safety_phrase_code => p_phrase_code,
349: p_language => p_language,
350: p_source_language => p_source_language,
351: p_safety_phrase_description => p_phrase_text,
352: p_created_by => fnd_global.user_id,
353: p_creation_date => sysdate,
354: p_last_updated_by => fnd_global.user_id,
355: p_last_update_date => sysdate,
356: p_last_update_login => l_last_update_login,
350: p_source_language => p_source_language,
351: p_safety_phrase_description => p_phrase_text,
352: p_created_by => fnd_global.user_id,
353: p_creation_date => sysdate,
354: p_last_updated_by => fnd_global.user_id,
355: p_last_update_date => sysdate,
356: p_last_update_login => l_last_update_login,
357: x_rowid => row_id,
358: x_return_status => return_status,
419: p_attribute27 => p_attribute27 ,
420: p_attribute28 => p_attribute28 ,
421: p_attribute29 => p_attribute29 ,
422: p_attribute30 => p_attribute30 ,
423: p_created_by => FND_GLOBAL.USER_ID,
424: p_creation_date => SYSDATE,
425: p_last_updated_by => FND_GLOBAL.USER_ID,
426: p_last_update_date => SYSDATE,
427: p_last_update_login => l_last_update_login,
421: p_attribute29 => p_attribute29 ,
422: p_attribute30 => p_attribute30 ,
423: p_created_by => FND_GLOBAL.USER_ID,
424: p_creation_date => SYSDATE,
425: p_last_updated_by => FND_GLOBAL.USER_ID,
426: p_last_update_date => SYSDATE,
427: p_last_update_login => l_last_update_login,
428: x_rowid => row_id,
429: x_return_status => return_status,
441: p_risk_phrase_code => p_phrase_code,
442: p_language => p_language,
443: p_source_language => p_source_language,
444: p_risk_description => p_phrase_text,
445: p_created_by => fnd_global.user_id,
446: p_creation_date => sysdate,
447: p_last_updated_by => fnd_global.user_id,
448: p_last_update_date => sysdate,
449: p_last_update_login => l_last_update_login,
443: p_source_language => p_source_language,
444: p_risk_description => p_phrase_text,
445: p_created_by => fnd_global.user_id,
446: p_creation_date => sysdate,
447: p_last_updated_by => fnd_global.user_id,
448: p_last_update_date => sysdate,
449: p_last_update_login => l_last_update_login,
450: x_rowid => row_id,
451: x_return_status => return_status,
510: p_risk_phrase_code => p_phrase_code,
511: p_language => p_language,
512: p_source_language => p_source_language,
513: p_risk_description => p_phrase_text,
514: p_created_by => fnd_global.user_id,
515: p_creation_date => sysdate,
516: p_last_updated_by => fnd_global.user_id,
517: p_last_update_date => sysdate,
518: p_last_update_login => l_last_update_login,
512: p_source_language => p_source_language,
513: p_risk_description => p_phrase_text,
514: p_created_by => fnd_global.user_id,
515: p_creation_date => sysdate,
516: p_last_updated_by => fnd_global.user_id,
517: p_last_update_date => sysdate,
518: p_last_update_login => l_last_update_login,
519: x_rowid => row_id,
520: x_return_status => return_status,
572: attribute27 = p_attribute27 ,
573: attribute28 = p_attribute28 ,
574: attribute29 = p_attribute29 ,
575: attribute30 = p_attribute30 ,
576: last_updated_by = FND_GLOBAL.USER_ID,
577: last_update_date = SYSDATE,
578: last_update_login = l_last_update_login
579: WHERE safety_phrase_code = p_phrase_code;
580: IF SQL%NOTFOUND THEN
613: -- The value for Description will be updated GR_SAFETY_PHRASES_TL table for the specified language.
614: UPDATE GR_SAFETY_PHRASES_TL
615: SET safety_phrase_description = p_phrase_text,
616: source_lang = p_source_language,
617: last_updated_by = FND_GLOBAL.USER_ID,
618: last_update_date = SYSDATE,
619: last_update_login = l_last_update_login
620: WHERE safety_phrase_code = p_phrase_code
621: AND language = p_language;
667: attribute27 = p_attribute27 ,
668: attribute28 = p_attribute28 ,
669: attribute29 = p_attribute29 ,
670: attribute30 = p_attribute30 ,
671: last_updated_by = FND_GLOBAL.USER_ID,
672: last_update_date = SYSDATE,
673: last_update_login = l_last_update_login
674: WHERE risk_phrase_code = p_phrase_code;
675: IF SQL%NOTFOUND THEN
708: -- The value for Description will be updated GR_RISK_PHRASES_TL table for the specified language.
709: UPDATE GR_RISK_PHRASES_TL
710: SET risk_description = p_phrase_text,
711: source_lang = p_source_language,
712: last_updated_by = FND_GLOBAL.USER_ID,
713: last_update_date = SYSDATE,
714: last_update_login = l_last_update_login
715: WHERE risk_phrase_code = p_phrase_code
716: AND language = p_language;