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

Line 75: DECODE( px_system_url_id, FND_API.g_miss_num, NULL, px_system_url_id),

71: system_url,
72: ctd_id,
73: track_url
74: ) VALUES (
75: DECODE( px_system_url_id, FND_API.g_miss_num, NULL, px_system_url_id),
76: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
77: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
78: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
79: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),

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

72: ctd_id,
73: track_url
74: ) VALUES (
75: DECODE( px_system_url_id, FND_API.g_miss_num, NULL, px_system_url_id),
76: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
77: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
78: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
79: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
80: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),

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

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

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

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

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

75: DECODE( px_system_url_id, FND_API.g_miss_num, NULL, px_system_url_id),
76: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
77: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
78: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
79: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
80: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
81: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
82: DECODE( p_pretty_url_id, FND_API.g_miss_num, NULL, p_pretty_url_id),
83: DECODE( p_additional_url_param, FND_API.g_miss_char, NULL, p_additional_url_param),

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

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

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

77: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
78: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
79: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
80: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
81: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
82: DECODE( p_pretty_url_id, FND_API.g_miss_num, NULL, p_pretty_url_id),
83: DECODE( p_additional_url_param, FND_API.g_miss_char, NULL, p_additional_url_param),
84: DECODE( p_system_url, FND_API.g_miss_char, NULL, p_system_url),
85: DECODE( p_ctd_id, FND_API.g_miss_num, NULL, p_ctd_id),

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

78: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
79: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
80: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
81: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
82: DECODE( p_pretty_url_id, FND_API.g_miss_num, NULL, p_pretty_url_id),
83: DECODE( p_additional_url_param, FND_API.g_miss_char, NULL, p_additional_url_param),
84: DECODE( p_system_url, FND_API.g_miss_char, NULL, p_system_url),
85: DECODE( p_ctd_id, FND_API.g_miss_num, NULL, p_ctd_id),
86: DECODE( p_track_url, FND_API.g_miss_char, NULL, p_track_url));

Line 83: DECODE( p_additional_url_param, FND_API.g_miss_char, NULL, p_additional_url_param),

79: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
80: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
81: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
82: DECODE( p_pretty_url_id, FND_API.g_miss_num, NULL, p_pretty_url_id),
83: DECODE( p_additional_url_param, FND_API.g_miss_char, NULL, p_additional_url_param),
84: DECODE( p_system_url, FND_API.g_miss_char, NULL, p_system_url),
85: DECODE( p_ctd_id, FND_API.g_miss_num, NULL, p_ctd_id),
86: DECODE( p_track_url, FND_API.g_miss_char, NULL, p_track_url));
87: END Insert_Row;

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

80: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
81: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
82: DECODE( p_pretty_url_id, FND_API.g_miss_num, NULL, p_pretty_url_id),
83: DECODE( p_additional_url_param, FND_API.g_miss_char, NULL, p_additional_url_param),
84: DECODE( p_system_url, FND_API.g_miss_char, NULL, p_system_url),
85: DECODE( p_ctd_id, FND_API.g_miss_num, NULL, p_ctd_id),
86: DECODE( p_track_url, FND_API.g_miss_char, NULL, p_track_url));
87: END Insert_Row;
88:

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

81: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
82: DECODE( p_pretty_url_id, FND_API.g_miss_num, NULL, p_pretty_url_id),
83: DECODE( p_additional_url_param, FND_API.g_miss_char, NULL, p_additional_url_param),
84: DECODE( p_system_url, FND_API.g_miss_char, NULL, p_system_url),
85: DECODE( p_ctd_id, FND_API.g_miss_num, NULL, p_ctd_id),
86: DECODE( p_track_url, FND_API.g_miss_char, NULL, p_track_url));
87: END Insert_Row;
88:
89:

Line 86: DECODE( p_track_url, FND_API.g_miss_char, NULL, p_track_url));

82: DECODE( p_pretty_url_id, FND_API.g_miss_num, NULL, p_pretty_url_id),
83: DECODE( p_additional_url_param, FND_API.g_miss_char, NULL, p_additional_url_param),
84: DECODE( p_system_url, FND_API.g_miss_char, NULL, p_system_url),
85: DECODE( p_ctd_id, FND_API.g_miss_num, NULL, p_ctd_id),
86: DECODE( p_track_url, FND_API.g_miss_char, NULL, p_track_url));
87: END Insert_Row;
88:
89:
90: ----------------------------------------------------------

Line 124: system_url_id = DECODE( p_system_url_id, FND_API.g_miss_num, system_url_id, p_system_url_id),

120: IS
121: BEGIN
122: Update AMS_SYSTEM_PRETTY_URL
123: SET
124: system_url_id = DECODE( p_system_url_id, FND_API.g_miss_num, system_url_id, p_system_url_id),
125: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
126: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
127: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
128: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),

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

121: BEGIN
122: Update AMS_SYSTEM_PRETTY_URL
123: SET
124: system_url_id = DECODE( p_system_url_id, FND_API.g_miss_num, system_url_id, p_system_url_id),
125: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
126: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
127: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
128: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
129: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

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

122: Update AMS_SYSTEM_PRETTY_URL
123: SET
124: system_url_id = DECODE( p_system_url_id, FND_API.g_miss_num, system_url_id, p_system_url_id),
125: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
126: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
127: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
128: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
129: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
130: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),

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

123: SET
124: system_url_id = DECODE( p_system_url_id, FND_API.g_miss_num, system_url_id, p_system_url_id),
125: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
126: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
127: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
128: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
129: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
130: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
131: pretty_url_id = DECODE( p_pretty_url_id, FND_API.g_miss_num, pretty_url_id, p_pretty_url_id),

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

124: system_url_id = DECODE( p_system_url_id, FND_API.g_miss_num, system_url_id, p_system_url_id),
125: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
126: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
127: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
128: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
129: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
130: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
131: pretty_url_id = DECODE( p_pretty_url_id, FND_API.g_miss_num, pretty_url_id, p_pretty_url_id),
132: additional_url_param = DECODE( p_additional_url_param, FND_API.g_miss_char, additional_url_param, p_additional_url_param),

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

125: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
126: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
127: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
128: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
129: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
130: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
131: pretty_url_id = DECODE( p_pretty_url_id, FND_API.g_miss_num, pretty_url_id, p_pretty_url_id),
132: additional_url_param = DECODE( p_additional_url_param, FND_API.g_miss_char, additional_url_param, p_additional_url_param),
133: system_url = DECODE( p_system_url, FND_API.g_miss_char, system_url, p_system_url),

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

126: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
127: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
128: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
129: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
130: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
131: pretty_url_id = DECODE( p_pretty_url_id, FND_API.g_miss_num, pretty_url_id, p_pretty_url_id),
132: additional_url_param = DECODE( p_additional_url_param, FND_API.g_miss_char, additional_url_param, p_additional_url_param),
133: system_url = DECODE( p_system_url, FND_API.g_miss_char, system_url, p_system_url),
134: ctd_id = DECODE( p_ctd_id, FND_API.g_miss_num, ctd_id, p_ctd_id),

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

127: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
128: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
129: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
130: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
131: pretty_url_id = DECODE( p_pretty_url_id, FND_API.g_miss_num, pretty_url_id, p_pretty_url_id),
132: additional_url_param = DECODE( p_additional_url_param, FND_API.g_miss_char, additional_url_param, p_additional_url_param),
133: system_url = DECODE( p_system_url, FND_API.g_miss_char, system_url, p_system_url),
134: ctd_id = DECODE( p_ctd_id, FND_API.g_miss_num, ctd_id, p_ctd_id),
135: track_url = DECODE( p_track_url, FND_API.g_miss_char, track_url, p_track_url)

Line 132: additional_url_param = DECODE( p_additional_url_param, FND_API.g_miss_char, additional_url_param, p_additional_url_param),

128: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
129: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
130: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
131: pretty_url_id = DECODE( p_pretty_url_id, FND_API.g_miss_num, pretty_url_id, p_pretty_url_id),
132: additional_url_param = DECODE( p_additional_url_param, FND_API.g_miss_char, additional_url_param, p_additional_url_param),
133: system_url = DECODE( p_system_url, FND_API.g_miss_char, system_url, p_system_url),
134: ctd_id = DECODE( p_ctd_id, FND_API.g_miss_num, ctd_id, p_ctd_id),
135: track_url = DECODE( p_track_url, FND_API.g_miss_char, track_url, p_track_url)
136: WHERE SYSTEM_URL_ID = p_SYSTEM_URL_ID

Line 133: system_url = DECODE( p_system_url, FND_API.g_miss_char, system_url, p_system_url),

129: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
130: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
131: pretty_url_id = DECODE( p_pretty_url_id, FND_API.g_miss_num, pretty_url_id, p_pretty_url_id),
132: additional_url_param = DECODE( p_additional_url_param, FND_API.g_miss_char, additional_url_param, p_additional_url_param),
133: system_url = DECODE( p_system_url, FND_API.g_miss_char, system_url, p_system_url),
134: ctd_id = DECODE( p_ctd_id, FND_API.g_miss_num, ctd_id, p_ctd_id),
135: track_url = DECODE( p_track_url, FND_API.g_miss_char, track_url, p_track_url)
136: WHERE SYSTEM_URL_ID = p_SYSTEM_URL_ID
137: AND object_version_number = p_object_version_number;

Line 134: ctd_id = DECODE( p_ctd_id, FND_API.g_miss_num, ctd_id, p_ctd_id),

130: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
131: pretty_url_id = DECODE( p_pretty_url_id, FND_API.g_miss_num, pretty_url_id, p_pretty_url_id),
132: additional_url_param = DECODE( p_additional_url_param, FND_API.g_miss_char, additional_url_param, p_additional_url_param),
133: system_url = DECODE( p_system_url, FND_API.g_miss_char, system_url, p_system_url),
134: ctd_id = DECODE( p_ctd_id, FND_API.g_miss_num, ctd_id, p_ctd_id),
135: track_url = DECODE( p_track_url, FND_API.g_miss_char, track_url, p_track_url)
136: WHERE SYSTEM_URL_ID = p_SYSTEM_URL_ID
137: AND object_version_number = p_object_version_number;
138:

Line 135: track_url = DECODE( p_track_url, FND_API.g_miss_char, track_url, p_track_url)

131: pretty_url_id = DECODE( p_pretty_url_id, FND_API.g_miss_num, pretty_url_id, p_pretty_url_id),
132: additional_url_param = DECODE( p_additional_url_param, FND_API.g_miss_char, additional_url_param, p_additional_url_param),
133: system_url = DECODE( p_system_url, FND_API.g_miss_char, system_url, p_system_url),
134: ctd_id = DECODE( p_ctd_id, FND_API.g_miss_num, ctd_id, p_ctd_id),
135: track_url = DECODE( p_track_url, FND_API.g_miss_char, track_url, p_track_url)
136: WHERE SYSTEM_URL_ID = p_SYSTEM_URL_ID
137: AND object_version_number = p_object_version_number;
138:
139: IF (SQL%NOTFOUND) THEN

Line 140: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

136: WHERE SYSTEM_URL_ID = p_SYSTEM_URL_ID
137: AND object_version_number = p_object_version_number;
138:
139: IF (SQL%NOTFOUND) THEN
140: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
141: END IF;
142: END Update_Row;
143:
144:

Line 168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

164: BEGIN
165: DELETE FROM AMS_SYSTEM_PRETTY_URL
166: WHERE SYSTEM_URL_ID = p_SYSTEM_URL_ID;
167: If (SQL%NOTFOUND) then
168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
169: End If;
170: END Delete_Row ;
171:
172: