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

Line 60: DECODE( px_setup_purpose_id, FND_API.G_MISS_NUM, NULL, px_setup_purpose_id),

56: enabled_flag,
57: def_list_template_id,
58: object_version_number
59: ) VALUES (
60: DECODE( px_setup_purpose_id, FND_API.G_MISS_NUM, NULL, px_setup_purpose_id),
61: DECODE( p_custom_setup_id, FND_API.G_MISS_NUM, NULL, p_custom_setup_id),
62: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
63: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
64: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),

Line 61: DECODE( p_custom_setup_id, FND_API.G_MISS_NUM, NULL, p_custom_setup_id),

57: def_list_template_id,
58: object_version_number
59: ) VALUES (
60: DECODE( px_setup_purpose_id, FND_API.G_MISS_NUM, NULL, px_setup_purpose_id),
61: DECODE( p_custom_setup_id, FND_API.G_MISS_NUM, NULL, p_custom_setup_id),
62: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
63: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
64: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
65: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),

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

58: object_version_number
59: ) VALUES (
60: DECODE( px_setup_purpose_id, FND_API.G_MISS_NUM, NULL, px_setup_purpose_id),
61: DECODE( p_custom_setup_id, FND_API.G_MISS_NUM, NULL, p_custom_setup_id),
62: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
63: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
64: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
65: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
66: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),

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

59: ) VALUES (
60: DECODE( px_setup_purpose_id, FND_API.G_MISS_NUM, NULL, px_setup_purpose_id),
61: DECODE( p_custom_setup_id, FND_API.G_MISS_NUM, NULL, p_custom_setup_id),
62: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
63: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
64: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
65: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
66: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
67: DECODE( p_activity_purpose_code, FND_API.g_miss_char, NULL, p_activity_purpose_code),

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

60: DECODE( px_setup_purpose_id, FND_API.G_MISS_NUM, NULL, px_setup_purpose_id),
61: DECODE( p_custom_setup_id, FND_API.G_MISS_NUM, NULL, p_custom_setup_id),
62: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
63: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
64: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
65: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
66: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
67: DECODE( p_activity_purpose_code, FND_API.g_miss_char, NULL, p_activity_purpose_code),
68: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag),

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

61: DECODE( p_custom_setup_id, FND_API.G_MISS_NUM, NULL, p_custom_setup_id),
62: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
63: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
64: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
65: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
66: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
67: DECODE( p_activity_purpose_code, FND_API.g_miss_char, NULL, p_activity_purpose_code),
68: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag),
69: DECODE( p_def_list_template_id, FND_API.G_MISS_NUM, NULL, p_def_list_template_id),

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

62: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
63: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
64: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
65: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
66: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
67: DECODE( p_activity_purpose_code, FND_API.g_miss_char, NULL, p_activity_purpose_code),
68: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag),
69: DECODE( p_def_list_template_id, FND_API.G_MISS_NUM, NULL, p_def_list_template_id),
70: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number));

Line 67: DECODE( p_activity_purpose_code, FND_API.g_miss_char, NULL, p_activity_purpose_code),

63: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
64: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
65: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
66: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
67: DECODE( p_activity_purpose_code, FND_API.g_miss_char, NULL, p_activity_purpose_code),
68: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag),
69: DECODE( p_def_list_template_id, FND_API.G_MISS_NUM, NULL, p_def_list_template_id),
70: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number));
71:

Line 68: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag),

64: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
65: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
66: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
67: DECODE( p_activity_purpose_code, FND_API.g_miss_char, NULL, p_activity_purpose_code),
68: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag),
69: DECODE( p_def_list_template_id, FND_API.G_MISS_NUM, NULL, p_def_list_template_id),
70: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number));
71:
72: END Insert_Row;

Line 69: DECODE( p_def_list_template_id, FND_API.G_MISS_NUM, NULL, p_def_list_template_id),

65: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
66: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
67: DECODE( p_activity_purpose_code, FND_API.g_miss_char, NULL, p_activity_purpose_code),
68: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag),
69: DECODE( p_def_list_template_id, FND_API.G_MISS_NUM, NULL, p_def_list_template_id),
70: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number));
71:
72: END Insert_Row;
73:

Line 70: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number));

66: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
67: DECODE( p_activity_purpose_code, FND_API.g_miss_char, NULL, p_activity_purpose_code),
68: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag),
69: DECODE( p_def_list_template_id, FND_API.G_MISS_NUM, NULL, p_def_list_template_id),
70: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number));
71:
72: END Insert_Row;
73:
74: -- ========================================================

Line 101: setup_purpose_id = DECODE( p_setup_purpose_id, null, setup_purpose_id, FND_API.G_MISS_NUM, null, p_setup_purpose_id),

97: IS
98: BEGIN
99: Update ams_custom_setup_purpose
100: SET
101: setup_purpose_id = DECODE( p_setup_purpose_id, null, setup_purpose_id, FND_API.G_MISS_NUM, null, p_setup_purpose_id),
102: custom_setup_id = DECODE( p_custom_setup_id, null, custom_setup_id, FND_API.G_MISS_NUM, null, p_custom_setup_id),
103: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
104: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
105: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),

Line 102: custom_setup_id = DECODE( p_custom_setup_id, null, custom_setup_id, FND_API.G_MISS_NUM, null, p_custom_setup_id),

98: BEGIN
99: Update ams_custom_setup_purpose
100: SET
101: setup_purpose_id = DECODE( p_setup_purpose_id, null, setup_purpose_id, FND_API.G_MISS_NUM, null, p_setup_purpose_id),
102: custom_setup_id = DECODE( p_custom_setup_id, null, custom_setup_id, FND_API.G_MISS_NUM, null, p_custom_setup_id),
103: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
104: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
105: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
106: activity_purpose_code = DECODE( p_activity_purpose_code, null, activity_purpose_code, FND_API.g_miss_char, null, p_activity_purpose_code),

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

99: Update ams_custom_setup_purpose
100: SET
101: setup_purpose_id = DECODE( p_setup_purpose_id, null, setup_purpose_id, FND_API.G_MISS_NUM, null, p_setup_purpose_id),
102: custom_setup_id = DECODE( p_custom_setup_id, null, custom_setup_id, FND_API.G_MISS_NUM, null, p_custom_setup_id),
103: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
104: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
105: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
106: activity_purpose_code = DECODE( p_activity_purpose_code, null, activity_purpose_code, FND_API.g_miss_char, null, p_activity_purpose_code),
107: enabled_flag = DECODE( p_enabled_flag, null, enabled_flag, FND_API.g_miss_char, null, p_enabled_flag),

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

100: SET
101: setup_purpose_id = DECODE( p_setup_purpose_id, null, setup_purpose_id, FND_API.G_MISS_NUM, null, p_setup_purpose_id),
102: custom_setup_id = DECODE( p_custom_setup_id, null, custom_setup_id, FND_API.G_MISS_NUM, null, p_custom_setup_id),
103: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
104: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
105: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
106: activity_purpose_code = DECODE( p_activity_purpose_code, null, activity_purpose_code, FND_API.g_miss_char, null, p_activity_purpose_code),
107: enabled_flag = DECODE( p_enabled_flag, null, enabled_flag, FND_API.g_miss_char, null, p_enabled_flag),
108: def_list_template_id = DECODE( p_def_list_template_id, null, def_list_template_id, FND_API.G_MISS_NUM, null, p_def_list_template_id),

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

101: setup_purpose_id = DECODE( p_setup_purpose_id, null, setup_purpose_id, FND_API.G_MISS_NUM, null, p_setup_purpose_id),
102: custom_setup_id = DECODE( p_custom_setup_id, null, custom_setup_id, FND_API.G_MISS_NUM, null, p_custom_setup_id),
103: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
104: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
105: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
106: activity_purpose_code = DECODE( p_activity_purpose_code, null, activity_purpose_code, FND_API.g_miss_char, null, p_activity_purpose_code),
107: enabled_flag = DECODE( p_enabled_flag, null, enabled_flag, FND_API.g_miss_char, null, p_enabled_flag),
108: def_list_template_id = DECODE( p_def_list_template_id, null, def_list_template_id, FND_API.G_MISS_NUM, null, p_def_list_template_id),
109: object_version_number = nvl(p_object_version_number,0) + 1

Line 106: activity_purpose_code = DECODE( p_activity_purpose_code, null, activity_purpose_code, FND_API.g_miss_char, null, p_activity_purpose_code),

102: custom_setup_id = DECODE( p_custom_setup_id, null, custom_setup_id, FND_API.G_MISS_NUM, null, p_custom_setup_id),
103: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
104: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
105: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
106: activity_purpose_code = DECODE( p_activity_purpose_code, null, activity_purpose_code, FND_API.g_miss_char, null, p_activity_purpose_code),
107: enabled_flag = DECODE( p_enabled_flag, null, enabled_flag, FND_API.g_miss_char, null, p_enabled_flag),
108: def_list_template_id = DECODE( p_def_list_template_id, null, def_list_template_id, FND_API.G_MISS_NUM, null, p_def_list_template_id),
109: object_version_number = nvl(p_object_version_number,0) + 1
110: WHERE setup_purpose_id = p_setup_purpose_id

Line 107: enabled_flag = DECODE( p_enabled_flag, null, enabled_flag, FND_API.g_miss_char, null, p_enabled_flag),

103: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
104: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
105: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
106: activity_purpose_code = DECODE( p_activity_purpose_code, null, activity_purpose_code, FND_API.g_miss_char, null, p_activity_purpose_code),
107: enabled_flag = DECODE( p_enabled_flag, null, enabled_flag, FND_API.g_miss_char, null, p_enabled_flag),
108: def_list_template_id = DECODE( p_def_list_template_id, null, def_list_template_id, FND_API.G_MISS_NUM, null, p_def_list_template_id),
109: object_version_number = nvl(p_object_version_number,0) + 1
110: WHERE setup_purpose_id = p_setup_purpose_id
111: AND object_version_number = p_object_version_number;

Line 108: def_list_template_id = DECODE( p_def_list_template_id, null, def_list_template_id, FND_API.G_MISS_NUM, null, p_def_list_template_id),

104: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
105: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
106: activity_purpose_code = DECODE( p_activity_purpose_code, null, activity_purpose_code, FND_API.g_miss_char, null, p_activity_purpose_code),
107: enabled_flag = DECODE( p_enabled_flag, null, enabled_flag, FND_API.g_miss_char, null, p_enabled_flag),
108: def_list_template_id = DECODE( p_def_list_template_id, null, def_list_template_id, FND_API.G_MISS_NUM, null, p_def_list_template_id),
109: object_version_number = nvl(p_object_version_number,0) + 1
110: WHERE setup_purpose_id = p_setup_purpose_id
111: AND object_version_number = p_object_version_number;
112:

Line 115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

111: AND object_version_number = p_object_version_number;
112:
113:
114: IF (SQL%NOTFOUND) THEN
115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
116: END IF;
117:
118:
119: END Update_Row;

Line 142: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

138: DELETE FROM ams_custom_setup_purpose
139: WHERE setup_purpose_id = p_setup_purpose_id
140: AND object_version_number = p_object_version_number;
141: If (SQL%NOTFOUND) then
142: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
143: End If;
144: END Delete_Row ;
145:
146: -- ========================================================

Line 176: RAISE FND_API.g_exc_error;

172: FETCH c INTO Recinfo;
173: IF (c%NOTFOUND) THEN
174: CLOSE c;
175: AMS_Utility_PVT.error_message ('AMS_API_RECORD_NOT_FOUND');
176: RAISE FND_API.g_exc_error;
177: END IF;
178: CLOSE c;
179: END Lock_Row;
180: -- ========================================================