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

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

79: data_source_id,
80: source_field_id,
81: target_source_id
82: ) VALUES (
83: DECODE( px_target_id, FND_API.g_miss_num, NULL, px_target_id),
84: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
85: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
86: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
87: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),

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

80: source_field_id,
81: target_source_id
82: ) VALUES (
83: DECODE( px_target_id, FND_API.g_miss_num, NULL, px_target_id),
84: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
85: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
86: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
87: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
88: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),

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

81: target_source_id
82: ) VALUES (
83: DECODE( px_target_id, FND_API.g_miss_num, NULL, px_target_id),
84: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
85: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
86: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
87: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
88: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
89: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),

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

82: ) VALUES (
83: DECODE( px_target_id, FND_API.g_miss_num, NULL, px_target_id),
84: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
85: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
86: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
87: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
88: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
89: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
90: DECODE( p_active_flag, FND_API.g_miss_char, NULL, p_active_flag),

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

83: DECODE( px_target_id, FND_API.g_miss_num, NULL, px_target_id),
84: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
85: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
86: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
87: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
88: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
89: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
90: DECODE( p_active_flag, FND_API.g_miss_char, NULL, p_active_flag),
91: DECODE( p_model_type, FND_API.g_miss_char, NULL, p_model_type),

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

84: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
85: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
86: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
87: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
88: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
89: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
90: DECODE( p_active_flag, FND_API.g_miss_char, NULL, p_active_flag),
91: DECODE( p_model_type, FND_API.g_miss_char, NULL, p_model_type),
92: DECODE( p_data_source_id, FND_API.g_miss_num, NULL, p_data_source_id),

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

85: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
86: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
87: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
88: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
89: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
90: DECODE( p_active_flag, FND_API.g_miss_char, NULL, p_active_flag),
91: DECODE( p_model_type, FND_API.g_miss_char, NULL, p_model_type),
92: DECODE( p_data_source_id, FND_API.g_miss_num, NULL, p_data_source_id),
93: DECODE( p_source_field_id, FND_API.g_miss_num, NULL, p_source_field_id),

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

86: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
87: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
88: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
89: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
90: DECODE( p_active_flag, FND_API.g_miss_char, NULL, p_active_flag),
91: DECODE( p_model_type, FND_API.g_miss_char, NULL, p_model_type),
92: DECODE( p_data_source_id, FND_API.g_miss_num, NULL, p_data_source_id),
93: DECODE( p_source_field_id, FND_API.g_miss_num, NULL, p_source_field_id),
94: DECODE( p_target_source_id, FND_API.g_miss_num, NULL, p_target_source_id));

Line 91: DECODE( p_model_type, FND_API.g_miss_char, NULL, p_model_type),

87: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
88: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
89: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
90: DECODE( p_active_flag, FND_API.g_miss_char, NULL, p_active_flag),
91: DECODE( p_model_type, FND_API.g_miss_char, NULL, p_model_type),
92: DECODE( p_data_source_id, FND_API.g_miss_num, NULL, p_data_source_id),
93: DECODE( p_source_field_id, FND_API.g_miss_num, NULL, p_source_field_id),
94: DECODE( p_target_source_id, FND_API.g_miss_num, NULL, p_target_source_id));
95:

Line 92: DECODE( p_data_source_id, FND_API.g_miss_num, NULL, p_data_source_id),

88: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
89: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
90: DECODE( p_active_flag, FND_API.g_miss_char, NULL, p_active_flag),
91: DECODE( p_model_type, FND_API.g_miss_char, NULL, p_model_type),
92: DECODE( p_data_source_id, FND_API.g_miss_num, NULL, p_data_source_id),
93: DECODE( p_source_field_id, FND_API.g_miss_num, NULL, p_source_field_id),
94: DECODE( p_target_source_id, FND_API.g_miss_num, NULL, p_target_source_id));
95:
96: -- Insert target_name and description into TL table

Line 93: DECODE( p_source_field_id, FND_API.g_miss_num, NULL, p_source_field_id),

89: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
90: DECODE( p_active_flag, FND_API.g_miss_char, NULL, p_active_flag),
91: DECODE( p_model_type, FND_API.g_miss_char, NULL, p_model_type),
92: DECODE( p_data_source_id, FND_API.g_miss_num, NULL, p_data_source_id),
93: DECODE( p_source_field_id, FND_API.g_miss_num, NULL, p_source_field_id),
94: DECODE( p_target_source_id, FND_API.g_miss_num, NULL, p_target_source_id));
95:
96: -- Insert target_name and description into TL table
97: INSERT INTO ams_dm_targets_tl(

Line 94: DECODE( p_target_source_id, FND_API.g_miss_num, NULL, p_target_source_id));

90: DECODE( p_active_flag, FND_API.g_miss_char, NULL, p_active_flag),
91: DECODE( p_model_type, FND_API.g_miss_char, NULL, p_model_type),
92: DECODE( p_data_source_id, FND_API.g_miss_num, NULL, p_data_source_id),
93: DECODE( p_source_field_id, FND_API.g_miss_num, NULL, p_source_field_id),
94: DECODE( p_target_source_id, FND_API.g_miss_num, NULL, p_target_source_id));
95:
96: -- Insert target_name and description into TL table
97: INSERT INTO ams_dm_targets_tl(
98: target_id,

Line 110: decode( px_target_id, FND_API.G_MISS_NUM, NULL, px_target_id),

106: target_name,
107: description
108: )
109: SELECT
110: decode( px_target_id, FND_API.G_MISS_NUM, NULL, px_target_id),
111: l.language_code,
112: SYSDATE,
113: FND_GLOBAL.user_id,
114: SYSDATE,

Line 118: decode( p_target_name, FND_API.G_MISS_CHAR, NULL, p_target_name),

114: SYSDATE,
115: FND_GLOBAL.user_id,
116: FND_GLOBAL.conc_login_id,
117: USERENV('LANG'),
118: decode( p_target_name, FND_API.G_MISS_CHAR, NULL, p_target_name),
119: decode( p_description, FND_API.G_MISS_CHAR, NULL, p_description)
120: FROM fnd_languages l
121: WHERE l.installed_flag in ('I', 'B')
122: AND NOT EXISTS(

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

115: FND_GLOBAL.user_id,
116: FND_GLOBAL.conc_login_id,
117: USERENV('LANG'),
118: decode( p_target_name, FND_API.G_MISS_CHAR, NULL, p_target_name),
119: decode( p_description, FND_API.G_MISS_CHAR, NULL, p_description)
120: FROM fnd_languages l
121: WHERE l.installed_flag in ('I', 'B')
122: AND NOT EXISTS(
123: SELECT NULL

Line 125: WHERE t.target_id = decode( px_target_id, FND_API.G_MISS_NUM, NULL, px_target_id)

121: WHERE l.installed_flag in ('I', 'B')
122: AND NOT EXISTS(
123: SELECT NULL
124: FROM ams_dm_targets_tl t
125: WHERE t.target_id = decode( px_target_id, FND_API.G_MISS_NUM, NULL, px_target_id)
126: AND t.language = l.language_code );
127:
128:
129: END Insert_Row;

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

180: AMS_UTILITY_PVT.debug_message(p_data_source_id || ' ' || p_source_field_id);
181: END IF;
182: Update AMS_DM_TARGETS_B
183: SET
184: target_id = DECODE( p_target_id, FND_API.g_miss_num, target_id, p_target_id),
185: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
186: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
187: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
188: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),

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

181: END IF;
182: Update AMS_DM_TARGETS_B
183: SET
184: target_id = DECODE( p_target_id, FND_API.g_miss_num, target_id, p_target_id),
185: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
186: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
187: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
188: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
189: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

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

182: Update AMS_DM_TARGETS_B
183: SET
184: target_id = DECODE( p_target_id, FND_API.g_miss_num, target_id, p_target_id),
185: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
186: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
187: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
188: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
189: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
190: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),

Line 187: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),

183: SET
184: target_id = DECODE( p_target_id, FND_API.g_miss_num, target_id, p_target_id),
185: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
186: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
187: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
188: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
189: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
190: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
191: active_flag = DECODE( p_active_flag, FND_API.g_miss_char, active_flag, p_active_flag),

Line 188: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),

184: target_id = DECODE( p_target_id, FND_API.g_miss_num, target_id, p_target_id),
185: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
186: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
187: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
188: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
189: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
190: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
191: active_flag = DECODE( p_active_flag, FND_API.g_miss_char, active_flag, p_active_flag),
192: model_type = DECODE( p_model_type, FND_API.g_miss_char, model_type, p_model_type),

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

185: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
186: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
187: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
188: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
189: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
190: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
191: active_flag = DECODE( p_active_flag, FND_API.g_miss_char, active_flag, p_active_flag),
192: model_type = DECODE( p_model_type, FND_API.g_miss_char, model_type, p_model_type),
193: data_source_id = DECODE( p_data_source_id, FND_API.g_miss_num, data_source_id, p_data_source_id),

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

186: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
187: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
188: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
189: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
190: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
191: active_flag = DECODE( p_active_flag, FND_API.g_miss_char, active_flag, p_active_flag),
192: model_type = DECODE( p_model_type, FND_API.g_miss_char, model_type, p_model_type),
193: data_source_id = DECODE( p_data_source_id, FND_API.g_miss_num, data_source_id, p_data_source_id),
194: source_field_id = DECODE( p_source_field_id, FND_API.g_miss_num, source_field_id, p_source_field_id),

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

187: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
188: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
189: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
190: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
191: active_flag = DECODE( p_active_flag, FND_API.g_miss_char, active_flag, p_active_flag),
192: model_type = DECODE( p_model_type, FND_API.g_miss_char, model_type, p_model_type),
193: data_source_id = DECODE( p_data_source_id, FND_API.g_miss_num, data_source_id, p_data_source_id),
194: source_field_id = DECODE( p_source_field_id, FND_API.g_miss_num, source_field_id, p_source_field_id),
195: target_source_id = DECODE( p_target_source_id, FND_API.g_miss_num, target_source_id, p_target_source_id)

Line 192: model_type = DECODE( p_model_type, FND_API.g_miss_char, model_type, p_model_type),

188: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
189: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
190: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
191: active_flag = DECODE( p_active_flag, FND_API.g_miss_char, active_flag, p_active_flag),
192: model_type = DECODE( p_model_type, FND_API.g_miss_char, model_type, p_model_type),
193: data_source_id = DECODE( p_data_source_id, FND_API.g_miss_num, data_source_id, p_data_source_id),
194: source_field_id = DECODE( p_source_field_id, FND_API.g_miss_num, source_field_id, p_source_field_id),
195: target_source_id = DECODE( p_target_source_id, FND_API.g_miss_num, target_source_id, p_target_source_id)
196: WHERE TARGET_ID = p_TARGET_ID

Line 193: data_source_id = DECODE( p_data_source_id, FND_API.g_miss_num, data_source_id, p_data_source_id),

189: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
190: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
191: active_flag = DECODE( p_active_flag, FND_API.g_miss_char, active_flag, p_active_flag),
192: model_type = DECODE( p_model_type, FND_API.g_miss_char, model_type, p_model_type),
193: data_source_id = DECODE( p_data_source_id, FND_API.g_miss_num, data_source_id, p_data_source_id),
194: source_field_id = DECODE( p_source_field_id, FND_API.g_miss_num, source_field_id, p_source_field_id),
195: target_source_id = DECODE( p_target_source_id, FND_API.g_miss_num, target_source_id, p_target_source_id)
196: WHERE TARGET_ID = p_TARGET_ID
197: AND object_version_number = p_object_version_number;

Line 194: source_field_id = DECODE( p_source_field_id, FND_API.g_miss_num, source_field_id, p_source_field_id),

190: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
191: active_flag = DECODE( p_active_flag, FND_API.g_miss_char, active_flag, p_active_flag),
192: model_type = DECODE( p_model_type, FND_API.g_miss_char, model_type, p_model_type),
193: data_source_id = DECODE( p_data_source_id, FND_API.g_miss_num, data_source_id, p_data_source_id),
194: source_field_id = DECODE( p_source_field_id, FND_API.g_miss_num, source_field_id, p_source_field_id),
195: target_source_id = DECODE( p_target_source_id, FND_API.g_miss_num, target_source_id, p_target_source_id)
196: WHERE TARGET_ID = p_TARGET_ID
197: AND object_version_number = p_object_version_number;
198:

Line 195: target_source_id = DECODE( p_target_source_id, FND_API.g_miss_num, target_source_id, p_target_source_id)

191: active_flag = DECODE( p_active_flag, FND_API.g_miss_char, active_flag, p_active_flag),
192: model_type = DECODE( p_model_type, FND_API.g_miss_char, model_type, p_model_type),
193: data_source_id = DECODE( p_data_source_id, FND_API.g_miss_num, data_source_id, p_data_source_id),
194: source_field_id = DECODE( p_source_field_id, FND_API.g_miss_num, source_field_id, p_source_field_id),
195: target_source_id = DECODE( p_target_source_id, FND_API.g_miss_num, target_source_id, p_target_source_id)
196: WHERE TARGET_ID = p_TARGET_ID
197: AND object_version_number = p_object_version_number;
198:
199: IF (SQL%NOTFOUND) THEN

Line 200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

196: WHERE TARGET_ID = p_TARGET_ID
197: AND object_version_number = p_object_version_number;
198:
199: IF (SQL%NOTFOUND) THEN
200: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
201: END IF;
202:
203: IF (AMS_DEBUG_HIGH_ON) THEN
204:

Line 213: target_name = decode( p_target_name, FND_API.G_MISS_CHAR, TARGET_NAME, p_target_name),

209: END IF;
210:
211: -- update target name and description in TL table
212: update ams_dm_targets_tl set
213: target_name = decode( p_target_name, FND_API.G_MISS_CHAR, TARGET_NAME, p_target_name),
214: description = decode( p_description, FND_API.G_MISS_CHAR, DESCRIPTION, p_description),
215: last_update_date = SYSDATE,
216: last_updated_by = p_last_updated_by,
217: last_update_login = p_last_update_login,

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

210:
211: -- update target name and description in TL table
212: update ams_dm_targets_tl set
213: target_name = decode( p_target_name, FND_API.G_MISS_CHAR, TARGET_NAME, p_target_name),
214: description = decode( p_description, FND_API.G_MISS_CHAR, DESCRIPTION, p_description),
215: last_update_date = SYSDATE,
216: last_updated_by = p_last_updated_by,
217: last_update_login = p_last_update_login,
218: source_lang = USERENV('LANG')

Line 246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

242:
243: DELETE FROM AMS_DM_TARGETS_B
244: WHERE TARGET_ID = p_TARGET_ID;
245: If (SQL%NOTFOUND) then
246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
247: End If;
248:
249: DELETE FROM ams_dm_targets_tl
250: WHERE TARGET_ID = p_TARGET_ID;

Line 252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

248:
249: DELETE FROM ams_dm_targets_tl
250: WHERE TARGET_ID = p_TARGET_ID;
251: If (SQL%NOTFOUND) then
252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
253: End If;
254:
255: END Delete_Row ;
256: