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

Line 67: DECODE( px_pretty_url_id, FND_API.g_miss_num, NULL, px_pretty_url_id),

63: last_update_login,
64: object_version_number,
65: landing_page_url
66: ) VALUES (
67: DECODE( px_pretty_url_id, FND_API.g_miss_num, NULL, px_pretty_url_id),
68: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
69: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
70: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
71: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),

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

64: object_version_number,
65: landing_page_url
66: ) VALUES (
67: DECODE( px_pretty_url_id, FND_API.g_miss_num, NULL, px_pretty_url_id),
68: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
69: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
70: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
71: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
72: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),

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

65: landing_page_url
66: ) VALUES (
67: DECODE( px_pretty_url_id, FND_API.g_miss_num, NULL, px_pretty_url_id),
68: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
69: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
70: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
71: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
72: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
73: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),

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

66: ) VALUES (
67: DECODE( px_pretty_url_id, FND_API.g_miss_num, NULL, px_pretty_url_id),
68: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
69: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
70: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
71: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
72: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
73: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
74: DECODE( p_landing_page_url, FND_API.g_miss_char, NULL, p_landing_page_url));

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

67: DECODE( px_pretty_url_id, FND_API.g_miss_num, NULL, px_pretty_url_id),
68: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
69: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
70: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
71: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
72: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
73: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
74: DECODE( p_landing_page_url, FND_API.g_miss_char, NULL, p_landing_page_url));
75: END Insert_Row;

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

68: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
69: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
70: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
71: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
72: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
73: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
74: DECODE( p_landing_page_url, FND_API.g_miss_char, NULL, p_landing_page_url));
75: END Insert_Row;
76:

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

69: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
70: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
71: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
72: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
73: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
74: DECODE( p_landing_page_url, FND_API.g_miss_char, NULL, p_landing_page_url));
75: END Insert_Row;
76:
77:

Line 74: DECODE( p_landing_page_url, FND_API.g_miss_char, NULL, p_landing_page_url));

70: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
71: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
72: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
73: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
74: DECODE( p_landing_page_url, FND_API.g_miss_char, NULL, p_landing_page_url));
75: END Insert_Row;
76:
77:
78: ----------------------------------------------------------

Line 108: pretty_url_id = DECODE( p_pretty_url_id, FND_API.g_miss_num, pretty_url_id, p_pretty_url_id),

104: IS
105: BEGIN
106: Update AMS_PRETTY_URL
107: SET
108: pretty_url_id = DECODE( p_pretty_url_id, FND_API.g_miss_num, pretty_url_id, p_pretty_url_id),
109: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
110: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
111: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
112: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),

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

105: BEGIN
106: Update AMS_PRETTY_URL
107: SET
108: pretty_url_id = DECODE( p_pretty_url_id, FND_API.g_miss_num, pretty_url_id, p_pretty_url_id),
109: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
110: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
111: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
112: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
113: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

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

106: Update AMS_PRETTY_URL
107: SET
108: pretty_url_id = DECODE( p_pretty_url_id, FND_API.g_miss_num, pretty_url_id, p_pretty_url_id),
109: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
110: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
111: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
112: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
113: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
114: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),

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

107: SET
108: pretty_url_id = DECODE( p_pretty_url_id, FND_API.g_miss_num, pretty_url_id, p_pretty_url_id),
109: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
110: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
111: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
112: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
113: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
114: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
115: landing_page_url = DECODE( p_landing_page_url, FND_API.g_miss_char, landing_page_url, p_landing_page_url)

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

108: pretty_url_id = DECODE( p_pretty_url_id, FND_API.g_miss_num, pretty_url_id, p_pretty_url_id),
109: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
110: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
111: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
112: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
113: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
114: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
115: landing_page_url = DECODE( p_landing_page_url, FND_API.g_miss_char, landing_page_url, p_landing_page_url)
116: WHERE PRETTY_URL_ID = p_PRETTY_URL_ID

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

109: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
110: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
111: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
112: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
113: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
114: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
115: landing_page_url = DECODE( p_landing_page_url, FND_API.g_miss_char, landing_page_url, p_landing_page_url)
116: WHERE PRETTY_URL_ID = p_PRETTY_URL_ID
117: AND object_version_number = p_object_version_number;

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

110: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
111: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
112: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
113: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
114: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
115: landing_page_url = DECODE( p_landing_page_url, FND_API.g_miss_char, landing_page_url, p_landing_page_url)
116: WHERE PRETTY_URL_ID = p_PRETTY_URL_ID
117: AND object_version_number = p_object_version_number;
118:

Line 115: landing_page_url = DECODE( p_landing_page_url, FND_API.g_miss_char, landing_page_url, p_landing_page_url)

111: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
112: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
113: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
114: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
115: landing_page_url = DECODE( p_landing_page_url, FND_API.g_miss_char, landing_page_url, p_landing_page_url)
116: WHERE PRETTY_URL_ID = p_PRETTY_URL_ID
117: AND object_version_number = p_object_version_number;
118:
119: IF (SQL%NOTFOUND) THEN

Line 120: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

116: WHERE PRETTY_URL_ID = p_PRETTY_URL_ID
117: AND object_version_number = p_object_version_number;
118:
119: IF (SQL%NOTFOUND) THEN
120: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
121: END IF;
122: END Update_Row;
123:
124:

Line 148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

144: BEGIN
145: DELETE FROM AMS_PRETTY_URL
146: WHERE PRETTY_URL_ID = p_PRETTY_URL_ID;
147: If (SQL%NOTFOUND) then
148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
149: End If;
150: END Delete_Row ;
151:
152: