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.JTF_MSITE_RESP_PKG dependencies on FND_API

Line 37: (x_msite_resp_id = FND_API.G_MISS_NUM))

33:
34: -- Primary key validation check
35: x_msite_resp_id := p_msite_resp_id;
36: IF ((x_msite_resp_id IS NULL) OR
37: (x_msite_resp_id = FND_API.G_MISS_NUM))
38: THEN
39: OPEN c2;
40: FETCH c2 INTO x_msite_resp_id;
41: CLOSE c2;

Line 70: decode(p_end_date_active, FND_API.G_MISS_DATE, NULL, p_end_date_active),

66: p_msite_id,
67: p_responsibility_id,
68: p_application_id,
69: p_start_date_active,
70: decode(p_end_date_active, FND_API.G_MISS_DATE, NULL, p_end_date_active),
71: decode(p_sort_order, FND_API.G_MISS_NUM, NULL, p_sort_order),
72: decode(p_security_group_id, FND_API.G_MISS_NUM, NULL, p_security_group_id),
73: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
74: p_creation_date),

Line 71: decode(p_sort_order, FND_API.G_MISS_NUM, NULL, p_sort_order),

67: p_responsibility_id,
68: p_application_id,
69: p_start_date_active,
70: decode(p_end_date_active, FND_API.G_MISS_DATE, NULL, p_end_date_active),
71: decode(p_sort_order, FND_API.G_MISS_NUM, NULL, p_sort_order),
72: decode(p_security_group_id, FND_API.G_MISS_NUM, NULL, p_security_group_id),
73: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
74: p_creation_date),
75: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

Line 72: decode(p_security_group_id, FND_API.G_MISS_NUM, NULL, p_security_group_id),

68: p_application_id,
69: p_start_date_active,
70: decode(p_end_date_active, FND_API.G_MISS_DATE, NULL, p_end_date_active),
71: decode(p_sort_order, FND_API.G_MISS_NUM, NULL, p_sort_order),
72: decode(p_security_group_id, FND_API.G_MISS_NUM, NULL, p_security_group_id),
73: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
74: p_creation_date),
75: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
76: NULL, FND_GLOBAL.user_id, p_created_by),

Line 73: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,

69: p_start_date_active,
70: decode(p_end_date_active, FND_API.G_MISS_DATE, NULL, p_end_date_active),
71: decode(p_sort_order, FND_API.G_MISS_NUM, NULL, p_sort_order),
72: decode(p_security_group_id, FND_API.G_MISS_NUM, NULL, p_security_group_id),
73: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
74: p_creation_date),
75: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
76: NULL, FND_GLOBAL.user_id, p_created_by),
77: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,

Line 75: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

71: decode(p_sort_order, FND_API.G_MISS_NUM, NULL, p_sort_order),
72: decode(p_security_group_id, FND_API.G_MISS_NUM, NULL, p_security_group_id),
73: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
74: p_creation_date),
75: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
76: NULL, FND_GLOBAL.user_id, p_created_by),
77: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
78: p_last_update_date),
79: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

Line 77: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,

73: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
74: p_creation_date),
75: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
76: NULL, FND_GLOBAL.user_id, p_created_by),
77: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
78: p_last_update_date),
79: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
80: NULL, FND_GLOBAL.user_id, p_last_updated_by),
81: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,

Line 79: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

75: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
76: NULL, FND_GLOBAL.user_id, p_created_by),
77: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
78: p_last_update_date),
79: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
80: NULL, FND_GLOBAL.user_id, p_last_updated_by),
81: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
82: NULL, FND_GLOBAL.login_id, p_last_update_login)
83: );

Line 81: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,

77: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
78: p_last_update_date),
79: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
80: NULL, FND_GLOBAL.user_id, p_last_updated_by),
81: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
82: NULL, FND_GLOBAL.login_id, p_last_update_login)
83: );
84:
85: OPEN c;

Line 112: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

108: )
109: SELECT
110: x_msite_resp_id,
111: p_object_version_number,
112: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
113: NULL, FND_GLOBAL.user_id, p_created_by),
114: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate,
115: NULL, sysdate, p_creation_date),
116: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

Line 114: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate,

110: x_msite_resp_id,
111: p_object_version_number,
112: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
113: NULL, FND_GLOBAL.user_id, p_created_by),
114: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate,
115: NULL, sysdate, p_creation_date),
116: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
117: NULL, FND_GLOBAL.user_id, p_last_updated_by),
118: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,

Line 116: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

112: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
113: NULL, FND_GLOBAL.user_id, p_created_by),
114: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate,
115: NULL, sysdate, p_creation_date),
116: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
117: NULL, FND_GLOBAL.user_id, p_last_updated_by),
118: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,
119: NULL, sysdate, p_last_update_date),
120: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,

Line 118: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,

114: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate,
115: NULL, sysdate, p_creation_date),
116: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
117: NULL, FND_GLOBAL.user_id, p_last_updated_by),
118: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,
119: NULL, sysdate, p_last_update_date),
120: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
121: NULL, FND_GLOBAL.login_id, p_last_update_login),
122: p_display_name,

Line 120: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,

116: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
117: NULL, FND_GLOBAL.user_id, p_last_updated_by),
118: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,
119: NULL, sysdate, p_last_update_date),
120: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
121: NULL, FND_GLOBAL.login_id, p_last_update_login),
122: p_display_name,
123: decode(p_security_group_id, FND_API.G_MISS_NUM, NULL,
124: p_security_group_id),

Line 123: decode(p_security_group_id, FND_API.G_MISS_NUM, NULL,

119: NULL, sysdate, p_last_update_date),
120: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
121: NULL, FND_GLOBAL.login_id, p_last_update_login),
122: p_display_name,
123: decode(p_security_group_id, FND_API.G_MISS_NUM, NULL,
124: p_security_group_id),
125: L.language_code,
126: userenv('LANG')
127: FROM fnd_languages L

Line 148: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,

144:
145: PROCEDURE update_row
146: (
147: p_msite_resp_id IN NUMBER,
148: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
149: p_start_date_active IN DATE,
150: p_end_date_active IN DATE,
151: p_sort_order IN NUMBER,
152: p_security_group_id IN NUMBER,

Line 164: start_date_active = decode(p_start_date_active, FND_API.G_MISS_DATE,

160:
161: -- update base
162: UPDATE jtf_msite_resps_b SET
163: object_version_number = object_version_number + 1,
164: start_date_active = decode(p_start_date_active, FND_API.G_MISS_DATE,
165: start_date_active, p_start_date_active),
166: end_date_active = decode(p_end_date_active, FND_API.G_MISS_DATE,
167: end_date_active, p_end_date_active),
168: sort_order = decode(p_sort_order, FND_API.G_MISS_NUM,

Line 166: end_date_active = decode(p_end_date_active, FND_API.G_MISS_DATE,

162: UPDATE jtf_msite_resps_b SET
163: object_version_number = object_version_number + 1,
164: start_date_active = decode(p_start_date_active, FND_API.G_MISS_DATE,
165: start_date_active, p_start_date_active),
166: end_date_active = decode(p_end_date_active, FND_API.G_MISS_DATE,
167: end_date_active, p_end_date_active),
168: sort_order = decode(p_sort_order, FND_API.G_MISS_NUM,
169: sort_order, p_sort_order),
170: security_group_id = decode(p_security_group_id, FND_API.G_MISS_NUM,

Line 168: sort_order = decode(p_sort_order, FND_API.G_MISS_NUM,

164: start_date_active = decode(p_start_date_active, FND_API.G_MISS_DATE,
165: start_date_active, p_start_date_active),
166: end_date_active = decode(p_end_date_active, FND_API.G_MISS_DATE,
167: end_date_active, p_end_date_active),
168: sort_order = decode(p_sort_order, FND_API.G_MISS_NUM,
169: sort_order, p_sort_order),
170: security_group_id = decode(p_security_group_id, FND_API.G_MISS_NUM,
171: security_group_id, p_security_group_id),
172: last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,

Line 170: security_group_id = decode(p_security_group_id, FND_API.G_MISS_NUM,

166: end_date_active = decode(p_end_date_active, FND_API.G_MISS_DATE,
167: end_date_active, p_end_date_active),
168: sort_order = decode(p_sort_order, FND_API.G_MISS_NUM,
169: sort_order, p_sort_order),
170: security_group_id = decode(p_security_group_id, FND_API.G_MISS_NUM,
171: security_group_id, p_security_group_id),
172: last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,
173: NULL, sysdate, p_last_update_date),
174: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,

Line 172: last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,

168: sort_order = decode(p_sort_order, FND_API.G_MISS_NUM,
169: sort_order, p_sort_order),
170: security_group_id = decode(p_security_group_id, FND_API.G_MISS_NUM,
171: security_group_id, p_security_group_id),
172: last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,
173: NULL, sysdate, p_last_update_date),
174: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
175: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
176: p_last_updated_by),

Line 174: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,

170: security_group_id = decode(p_security_group_id, FND_API.G_MISS_NUM,
171: security_group_id, p_security_group_id),
172: last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,
173: NULL, sysdate, p_last_update_date),
174: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
175: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
176: p_last_updated_by),
177: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,
178: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,

Line 177: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,

173: NULL, sysdate, p_last_update_date),
174: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
175: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
176: p_last_updated_by),
177: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,
178: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,
179: p_last_update_login)
180: WHERE msite_resp_id = p_msite_resp_id
181: AND object_version_number = decode(p_object_version_number,

Line 182: FND_API.G_MISS_NUM,

178: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,
179: p_last_update_login)
180: WHERE msite_resp_id = p_msite_resp_id
181: AND object_version_number = decode(p_object_version_number,
182: FND_API.G_MISS_NUM,
183: object_version_number,
184: p_object_version_number);
185: IF (sql%NOTFOUND) THEN
186: RAISE NO_DATA_FOUND;

Line 192: display_name = decode(p_display_name, FND_API.G_MISS_CHAR,

188:
189: -- update tl
190: UPDATE jtf_msite_resps_tl SET
191: object_version_number = object_version_number + 1,
192: display_name = decode(p_display_name, FND_API.G_MISS_CHAR,
193: display_name, p_display_name),
194: last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,
195: NULL, sysdate, p_last_update_date),
196: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,

Line 194: last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,

190: UPDATE jtf_msite_resps_tl SET
191: object_version_number = object_version_number + 1,
192: display_name = decode(p_display_name, FND_API.G_MISS_CHAR,
193: display_name, p_display_name),
194: last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,
195: NULL, sysdate, p_last_update_date),
196: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
197: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
198: p_last_updated_by),

Line 196: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,

192: display_name = decode(p_display_name, FND_API.G_MISS_CHAR,
193: display_name, p_display_name),
194: last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,
195: NULL, sysdate, p_last_update_date),
196: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
197: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
198: p_last_updated_by),
199: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,
200: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,

Line 199: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,

195: NULL, sysdate, p_last_update_date),
196: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
197: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
198: p_last_updated_by),
199: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,
200: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,
201: p_last_update_login),
202: source_lang = USERENV('LANG')
203: WHERE msite_resp_id = p_msite_resp_id

Line 205: --FND_API.G_MISS_NUM,

201: p_last_update_login),
202: source_lang = USERENV('LANG')
203: WHERE msite_resp_id = p_msite_resp_id
204: --AND object_version_number = decode(p_object_version_number,
205: --FND_API.G_MISS_NUM,
206: --object_version_number,
207: --p_object_version_number)
208: AND USERENV('LANG') IN (language, source_lang);
209: