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.AMS_DM_TARGET_VALUES_B_PKG dependencies on FND_API

Line 76: DECODE( px_target_value_id, FND_API.g_miss_num, NULL, px_target_value_id),

72: target_value,
73: target_operator,
74: range_value
75: ) VALUES (
76: DECODE( px_target_value_id, FND_API.g_miss_num, NULL, px_target_value_id),
77: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
78: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
79: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
80: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),

Line 77: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),

73: target_operator,
74: range_value
75: ) VALUES (
76: DECODE( px_target_value_id, FND_API.g_miss_num, NULL, px_target_value_id),
77: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
78: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
79: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
80: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
81: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),

Line 78: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),

74: range_value
75: ) VALUES (
76: DECODE( px_target_value_id, FND_API.g_miss_num, NULL, px_target_value_id),
77: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
78: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
79: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
80: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
81: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
82: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),

Line 79: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),

75: ) VALUES (
76: DECODE( px_target_value_id, FND_API.g_miss_num, NULL, px_target_value_id),
77: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
78: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
79: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
80: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
81: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
82: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
83: DECODE( p_target_id, FND_API.g_miss_num, NULL, p_target_id),

Line 80: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),

76: DECODE( px_target_value_id, FND_API.g_miss_num, NULL, px_target_value_id),
77: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
78: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
79: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
80: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
81: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
82: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
83: DECODE( p_target_id, FND_API.g_miss_num, NULL, p_target_id),
84: DECODE( p_target_value, FND_API.g_miss_char, NULL, p_target_value),

Line 81: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),

77: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
78: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
79: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
80: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
81: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
82: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
83: DECODE( p_target_id, FND_API.g_miss_num, NULL, p_target_id),
84: DECODE( p_target_value, FND_API.g_miss_char, NULL, p_target_value),
85: DECODE( p_target_operator, FND_API.g_miss_char, NULL, p_target_operator),

Line 82: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),

78: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
79: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
80: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
81: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
82: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
83: DECODE( p_target_id, FND_API.g_miss_num, NULL, p_target_id),
84: DECODE( p_target_value, FND_API.g_miss_char, NULL, p_target_value),
85: DECODE( p_target_operator, FND_API.g_miss_char, NULL, p_target_operator),
86: DECODE( p_range_value, FND_API.g_miss_char, NULL, p_range_value)

Line 83: DECODE( p_target_id, FND_API.g_miss_num, NULL, p_target_id),

79: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
80: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
81: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
82: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
83: DECODE( p_target_id, FND_API.g_miss_num, NULL, p_target_id),
84: DECODE( p_target_value, FND_API.g_miss_char, NULL, p_target_value),
85: DECODE( p_target_operator, FND_API.g_miss_char, NULL, p_target_operator),
86: DECODE( p_range_value, FND_API.g_miss_char, NULL, p_range_value)
87: );

Line 84: DECODE( p_target_value, FND_API.g_miss_char, NULL, p_target_value),

80: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
81: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
82: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
83: DECODE( p_target_id, FND_API.g_miss_num, NULL, p_target_id),
84: DECODE( p_target_value, FND_API.g_miss_char, NULL, p_target_value),
85: DECODE( p_target_operator, FND_API.g_miss_char, NULL, p_target_operator),
86: DECODE( p_range_value, FND_API.g_miss_char, NULL, p_range_value)
87: );
88:

Line 85: DECODE( p_target_operator, FND_API.g_miss_char, NULL, p_target_operator),

81: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
82: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
83: DECODE( p_target_id, FND_API.g_miss_num, NULL, p_target_id),
84: DECODE( p_target_value, FND_API.g_miss_char, NULL, p_target_value),
85: DECODE( p_target_operator, FND_API.g_miss_char, NULL, p_target_operator),
86: DECODE( p_range_value, FND_API.g_miss_char, NULL, p_range_value)
87: );
88:
89: -- Insert target value description into TL table

Line 86: DECODE( p_range_value, FND_API.g_miss_char, NULL, p_range_value)

82: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
83: DECODE( p_target_id, FND_API.g_miss_num, NULL, p_target_id),
84: DECODE( p_target_value, FND_API.g_miss_char, NULL, p_target_value),
85: DECODE( p_target_operator, FND_API.g_miss_char, NULL, p_target_operator),
86: DECODE( p_range_value, FND_API.g_miss_char, NULL, p_range_value)
87: );
88:
89: -- Insert target value description into TL table
90: INSERT INTO ams_dm_target_values_tl(

Line 102: decode( px_target_value_id, FND_API.G_MISS_NUM, NULL, px_target_value_id),

98: source_lang,
99: description
100: )
101: SELECT
102: decode( px_target_value_id, FND_API.G_MISS_NUM, NULL, px_target_value_id),
103: l.language_code,
104: SYSDATE,
105: FND_GLOBAL.user_id,
106: SYSDATE,

Line 110: decode( p_description, FND_API.G_MISS_CHAR, NULL, p_description)

106: SYSDATE,
107: FND_GLOBAL.user_id,
108: FND_GLOBAL.conc_login_id,
109: USERENV('LANG'),
110: decode( p_description, FND_API.G_MISS_CHAR, NULL, p_description)
111: FROM fnd_languages l
112: WHERE l.installed_flag in ('I', 'B')
113: AND NOT EXISTS(
114: SELECT NULL

Line 116: WHERE t.target_value_id = decode( px_target_value_id, FND_API.G_MISS_NUM, NULL, px_target_value_id)

112: WHERE l.installed_flag in ('I', 'B')
113: AND NOT EXISTS(
114: SELECT NULL
115: FROM ams_dm_target_values_tl t
116: WHERE t.target_value_id = decode( px_target_value_id, FND_API.G_MISS_NUM, NULL, px_target_value_id)
117: AND t.language = l.language_code );
118: END Insert_Row;
119:
120:

Line 148: target_value_id = DECODE( p_target_value_id, FND_API.g_miss_num, target_value_id, p_target_value_id),

144: IS
145: BEGIN
146: Update AMS_DM_TARGET_VALUES_B
147: SET
148: target_value_id = DECODE( p_target_value_id, FND_API.g_miss_num, target_value_id, p_target_value_id),
149: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
150: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
151: last_update_login = DECODE( p_last_update_login,FND_API.g_miss_num, last_update_login, p_last_update_login),
152: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),

Line 149: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),

145: BEGIN
146: Update AMS_DM_TARGET_VALUES_B
147: SET
148: target_value_id = DECODE( p_target_value_id, FND_API.g_miss_num, target_value_id, p_target_value_id),
149: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
150: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
151: last_update_login = DECODE( p_last_update_login,FND_API.g_miss_num, last_update_login, p_last_update_login),
152: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
153: target_id = DECODE( p_target_id, FND_API.g_miss_num, target_id, p_target_id),

Line 150: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),

146: Update AMS_DM_TARGET_VALUES_B
147: SET
148: target_value_id = DECODE( p_target_value_id, FND_API.g_miss_num, target_value_id, p_target_value_id),
149: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
150: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
151: last_update_login = DECODE( p_last_update_login,FND_API.g_miss_num, last_update_login, p_last_update_login),
152: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
153: target_id = DECODE( p_target_id, FND_API.g_miss_num, target_id, p_target_id),
154: target_value = DECODE( p_target_value, FND_API.g_miss_char, target_value, p_target_value),

Line 151: last_update_login = DECODE( p_last_update_login,FND_API.g_miss_num, last_update_login, p_last_update_login),

147: SET
148: target_value_id = DECODE( p_target_value_id, FND_API.g_miss_num, target_value_id, p_target_value_id),
149: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
150: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
151: last_update_login = DECODE( p_last_update_login,FND_API.g_miss_num, last_update_login, p_last_update_login),
152: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
153: target_id = DECODE( p_target_id, FND_API.g_miss_num, target_id, p_target_id),
154: target_value = DECODE( p_target_value, FND_API.g_miss_char, target_value, p_target_value),
155: target_operator = DECODE( p_target_operator, FND_API.g_miss_char, target_operator, p_target_operator),

Line 152: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),

148: target_value_id = DECODE( p_target_value_id, FND_API.g_miss_num, target_value_id, p_target_value_id),
149: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
150: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
151: last_update_login = DECODE( p_last_update_login,FND_API.g_miss_num, last_update_login, p_last_update_login),
152: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
153: target_id = DECODE( p_target_id, FND_API.g_miss_num, target_id, p_target_id),
154: target_value = DECODE( p_target_value, FND_API.g_miss_char, target_value, p_target_value),
155: target_operator = DECODE( p_target_operator, FND_API.g_miss_char, target_operator, p_target_operator),
156: range_value = DECODE( p_range_value, FND_API.g_miss_char, range_value, p_range_value)

Line 153: target_id = DECODE( p_target_id, FND_API.g_miss_num, target_id, p_target_id),

149: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
150: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
151: last_update_login = DECODE( p_last_update_login,FND_API.g_miss_num, last_update_login, p_last_update_login),
152: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
153: target_id = DECODE( p_target_id, FND_API.g_miss_num, target_id, p_target_id),
154: target_value = DECODE( p_target_value, FND_API.g_miss_char, target_value, p_target_value),
155: target_operator = DECODE( p_target_operator, FND_API.g_miss_char, target_operator, p_target_operator),
156: range_value = DECODE( p_range_value, FND_API.g_miss_char, range_value, p_range_value)
157: WHERE TARGET_VALUE_ID = p_TARGET_VALUE_ID

Line 154: target_value = DECODE( p_target_value, FND_API.g_miss_char, target_value, p_target_value),

150: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
151: last_update_login = DECODE( p_last_update_login,FND_API.g_miss_num, last_update_login, p_last_update_login),
152: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
153: target_id = DECODE( p_target_id, FND_API.g_miss_num, target_id, p_target_id),
154: target_value = DECODE( p_target_value, FND_API.g_miss_char, target_value, p_target_value),
155: target_operator = DECODE( p_target_operator, FND_API.g_miss_char, target_operator, p_target_operator),
156: range_value = DECODE( p_range_value, FND_API.g_miss_char, range_value, p_range_value)
157: WHERE TARGET_VALUE_ID = p_TARGET_VALUE_ID
158: ;

Line 155: target_operator = DECODE( p_target_operator, FND_API.g_miss_char, target_operator, p_target_operator),

151: last_update_login = DECODE( p_last_update_login,FND_API.g_miss_num, last_update_login, p_last_update_login),
152: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
153: target_id = DECODE( p_target_id, FND_API.g_miss_num, target_id, p_target_id),
154: target_value = DECODE( p_target_value, FND_API.g_miss_char, target_value, p_target_value),
155: target_operator = DECODE( p_target_operator, FND_API.g_miss_char, target_operator, p_target_operator),
156: range_value = DECODE( p_range_value, FND_API.g_miss_char, range_value, p_range_value)
157: WHERE TARGET_VALUE_ID = p_TARGET_VALUE_ID
158: ;
159:

Line 156: range_value = DECODE( p_range_value, FND_API.g_miss_char, range_value, p_range_value)

152: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
153: target_id = DECODE( p_target_id, FND_API.g_miss_num, target_id, p_target_id),
154: target_value = DECODE( p_target_value, FND_API.g_miss_char, target_value, p_target_value),
155: target_operator = DECODE( p_target_operator, FND_API.g_miss_char, target_operator, p_target_operator),
156: range_value = DECODE( p_range_value, FND_API.g_miss_char, range_value, p_range_value)
157: WHERE TARGET_VALUE_ID = p_TARGET_VALUE_ID
158: ;
159:
160: IF (SQL%NOTFOUND) THEN

Line 161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

157: WHERE TARGET_VALUE_ID = p_TARGET_VALUE_ID
158: ;
159:
160: IF (SQL%NOTFOUND) THEN
161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
162: END IF;
163:
164: -- update target value description in TL table
165: update ams_dm_target_values_tl set

Line 166: description = decode( p_description, FND_API.G_MISS_CHAR, DESCRIPTION, p_description),

162: END IF;
163:
164: -- update target value description in TL table
165: update ams_dm_target_values_tl set
166: description = decode( p_description, FND_API.G_MISS_CHAR, DESCRIPTION, p_description),
167: last_update_date = SYSDATE,
168: last_updated_by = FND_GLOBAL.user_id,
169: last_update_login = FND_GLOBAL.conc_login_id,
170: source_lang = USERENV('LANG')

Line 197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

193: BEGIN
194: DELETE FROM AMS_DM_TARGET_VALUES_B
195: WHERE TARGET_VALUE_ID = p_TARGET_VALUE_ID;
196: If (SQL%NOTFOUND) then
197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
198: End If;
199:
200:
201: DELETE FROM ams_dm_target_values_tl

Line 204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

200:
201: DELETE FROM ams_dm_target_values_tl
202: WHERE TARGET_VALUE_ID = p_TARGET_VALUE_ID;
203: If (SQL%NOTFOUND) then
204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
205: End If;
206:
207: END Delete_Row ;
208: