80: DECODE( p_start_date, FND_API.G_MISS_DATE, NULL, p_start_date),
81: DECODE( p_end_date, FND_API.G_MISS_DATE, NULL, p_end_date),
82: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
83: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
84: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
85: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
86: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
87: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));
88:
82: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
83: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
84: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
85: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
86: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
87: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));
88:
89: INSERT INTO ozf_na_rule_headers_tl(
90: na_rule_header_id ,
83: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
84: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
85: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
86: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
87: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));
88:
89: INSERT INTO ozf_na_rule_headers_tl(
90: na_rule_header_id ,
91: language ,
101: SELECT
102: DECODE( px_na_rule_header_id, FND_API.G_MISS_NUM, NULL, px_na_rule_header_id),
103: l.language_code,
104: DECODE( p_last_update_date, to_date(NULL), SYSDATE, p_last_update_date),
105: DECODE( p_last_updated_by, NULL, FND_GLOBAL.USER_ID, p_last_updated_by),
106: DECODE( p_creation_date, to_date(NULL), SYSDATE, p_creation_date),
107: DECODE( p_created_by, NULL, FND_GLOBAL.USER_ID, p_created_by),
108: DECODE( p_last_update_login, NULL, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
109: USERENV('LANG'),
103: l.language_code,
104: DECODE( p_last_update_date, to_date(NULL), SYSDATE, p_last_update_date),
105: DECODE( p_last_updated_by, NULL, FND_GLOBAL.USER_ID, p_last_updated_by),
106: DECODE( p_creation_date, to_date(NULL), SYSDATE, p_creation_date),
107: DECODE( p_created_by, NULL, FND_GLOBAL.USER_ID, p_created_by),
108: DECODE( p_last_update_login, NULL, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
109: USERENV('LANG'),
110: DECODE( p_name, FND_API.G_MISS_CHAR, NULL, p_name),
111: DECODE( p_description, FND_API.G_MISS_CHAR, NULL, p_description)
104: DECODE( p_last_update_date, to_date(NULL), SYSDATE, p_last_update_date),
105: DECODE( p_last_updated_by, NULL, FND_GLOBAL.USER_ID, p_last_updated_by),
106: DECODE( p_creation_date, to_date(NULL), SYSDATE, p_creation_date),
107: DECODE( p_created_by, NULL, FND_GLOBAL.USER_ID, p_created_by),
108: DECODE( p_last_update_login, NULL, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
109: USERENV('LANG'),
110: DECODE( p_name, FND_API.G_MISS_CHAR, NULL, p_name),
111: DECODE( p_description, FND_API.G_MISS_CHAR, NULL, p_description)
112: FROM fnd_languages l