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_LINE_PKG dependencies on FND_API

Line 72: DECODE( px_na_rule_line_id, FND_API.G_MISS_NUM, NULL, px_na_rule_line_id),

68: last_update_date,
69: last_updated_by,
70: last_update_login
71: ) VALUES (
72: DECODE( px_na_rule_line_id, FND_API.G_MISS_NUM, NULL, px_na_rule_line_id),
73: DECODE( p_na_rule_header_id, FND_API.G_MISS_NUM, NULL, p_na_rule_header_id),
74: DECODE( p_na_deduction_rule_id, FND_API.G_MISS_NUM, NULL, p_na_deduction_rule_id),
75: DECODE( p_active_flag, FND_API.g_miss_char, NULL, p_active_flag),
76: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),

Line 73: DECODE( p_na_rule_header_id, FND_API.G_MISS_NUM, NULL, p_na_rule_header_id),

69: last_updated_by,
70: last_update_login
71: ) VALUES (
72: DECODE( px_na_rule_line_id, FND_API.G_MISS_NUM, NULL, px_na_rule_line_id),
73: DECODE( p_na_rule_header_id, FND_API.G_MISS_NUM, NULL, p_na_rule_header_id),
74: DECODE( p_na_deduction_rule_id, FND_API.G_MISS_NUM, NULL, p_na_deduction_rule_id),
75: DECODE( p_active_flag, FND_API.g_miss_char, NULL, p_active_flag),
76: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
77: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),

Line 74: DECODE( p_na_deduction_rule_id, FND_API.G_MISS_NUM, NULL, p_na_deduction_rule_id),

70: last_update_login
71: ) VALUES (
72: DECODE( px_na_rule_line_id, FND_API.G_MISS_NUM, NULL, px_na_rule_line_id),
73: DECODE( p_na_rule_header_id, FND_API.G_MISS_NUM, NULL, p_na_rule_header_id),
74: DECODE( p_na_deduction_rule_id, FND_API.G_MISS_NUM, NULL, p_na_deduction_rule_id),
75: DECODE( p_active_flag, FND_API.g_miss_char, NULL, p_active_flag),
76: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
77: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
78: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),

Line 75: DECODE( p_active_flag, FND_API.g_miss_char, NULL, p_active_flag),

71: ) VALUES (
72: DECODE( px_na_rule_line_id, FND_API.G_MISS_NUM, NULL, px_na_rule_line_id),
73: DECODE( p_na_rule_header_id, FND_API.G_MISS_NUM, NULL, p_na_rule_header_id),
74: DECODE( p_na_deduction_rule_id, FND_API.G_MISS_NUM, NULL, p_na_deduction_rule_id),
75: DECODE( p_active_flag, FND_API.g_miss_char, NULL, p_active_flag),
76: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
77: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
78: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
79: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),

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

72: DECODE( px_na_rule_line_id, FND_API.G_MISS_NUM, NULL, px_na_rule_line_id),
73: DECODE( p_na_rule_header_id, FND_API.G_MISS_NUM, NULL, p_na_rule_header_id),
74: DECODE( p_na_deduction_rule_id, FND_API.G_MISS_NUM, NULL, p_na_deduction_rule_id),
75: DECODE( p_active_flag, FND_API.g_miss_char, NULL, p_active_flag),
76: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
77: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
78: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
79: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
80: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),

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

73: DECODE( p_na_rule_header_id, FND_API.G_MISS_NUM, NULL, p_na_rule_header_id),
74: DECODE( p_na_deduction_rule_id, FND_API.G_MISS_NUM, NULL, p_na_deduction_rule_id),
75: DECODE( p_active_flag, FND_API.g_miss_char, NULL, p_active_flag),
76: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
77: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
78: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
79: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
80: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
81: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));

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

74: DECODE( p_na_deduction_rule_id, FND_API.G_MISS_NUM, NULL, p_na_deduction_rule_id),
75: DECODE( p_active_flag, FND_API.g_miss_char, NULL, p_active_flag),
76: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
77: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
78: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
79: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
80: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
81: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));
82:

Line 79: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),

75: DECODE( p_active_flag, FND_API.g_miss_char, NULL, p_active_flag),
76: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
77: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
78: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
79: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
80: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
81: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));
82:
83: END Insert_Row;

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

76: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
77: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
78: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
79: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
80: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
81: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));
82:
83: END Insert_Row;
84:

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

77: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
78: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
79: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
80: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
81: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));
82:
83: END Insert_Row;
84:
85:

Line 114: na_rule_line_id = DECODE( p_na_rule_line_id, null, na_rule_line_id, FND_API.G_MISS_NUM, null, p_na_rule_line_id),

110: IS
111: BEGIN
112: Update ozf_na_rule_lines
113: SET
114: na_rule_line_id = DECODE( p_na_rule_line_id, null, na_rule_line_id, FND_API.G_MISS_NUM, null, p_na_rule_line_id),
115: 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),
116: na_deduction_rule_id = DECODE( p_na_deduction_rule_id, null, na_deduction_rule_id, FND_API.G_MISS_NUM, null, p_na_deduction_rule_id),
117: active_flag = DECODE( p_active_flag, null, active_flag, FND_API.g_miss_char, null, p_active_flag),
118: object_version_number = nvl(p_object_version_number,0) + 1 ,

Line 115: 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),

111: BEGIN
112: Update ozf_na_rule_lines
113: SET
114: na_rule_line_id = DECODE( p_na_rule_line_id, null, na_rule_line_id, FND_API.G_MISS_NUM, null, p_na_rule_line_id),
115: 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),
116: na_deduction_rule_id = DECODE( p_na_deduction_rule_id, null, na_deduction_rule_id, FND_API.G_MISS_NUM, null, p_na_deduction_rule_id),
117: active_flag = DECODE( p_active_flag, null, active_flag, FND_API.g_miss_char, null, p_active_flag),
118: object_version_number = nvl(p_object_version_number,0) + 1 ,
119: 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 116: na_deduction_rule_id = DECODE( p_na_deduction_rule_id, null, na_deduction_rule_id, FND_API.G_MISS_NUM, null, p_na_deduction_rule_id),

112: Update ozf_na_rule_lines
113: SET
114: na_rule_line_id = DECODE( p_na_rule_line_id, null, na_rule_line_id, FND_API.G_MISS_NUM, null, p_na_rule_line_id),
115: 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),
116: na_deduction_rule_id = DECODE( p_na_deduction_rule_id, null, na_deduction_rule_id, FND_API.G_MISS_NUM, null, p_na_deduction_rule_id),
117: active_flag = DECODE( p_active_flag, null, active_flag, FND_API.g_miss_char, null, p_active_flag),
118: object_version_number = nvl(p_object_version_number,0) + 1 ,
119: 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),
120: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),

Line 117: active_flag = DECODE( p_active_flag, null, active_flag, FND_API.g_miss_char, null, p_active_flag),

113: SET
114: na_rule_line_id = DECODE( p_na_rule_line_id, null, na_rule_line_id, FND_API.G_MISS_NUM, null, p_na_rule_line_id),
115: 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),
116: na_deduction_rule_id = DECODE( p_na_deduction_rule_id, null, na_deduction_rule_id, FND_API.G_MISS_NUM, null, p_na_deduction_rule_id),
117: active_flag = DECODE( p_active_flag, null, active_flag, FND_API.g_miss_char, null, p_active_flag),
118: object_version_number = nvl(p_object_version_number,0) + 1 ,
119: 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),
120: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
121: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)

Line 119: 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),

115: 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),
116: na_deduction_rule_id = DECODE( p_na_deduction_rule_id, null, na_deduction_rule_id, FND_API.G_MISS_NUM, null, p_na_deduction_rule_id),
117: active_flag = DECODE( p_active_flag, null, active_flag, FND_API.g_miss_char, null, p_active_flag),
118: object_version_number = nvl(p_object_version_number,0) + 1 ,
119: 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),
120: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
121: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)
122: WHERE na_rule_line_id = p_na_rule_line_id
123: AND object_version_number = p_object_version_number;

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

116: na_deduction_rule_id = DECODE( p_na_deduction_rule_id, null, na_deduction_rule_id, FND_API.G_MISS_NUM, null, p_na_deduction_rule_id),
117: active_flag = DECODE( p_active_flag, null, active_flag, FND_API.g_miss_char, null, p_active_flag),
118: object_version_number = nvl(p_object_version_number,0) + 1 ,
119: 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),
120: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
121: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)
122: WHERE na_rule_line_id = p_na_rule_line_id
123: AND object_version_number = p_object_version_number;
124:

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

117: active_flag = DECODE( p_active_flag, null, active_flag, FND_API.g_miss_char, null, p_active_flag),
118: object_version_number = nvl(p_object_version_number,0) + 1 ,
119: 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),
120: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
121: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)
122: WHERE na_rule_line_id = p_na_rule_line_id
123: AND object_version_number = p_object_version_number;
124:
125:

Line 127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

123: AND object_version_number = p_object_version_number;
124:
125:
126: IF (SQL%NOTFOUND) THEN
127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
128: END IF;
129:
130:
131: END Update_Row;

Line 157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

153: DELETE FROM ozf_na_rule_lines
154: WHERE na_rule_line_id = p_na_rule_line_id
155: AND object_version_number = p_object_version_number;
156: If (SQL%NOTFOUND) then
157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
158: End If;
159: END Delete_Row ;
160:
161:

Line 195: RAISE FND_API.g_exc_error;

191: FETCH c INTO Recinfo;
192: IF (c%NOTFOUND) THEN
193: CLOSE c;
194: AMS_Utility_PVT.error_message ('AMS_API_RECORD_NOT_FOUND');
195: RAISE FND_API.g_exc_error;
196: END IF;
197: CLOSE c;
198: END Lock_Row;
199: