eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_NA_RULE_HEADER_PKG dependencies on FND_API

Line 77: DECODE( px_na_rule_header_id, FND_API.G_MISS_NUM, NULL, px_na_rule_header_id),

73: last_update_date,
74: last_updated_by,
75: last_update_login
76: ) VALUES (
77: DECODE( px_na_rule_header_id, FND_API.G_MISS_NUM, NULL, px_na_rule_header_id),
78: DECODE( p_user_status_id, FND_API.G_MISS_NUM, NULL, p_user_status_id),
79: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
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),

Line 78: DECODE( p_user_status_id, FND_API.G_MISS_NUM, NULL, p_user_status_id),

74: last_updated_by,
75: last_update_login
76: ) VALUES (
77: DECODE( px_na_rule_header_id, FND_API.G_MISS_NUM, NULL, px_na_rule_header_id),
78: DECODE( p_user_status_id, FND_API.G_MISS_NUM, NULL, p_user_status_id),
79: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
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),

Line 79: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),

75: last_update_login
76: ) VALUES (
77: DECODE( px_na_rule_header_id, FND_API.G_MISS_NUM, NULL, px_na_rule_header_id),
78: DECODE( p_user_status_id, FND_API.G_MISS_NUM, NULL, p_user_status_id),
79: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
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),

Line 80: DECODE( p_start_date, FND_API.G_MISS_DATE, NULL, p_start_date),

76: ) VALUES (
77: DECODE( px_na_rule_header_id, FND_API.G_MISS_NUM, NULL, px_na_rule_header_id),
78: DECODE( p_user_status_id, FND_API.G_MISS_NUM, NULL, p_user_status_id),
79: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
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),

Line 81: DECODE( p_end_date, FND_API.G_MISS_DATE, NULL, p_end_date),

77: DECODE( px_na_rule_header_id, FND_API.G_MISS_NUM, NULL, px_na_rule_header_id),
78: DECODE( p_user_status_id, FND_API.G_MISS_NUM, NULL, p_user_status_id),
79: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
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),

Line 82: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),

78: DECODE( p_user_status_id, FND_API.G_MISS_NUM, NULL, p_user_status_id),
79: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
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),

Line 83: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),

79: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
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));

Line 84: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),

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:

Line 85: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_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:
89: INSERT INTO ozf_na_rule_headers_tl(

Line 86: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),

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 ,

Line 87: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));

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 ,

Line 102: DECODE( px_na_rule_header_id, FND_API.G_MISS_NUM, NULL, px_na_rule_header_id),

98: name ,
99: description
100: )
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),

Line 110: DECODE( p_name, FND_API.G_MISS_CHAR, NULL, p_name),

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
113: WHERE l.installed_flag IN ('I','B')
114: AND NOT EXISTS(SELECT NULL FROM ozf_na_rule_headers_tl t

Line 111: DECODE( p_description, FND_API.G_MISS_CHAR, NULL, p_description)

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
113: WHERE l.installed_flag IN ('I','B')
114: AND NOT EXISTS(SELECT NULL FROM ozf_na_rule_headers_tl t
115: WHERE t.na_rule_header_id = DECODE( px_na_rule_header_id, FND_API.G_MISS_NUM, NULL, px_na_rule_header_id)

Line 115: WHERE t.na_rule_header_id = DECODE( px_na_rule_header_id, FND_API.G_MISS_NUM, NULL, px_na_rule_header_id)

111: DECODE( p_description, FND_API.G_MISS_CHAR, NULL, p_description)
112: FROM fnd_languages l
113: WHERE l.installed_flag IN ('I','B')
114: AND NOT EXISTS(SELECT NULL FROM ozf_na_rule_headers_tl t
115: WHERE t.na_rule_header_id = DECODE( px_na_rule_header_id, FND_API.G_MISS_NUM, NULL, px_na_rule_header_id)
116: AND t.language = l.language_code);
117: END Insert_Row;
118:
119:

Line 152: na_rule_header_id = DECODE( p_na_rule_header_id, null, na_rule_header_id, FND_API.G_MISS_NUM, null, p_na_rule_header_id),

148: IS
149: BEGIN
150: Update ozf_na_rule_headers_b
151: SET
152: na_rule_header_id = DECODE( p_na_rule_header_id, null, na_rule_header_id, FND_API.G_MISS_NUM, null, p_na_rule_header_id),
153: user_status_id = DECODE( p_user_status_id, null, user_status_id, FND_API.G_MISS_NUM, null, p_user_status_id),
154: status_code = DECODE( p_status_code, null, status_code, FND_API.g_miss_char, null, p_status_code),
155: start_date = DECODE( p_start_date, null, start_date, FND_API.G_MISS_DATE, null, p_start_date),
156: end_date = DECODE( p_end_date, null, end_date, FND_API.G_MISS_DATE, null, p_end_date),

Line 153: user_status_id = DECODE( p_user_status_id, null, user_status_id, FND_API.G_MISS_NUM, null, p_user_status_id),

149: BEGIN
150: Update ozf_na_rule_headers_b
151: SET
152: na_rule_header_id = DECODE( p_na_rule_header_id, null, na_rule_header_id, FND_API.G_MISS_NUM, null, p_na_rule_header_id),
153: user_status_id = DECODE( p_user_status_id, null, user_status_id, FND_API.G_MISS_NUM, null, p_user_status_id),
154: status_code = DECODE( p_status_code, null, status_code, FND_API.g_miss_char, null, p_status_code),
155: start_date = DECODE( p_start_date, null, start_date, FND_API.G_MISS_DATE, null, p_start_date),
156: end_date = DECODE( p_end_date, null, end_date, FND_API.G_MISS_DATE, null, p_end_date),
157: object_version_number = nvl(p_object_version_number,0) + 1 ,

Line 154: status_code = DECODE( p_status_code, null, status_code, FND_API.g_miss_char, null, p_status_code),

150: Update ozf_na_rule_headers_b
151: SET
152: na_rule_header_id = DECODE( p_na_rule_header_id, null, na_rule_header_id, FND_API.G_MISS_NUM, null, p_na_rule_header_id),
153: user_status_id = DECODE( p_user_status_id, null, user_status_id, FND_API.G_MISS_NUM, null, p_user_status_id),
154: status_code = DECODE( p_status_code, null, status_code, FND_API.g_miss_char, null, p_status_code),
155: start_date = DECODE( p_start_date, null, start_date, FND_API.G_MISS_DATE, null, p_start_date),
156: end_date = DECODE( p_end_date, null, end_date, FND_API.G_MISS_DATE, null, p_end_date),
157: object_version_number = nvl(p_object_version_number,0) + 1 ,
158: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),

Line 155: start_date = DECODE( p_start_date, null, start_date, FND_API.G_MISS_DATE, null, p_start_date),

151: SET
152: na_rule_header_id = DECODE( p_na_rule_header_id, null, na_rule_header_id, FND_API.G_MISS_NUM, null, p_na_rule_header_id),
153: user_status_id = DECODE( p_user_status_id, null, user_status_id, FND_API.G_MISS_NUM, null, p_user_status_id),
154: status_code = DECODE( p_status_code, null, status_code, FND_API.g_miss_char, null, p_status_code),
155: start_date = DECODE( p_start_date, null, start_date, FND_API.G_MISS_DATE, null, p_start_date),
156: end_date = DECODE( p_end_date, null, end_date, FND_API.G_MISS_DATE, null, p_end_date),
157: object_version_number = nvl(p_object_version_number,0) + 1 ,
158: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
159: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),

Line 156: end_date = DECODE( p_end_date, null, end_date, FND_API.G_MISS_DATE, null, p_end_date),

152: na_rule_header_id = DECODE( p_na_rule_header_id, null, na_rule_header_id, FND_API.G_MISS_NUM, null, p_na_rule_header_id),
153: user_status_id = DECODE( p_user_status_id, null, user_status_id, FND_API.G_MISS_NUM, null, p_user_status_id),
154: status_code = DECODE( p_status_code, null, status_code, FND_API.g_miss_char, null, p_status_code),
155: start_date = DECODE( p_start_date, null, start_date, FND_API.G_MISS_DATE, null, p_start_date),
156: end_date = DECODE( p_end_date, null, end_date, FND_API.G_MISS_DATE, null, p_end_date),
157: object_version_number = nvl(p_object_version_number,0) + 1 ,
158: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
159: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
160: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)

Line 158: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),

154: status_code = DECODE( p_status_code, null, status_code, FND_API.g_miss_char, null, p_status_code),
155: start_date = DECODE( p_start_date, null, start_date, FND_API.G_MISS_DATE, null, p_start_date),
156: end_date = DECODE( p_end_date, null, end_date, FND_API.G_MISS_DATE, null, p_end_date),
157: object_version_number = nvl(p_object_version_number,0) + 1 ,
158: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
159: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
160: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)
161: WHERE na_rule_header_id = p_na_rule_header_id
162: AND object_version_number = p_object_version_number;

Line 159: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),

155: start_date = DECODE( p_start_date, null, start_date, FND_API.G_MISS_DATE, null, p_start_date),
156: end_date = DECODE( p_end_date, null, end_date, FND_API.G_MISS_DATE, null, p_end_date),
157: object_version_number = nvl(p_object_version_number,0) + 1 ,
158: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
159: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
160: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)
161: WHERE na_rule_header_id = p_na_rule_header_id
162: AND object_version_number = p_object_version_number;
163:

Line 160: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)

156: end_date = DECODE( p_end_date, null, end_date, FND_API.G_MISS_DATE, null, p_end_date),
157: object_version_number = nvl(p_object_version_number,0) + 1 ,
158: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
159: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
160: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)
161: WHERE na_rule_header_id = p_na_rule_header_id
162: AND object_version_number = p_object_version_number;
163:
164: UPDATE ozf_na_rule_headers_tl

Line 165: set name = DECODE( p_name, null, name, FND_API.g_miss_char, null, p_name),

161: WHERE na_rule_header_id = p_na_rule_header_id
162: AND object_version_number = p_object_version_number;
163:
164: UPDATE ozf_na_rule_headers_tl
165: set name = DECODE( p_name, null, name, FND_API.g_miss_char, null, p_name),
166: description = DECODE( p_description, null, description, FND_API.g_miss_char, null, p_description),
167: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
168: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
169: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),

Line 166: description = DECODE( p_description, null, description, FND_API.g_miss_char, null, p_description),

162: AND object_version_number = p_object_version_number;
163:
164: UPDATE ozf_na_rule_headers_tl
165: set name = DECODE( p_name, null, name, FND_API.g_miss_char, null, p_name),
166: description = DECODE( p_description, null, description, FND_API.g_miss_char, null, p_description),
167: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
168: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
169: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
170: source_lang = USERENV('LANG')

Line 167: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),

163:
164: UPDATE ozf_na_rule_headers_tl
165: set name = DECODE( p_name, null, name, FND_API.g_miss_char, null, p_name),
166: description = DECODE( p_description, null, description, FND_API.g_miss_char, null, p_description),
167: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
168: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
169: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
170: source_lang = USERENV('LANG')
171: WHERE na_rule_header_id = p_na_rule_header_id

Line 168: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),

164: UPDATE ozf_na_rule_headers_tl
165: set name = DECODE( p_name, null, name, FND_API.g_miss_char, null, p_name),
166: description = DECODE( p_description, null, description, FND_API.g_miss_char, null, p_description),
167: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
168: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
169: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
170: source_lang = USERENV('LANG')
171: WHERE na_rule_header_id = p_na_rule_header_id
172: AND USERENV('LANG') IN (language, source_lang);

Line 169: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),

165: set name = DECODE( p_name, null, name, FND_API.g_miss_char, null, p_name),
166: description = DECODE( p_description, null, description, FND_API.g_miss_char, null, p_description),
167: last_update_date = DECODE( p_last_update_date, to_date(NULL), last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
168: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
169: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
170: source_lang = USERENV('LANG')
171: WHERE na_rule_header_id = p_na_rule_header_id
172: AND USERENV('LANG') IN (language, source_lang);
173:

Line 175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

171: WHERE na_rule_header_id = p_na_rule_header_id
172: AND USERENV('LANG') IN (language, source_lang);
173:
174: IF (SQL%NOTFOUND) THEN
175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
176: END IF;
177:
178:
179: END Update_Row;

Line 205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

201: DELETE FROM ozf_na_rule_headers_b
202: WHERE na_rule_header_id = p_na_rule_header_id
203: AND object_version_number = p_object_version_number;
204: If (SQL%NOTFOUND) then
205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
206: End If;
207:
208: DELETE FROM ozf_na_rule_headers_tl
209: WHERE na_rule_header_id = p_na_rule_header_id;

Line 212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

208: DELETE FROM ozf_na_rule_headers_tl
209: WHERE na_rule_header_id = p_na_rule_header_id;
210:
211: If (SQL%NOTFOUND) then
212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
213: End If;
214:
215: END Delete_Row ;
216:

Line 251: RAISE FND_API.g_exc_error;

247: FETCH c INTO Recinfo;
248: IF (c%NOTFOUND) THEN
249: CLOSE c;
250: AMS_Utility_PVT.error_message ('AMS_API_RECORD_NOT_FOUND');
251: RAISE FND_API.g_exc_error;
252: END IF;
253: CLOSE c;
254: END Lock_Row;
255: