43: AND attribute_code = X_Attribute_Code
44: AND userenv('LANG') in ( language , source_lang );
45:
46: --
47: -- refresh translation in PJM_TASK_ATTR_USAGES_TL
48: --
49: UPDATE pjm_task_attr_usages_tl
50: SET prompt = X_Attribute_Name
51: , last_update_date = sysdate
45:
46: --
47: -- refresh translation in PJM_TASK_ATTR_USAGES_TL
48: --
49: UPDATE pjm_task_attr_usages_tl
50: SET prompt = X_Attribute_Name
51: , last_update_date = sysdate
52: , last_updated_by = user_id
53: , source_lang = userenv('LANG')
129: AND attribute_code = X_Attribute_Code
130: AND userenv('LANG') in ( language , source_lang );
131:
132: --
133: -- refresh translation in PJM_TASK_ATTR_USAGES_TL
134: --
135: UPDATE pjm_task_attr_usages_tl
136: SET prompt = X_Attribute_Name
137: , last_update_date = sysdate
131:
132: --
133: -- refresh translation in PJM_TASK_ATTR_USAGES_TL
134: --
135: UPDATE pjm_task_attr_usages_tl
136: SET prompt = X_Attribute_Name
137: , last_update_date = sysdate
138: , last_updated_by = user_id
139: , source_lang = userenv('LANG')