28: LANGUAGE,
29: SOURCE_LANG
30: ) SELECT
31: SYSDATE,
32: hz_utility_v2pub.last_update_login,
33: SYSDATE,
34: hz_utility_v2pub.last_updated_by,
35: hz_utility_v2pub.created_by,
36: X_RULE_NAME,
30: ) SELECT
31: SYSDATE,
32: hz_utility_v2pub.last_update_login,
33: SYSDATE,
34: hz_utility_v2pub.last_updated_by,
35: hz_utility_v2pub.created_by,
36: X_RULE_NAME,
37: X_RULE_ID,
38: X_RULE_TYPE,
31: SYSDATE,
32: hz_utility_v2pub.last_update_login,
33: SYSDATE,
34: hz_utility_v2pub.last_updated_by,
35: hz_utility_v2pub.created_by,
36: X_RULE_NAME,
37: X_RULE_ID,
38: X_RULE_TYPE,
39: L.LANGUAGE_CODE,
100:
101: UPDATE HZ_EXT_DATA_RULES_TL
102: SET RULE_NAME = X_RULE_NAME,
103: LAST_UPDATE_DATE = SYSDATE,
104: LAST_UPDATED_BY = hz_utility_v2pub.last_updated_by,
105: LAST_UPDATE_LOGIN = hz_utility_v2pub.last_update_login,
106: SOURCE_LANG = USERENV('LANG')
107: WHERE RULE_ID = X_RULE_ID
108: AND USERENV('LANG') IN (LANGUAGE, SOURCE_LANG);
101: UPDATE HZ_EXT_DATA_RULES_TL
102: SET RULE_NAME = X_RULE_NAME,
103: LAST_UPDATE_DATE = SYSDATE,
104: LAST_UPDATED_BY = hz_utility_v2pub.last_updated_by,
105: LAST_UPDATE_LOGIN = hz_utility_v2pub.last_update_login,
106: SOURCE_LANG = USERENV('LANG')
107: WHERE RULE_ID = X_RULE_ID
108: AND USERENV('LANG') IN (LANGUAGE, SOURCE_LANG);
109: