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

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

68: object_version_number,
69: target_id,
70: data_source_id
71: ) VALUES (
72: DECODE( px_target_source_id, FND_API.G_MISS_NUM, NULL, px_target_source_id),
73: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
74: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
75: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
76: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),

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

69: target_id,
70: data_source_id
71: ) VALUES (
72: DECODE( px_target_source_id, FND_API.G_MISS_NUM, NULL, px_target_source_id),
73: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
74: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
75: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
76: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
77: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),

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

70: data_source_id
71: ) VALUES (
72: DECODE( px_target_source_id, FND_API.G_MISS_NUM, NULL, px_target_source_id),
73: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
74: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
75: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
76: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
77: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
78: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),

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

71: ) VALUES (
72: DECODE( px_target_source_id, FND_API.G_MISS_NUM, NULL, px_target_source_id),
73: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
74: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
75: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
76: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
77: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
78: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
79: DECODE( p_target_id, FND_API.G_MISS_NUM, NULL, p_target_id),

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

72: DECODE( px_target_source_id, FND_API.G_MISS_NUM, NULL, px_target_source_id),
73: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
74: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
75: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
76: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
77: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
78: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
79: DECODE( p_target_id, FND_API.G_MISS_NUM, NULL, p_target_id),
80: DECODE( p_data_source_id, FND_API.G_MISS_NUM, NULL, p_data_source_id));

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

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

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

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

Line 79: DECODE( p_target_id, FND_API.G_MISS_NUM, NULL, p_target_id),

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

Line 80: DECODE( p_data_source_id, FND_API.G_MISS_NUM, NULL, p_data_source_id));

76: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
77: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
78: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
79: DECODE( p_target_id, FND_API.G_MISS_NUM, NULL, p_target_id),
80: DECODE( p_data_source_id, FND_API.G_MISS_NUM, NULL, p_data_source_id));
81:
82: END Insert_Row;
83:
84:

Line 113: target_source_id = DECODE( p_target_source_id, null, target_source_id, FND_API.G_MISS_NUM, null, p_target_source_id),

109: IS
110: BEGIN
111: Update ams_dm_target_sources
112: SET
113: target_source_id = DECODE( p_target_source_id, null, target_source_id, FND_API.G_MISS_NUM, null, p_target_source_id),
114: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
115: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
116: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
117: object_version_number = p_object_version_number,

Line 114: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),

110: BEGIN
111: Update ams_dm_target_sources
112: SET
113: target_source_id = DECODE( p_target_source_id, null, target_source_id, FND_API.G_MISS_NUM, null, p_target_source_id),
114: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
115: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
116: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
117: object_version_number = p_object_version_number,
118: target_id = DECODE( p_target_id, null, target_id, FND_API.G_MISS_NUM, null, p_target_id),

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

111: Update ams_dm_target_sources
112: SET
113: target_source_id = DECODE( p_target_source_id, null, target_source_id, FND_API.G_MISS_NUM, null, p_target_source_id),
114: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
115: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
116: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
117: object_version_number = p_object_version_number,
118: target_id = DECODE( p_target_id, null, target_id, FND_API.G_MISS_NUM, null, p_target_id),
119: data_source_id = DECODE( p_data_source_id, null, data_source_id, FND_API.G_MISS_NUM, null, p_data_source_id)

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

112: SET
113: target_source_id = DECODE( p_target_source_id, null, target_source_id, FND_API.G_MISS_NUM, null, p_target_source_id),
114: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
115: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
116: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
117: object_version_number = p_object_version_number,
118: target_id = DECODE( p_target_id, null, target_id, FND_API.G_MISS_NUM, null, p_target_id),
119: data_source_id = DECODE( p_data_source_id, null, data_source_id, FND_API.G_MISS_NUM, null, p_data_source_id)
120: WHERE target_source_id = p_target_source_id;

Line 118: target_id = DECODE( p_target_id, null, target_id, FND_API.G_MISS_NUM, null, p_target_id),

114: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
115: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
116: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
117: object_version_number = p_object_version_number,
118: target_id = DECODE( p_target_id, null, target_id, FND_API.G_MISS_NUM, null, p_target_id),
119: data_source_id = DECODE( p_data_source_id, null, data_source_id, FND_API.G_MISS_NUM, null, p_data_source_id)
120: WHERE target_source_id = p_target_source_id;
121:
122:

Line 119: data_source_id = DECODE( p_data_source_id, null, data_source_id, FND_API.G_MISS_NUM, null, p_data_source_id)

115: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
116: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
117: object_version_number = p_object_version_number,
118: target_id = DECODE( p_target_id, null, target_id, FND_API.G_MISS_NUM, null, p_target_id),
119: data_source_id = DECODE( p_data_source_id, null, data_source_id, FND_API.G_MISS_NUM, null, p_data_source_id)
120: WHERE target_source_id = p_target_source_id;
121:
122:
123: IF (SQL%NOTFOUND) THEN

Line 154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

150: DELETE FROM ams_dm_target_sources
151: WHERE target_source_id = p_target_source_id
152: AND object_version_number = p_object_version_number;
153: If (SQL%NOTFOUND) then
154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
155: End If;
156: END Delete_Row ;
157:
158:

Line 192: RAISE FND_API.g_exc_error;

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