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

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

67: system_url_id,
68: used_by_obj_type,
69: used_by_obj_id
70: ) VALUES (
71: DECODE( px_assoc_id, FND_API.g_miss_num, NULL, px_assoc_id),
72: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
73: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
74: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
75: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),

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

68: used_by_obj_type,
69: used_by_obj_id
70: ) VALUES (
71: DECODE( px_assoc_id, FND_API.g_miss_num, NULL, px_assoc_id),
72: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
73: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
74: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
75: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
76: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),

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

69: used_by_obj_id
70: ) VALUES (
71: DECODE( px_assoc_id, FND_API.g_miss_num, NULL, px_assoc_id),
72: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
73: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
74: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
75: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
76: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
77: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),

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

70: ) VALUES (
71: DECODE( px_assoc_id, FND_API.g_miss_num, NULL, px_assoc_id),
72: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
73: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
74: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
75: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
76: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
77: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
78: DECODE( p_system_url_id, FND_API.g_miss_num, NULL, p_system_url_id),

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

71: DECODE( px_assoc_id, FND_API.g_miss_num, NULL, px_assoc_id),
72: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
73: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
74: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
75: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
76: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
77: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
78: DECODE( p_system_url_id, FND_API.g_miss_num, NULL, p_system_url_id),
79: DECODE( p_used_by_obj_type, FND_API.g_miss_char, NULL, p_used_by_obj_type),

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

72: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
73: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
74: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
75: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
76: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
77: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
78: DECODE( p_system_url_id, FND_API.g_miss_num, NULL, p_system_url_id),
79: DECODE( p_used_by_obj_type, FND_API.g_miss_char, NULL, p_used_by_obj_type),
80: DECODE( p_used_by_obj_id, FND_API.g_miss_num, NULL, p_used_by_obj_id));

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

73: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
74: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
75: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
76: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
77: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
78: DECODE( p_system_url_id, FND_API.g_miss_num, NULL, p_system_url_id),
79: DECODE( p_used_by_obj_type, FND_API.g_miss_char, NULL, p_used_by_obj_type),
80: DECODE( p_used_by_obj_id, FND_API.g_miss_num, NULL, p_used_by_obj_id));
81: END Insert_Row;

Line 78: DECODE( p_system_url_id, FND_API.g_miss_num, NULL, p_system_url_id),

74: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
75: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
76: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
77: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
78: DECODE( p_system_url_id, FND_API.g_miss_num, NULL, p_system_url_id),
79: DECODE( p_used_by_obj_type, FND_API.g_miss_char, NULL, p_used_by_obj_type),
80: DECODE( p_used_by_obj_id, FND_API.g_miss_num, NULL, p_used_by_obj_id));
81: END Insert_Row;
82:

Line 79: DECODE( p_used_by_obj_type, FND_API.g_miss_char, NULL, p_used_by_obj_type),

75: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
76: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
77: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
78: DECODE( p_system_url_id, FND_API.g_miss_num, NULL, p_system_url_id),
79: DECODE( p_used_by_obj_type, FND_API.g_miss_char, NULL, p_used_by_obj_type),
80: DECODE( p_used_by_obj_id, FND_API.g_miss_num, NULL, p_used_by_obj_id));
81: END Insert_Row;
82:
83:

Line 80: DECODE( p_used_by_obj_id, FND_API.g_miss_num, NULL, p_used_by_obj_id));

76: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
77: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
78: DECODE( p_system_url_id, FND_API.g_miss_num, NULL, p_system_url_id),
79: DECODE( p_used_by_obj_type, FND_API.g_miss_char, NULL, p_used_by_obj_type),
80: DECODE( p_used_by_obj_id, FND_API.g_miss_num, NULL, p_used_by_obj_id));
81: END Insert_Row;
82:
83:
84: ----------------------------------------------------------

Line 116: assoc_id = DECODE( p_assoc_id, FND_API.g_miss_num, assoc_id, p_assoc_id),

112: IS
113: BEGIN
114: Update AMS_PRETTY_URL_ASSOC
115: SET
116: assoc_id = DECODE( p_assoc_id, FND_API.g_miss_num, assoc_id, p_assoc_id),
117: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
118: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
119: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
120: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),

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

113: BEGIN
114: Update AMS_PRETTY_URL_ASSOC
115: SET
116: assoc_id = DECODE( p_assoc_id, FND_API.g_miss_num, assoc_id, p_assoc_id),
117: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
118: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
119: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
120: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
121: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

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

114: Update AMS_PRETTY_URL_ASSOC
115: SET
116: assoc_id = DECODE( p_assoc_id, FND_API.g_miss_num, assoc_id, p_assoc_id),
117: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
118: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
119: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
120: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
121: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
122: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),

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

115: SET
116: assoc_id = DECODE( p_assoc_id, FND_API.g_miss_num, assoc_id, p_assoc_id),
117: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
118: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
119: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
120: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
121: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
122: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
123: system_url_id = DECODE( p_system_url_id, FND_API.g_miss_num, system_url_id, p_system_url_id),

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

116: assoc_id = DECODE( p_assoc_id, FND_API.g_miss_num, assoc_id, p_assoc_id),
117: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
118: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
119: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
120: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
121: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
122: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
123: system_url_id = DECODE( p_system_url_id, FND_API.g_miss_num, system_url_id, p_system_url_id),
124: used_by_obj_type = DECODE( p_used_by_obj_type, FND_API.g_miss_char, used_by_obj_type, p_used_by_obj_type),

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

117: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
118: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
119: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
120: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
121: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
122: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
123: system_url_id = DECODE( p_system_url_id, FND_API.g_miss_num, system_url_id, p_system_url_id),
124: used_by_obj_type = DECODE( p_used_by_obj_type, FND_API.g_miss_char, used_by_obj_type, p_used_by_obj_type),
125: used_by_obj_id = DECODE( p_used_by_obj_id, FND_API.g_miss_num, used_by_obj_id, p_used_by_obj_id)

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

118: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
119: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
120: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
121: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
122: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
123: system_url_id = DECODE( p_system_url_id, FND_API.g_miss_num, system_url_id, p_system_url_id),
124: used_by_obj_type = DECODE( p_used_by_obj_type, FND_API.g_miss_char, used_by_obj_type, p_used_by_obj_type),
125: used_by_obj_id = DECODE( p_used_by_obj_id, FND_API.g_miss_num, used_by_obj_id, p_used_by_obj_id)
126: WHERE ASSOC_ID = p_ASSOC_ID

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

119: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
120: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
121: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
122: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
123: system_url_id = DECODE( p_system_url_id, FND_API.g_miss_num, system_url_id, p_system_url_id),
124: used_by_obj_type = DECODE( p_used_by_obj_type, FND_API.g_miss_char, used_by_obj_type, p_used_by_obj_type),
125: used_by_obj_id = DECODE( p_used_by_obj_id, FND_API.g_miss_num, used_by_obj_id, p_used_by_obj_id)
126: WHERE ASSOC_ID = p_ASSOC_ID
127: AND object_version_number = p_object_version_number;

Line 124: used_by_obj_type = DECODE( p_used_by_obj_type, FND_API.g_miss_char, used_by_obj_type, p_used_by_obj_type),

120: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
121: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
122: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
123: system_url_id = DECODE( p_system_url_id, FND_API.g_miss_num, system_url_id, p_system_url_id),
124: used_by_obj_type = DECODE( p_used_by_obj_type, FND_API.g_miss_char, used_by_obj_type, p_used_by_obj_type),
125: used_by_obj_id = DECODE( p_used_by_obj_id, FND_API.g_miss_num, used_by_obj_id, p_used_by_obj_id)
126: WHERE ASSOC_ID = p_ASSOC_ID
127: AND object_version_number = p_object_version_number;
128:

Line 125: used_by_obj_id = DECODE( p_used_by_obj_id, FND_API.g_miss_num, used_by_obj_id, p_used_by_obj_id)

121: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
122: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
123: system_url_id = DECODE( p_system_url_id, FND_API.g_miss_num, system_url_id, p_system_url_id),
124: used_by_obj_type = DECODE( p_used_by_obj_type, FND_API.g_miss_char, used_by_obj_type, p_used_by_obj_type),
125: used_by_obj_id = DECODE( p_used_by_obj_id, FND_API.g_miss_num, used_by_obj_id, p_used_by_obj_id)
126: WHERE ASSOC_ID = p_ASSOC_ID
127: AND object_version_number = p_object_version_number;
128:
129: IF (SQL%NOTFOUND) THEN

Line 130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

126: WHERE ASSOC_ID = p_ASSOC_ID
127: AND object_version_number = p_object_version_number;
128:
129: IF (SQL%NOTFOUND) THEN
130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
131: END IF;
132: END Update_Row;
133:
134:

Line 158: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

154: BEGIN
155: DELETE FROM AMS_PRETTY_URL_ASSOC
156: WHERE ASSOC_ID = p_ASSOC_ID;
157: If (SQL%NOTFOUND) then
158: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
159: End If;
160: END Delete_Row ;
161:
162: