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

Line 43: (x_msite_resp_id = FND_API.G_MISS_NUM))

39:
40: -- Primary key validation check
41: x_msite_resp_id := p_msite_resp_id;
42: IF ((x_msite_resp_id IS NULL) OR
43: (x_msite_resp_id = FND_API.G_MISS_NUM))
44: THEN
45: OPEN c2;
46: FETCH c2 INTO x_msite_resp_id;
47: CLOSE c2;

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

72: p_msite_id,
73: p_responsibility_id,
74: p_application_id,
75: p_start_date_active,
76: decode(p_end_date_active, FND_API.G_MISS_DATE, NULL, p_end_date_active),
77: decode(p_sort_order, FND_API.G_MISS_NUM, NULL, p_sort_order),
78: decode(p_group_code, FND_API.G_MISS_CHAR, NULL, p_group_code),
79: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
80: p_creation_date),

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

73: p_responsibility_id,
74: p_application_id,
75: p_start_date_active,
76: decode(p_end_date_active, FND_API.G_MISS_DATE, NULL, p_end_date_active),
77: decode(p_sort_order, FND_API.G_MISS_NUM, NULL, p_sort_order),
78: decode(p_group_code, FND_API.G_MISS_CHAR, NULL, p_group_code),
79: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
80: p_creation_date),
81: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

Line 78: decode(p_group_code, FND_API.G_MISS_CHAR, NULL, p_group_code),

74: p_application_id,
75: p_start_date_active,
76: decode(p_end_date_active, FND_API.G_MISS_DATE, NULL, p_end_date_active),
77: decode(p_sort_order, FND_API.G_MISS_NUM, NULL, p_sort_order),
78: decode(p_group_code, FND_API.G_MISS_CHAR, NULL, p_group_code),
79: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
80: p_creation_date),
81: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
82: NULL, FND_GLOBAL.user_id, p_created_by),

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

75: p_start_date_active,
76: decode(p_end_date_active, FND_API.G_MISS_DATE, NULL, p_end_date_active),
77: decode(p_sort_order, FND_API.G_MISS_NUM, NULL, p_sort_order),
78: decode(p_group_code, FND_API.G_MISS_CHAR, NULL, p_group_code),
79: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
80: p_creation_date),
81: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
82: NULL, FND_GLOBAL.user_id, p_created_by),
83: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,

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

77: decode(p_sort_order, FND_API.G_MISS_NUM, NULL, p_sort_order),
78: decode(p_group_code, FND_API.G_MISS_CHAR, NULL, p_group_code),
79: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
80: p_creation_date),
81: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
82: NULL, FND_GLOBAL.user_id, p_created_by),
83: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
84: p_last_update_date),
85: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

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

79: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
80: p_creation_date),
81: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
82: NULL, FND_GLOBAL.user_id, p_created_by),
83: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
84: p_last_update_date),
85: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
86: NULL, FND_GLOBAL.user_id, p_last_updated_by),
87: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,

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

81: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
82: NULL, FND_GLOBAL.user_id, p_created_by),
83: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
84: p_last_update_date),
85: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
86: NULL, FND_GLOBAL.user_id, p_last_updated_by),
87: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
88: NULL, FND_GLOBAL.login_id, p_last_update_login)
89: );

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

83: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
84: p_last_update_date),
85: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
86: NULL, FND_GLOBAL.user_id, p_last_updated_by),
87: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
88: NULL, FND_GLOBAL.login_id, p_last_update_login)
89: );
90:
91: OPEN c;

Line 103: (p_msite_resp_id = FND_API.G_MISS_NUM))

99:
100:
101: -- insert tl
102: IF ((p_msite_resp_id IS NULL) OR
103: (p_msite_resp_id = FND_API.G_MISS_NUM))
104: THEN
105: INSERT INTO ibe_msite_resps_tl
106: (
107: msite_resp_id,

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

117: )
118: SELECT
119: x_msite_resp_id,
120: p_object_version_number,
121: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
122: NULL, FND_GLOBAL.user_id, p_created_by),
123: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate,
124: NULL, sysdate, p_creation_date),
125: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

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

119: x_msite_resp_id,
120: p_object_version_number,
121: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
122: NULL, FND_GLOBAL.user_id, p_created_by),
123: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate,
124: NULL, sysdate, p_creation_date),
125: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
126: NULL, FND_GLOBAL.user_id, p_last_updated_by),
127: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,

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

121: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
122: NULL, FND_GLOBAL.user_id, p_created_by),
123: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate,
124: NULL, sysdate, p_creation_date),
125: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
126: NULL, FND_GLOBAL.user_id, p_last_updated_by),
127: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,
128: NULL, sysdate, p_last_update_date),
129: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,

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

123: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate,
124: NULL, sysdate, p_creation_date),
125: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
126: NULL, FND_GLOBAL.user_id, p_last_updated_by),
127: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,
128: NULL, sysdate, p_last_update_date),
129: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
130: NULL, FND_GLOBAL.login_id, p_last_update_login),
131: p_display_name,

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

125: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
126: NULL, FND_GLOBAL.user_id, p_last_updated_by),
127: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,
128: NULL, sysdate, p_last_update_date),
129: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
130: NULL, FND_GLOBAL.login_id, p_last_update_login),
131: p_display_name,
132: L.language_code,
133: userenv('LANG')

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

152:
153: PROCEDURE update_row
154: (
155: p_msite_resp_id IN NUMBER,
156: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
157: p_start_date_active IN DATE,
158: p_end_date_active IN DATE,
159: p_sort_order IN NUMBER,
160: p_display_name IN VARCHAR2,

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

168:
169: -- update base
170: UPDATE ibe_msite_resps_b SET
171: object_version_number = object_version_number + 1,
172: start_date_active = decode(p_start_date_active, FND_API.G_MISS_DATE,
173: start_date_active, p_start_date_active),
174: end_date_active = decode(p_end_date_active, FND_API.G_MISS_DATE,
175: end_date_active, p_end_date_active),
176: sort_order = decode(p_sort_order, FND_API.G_MISS_NUM,

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

170: UPDATE ibe_msite_resps_b SET
171: object_version_number = object_version_number + 1,
172: start_date_active = decode(p_start_date_active, FND_API.G_MISS_DATE,
173: start_date_active, p_start_date_active),
174: end_date_active = decode(p_end_date_active, FND_API.G_MISS_DATE,
175: end_date_active, p_end_date_active),
176: sort_order = decode(p_sort_order, FND_API.G_MISS_NUM,
177: sort_order, p_sort_order),
178: group_code = decode(p_group_code, FND_API.G_MISS_CHAR,

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

172: start_date_active = decode(p_start_date_active, FND_API.G_MISS_DATE,
173: start_date_active, p_start_date_active),
174: end_date_active = decode(p_end_date_active, FND_API.G_MISS_DATE,
175: end_date_active, p_end_date_active),
176: sort_order = decode(p_sort_order, FND_API.G_MISS_NUM,
177: sort_order, p_sort_order),
178: group_code = decode(p_group_code, FND_API.G_MISS_CHAR,
179: group_code, p_group_code),
180: last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,

Line 178: group_code = decode(p_group_code, FND_API.G_MISS_CHAR,

174: end_date_active = decode(p_end_date_active, FND_API.G_MISS_DATE,
175: end_date_active, p_end_date_active),
176: sort_order = decode(p_sort_order, FND_API.G_MISS_NUM,
177: sort_order, p_sort_order),
178: group_code = decode(p_group_code, FND_API.G_MISS_CHAR,
179: group_code, p_group_code),
180: last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,
181: NULL, sysdate, p_last_update_date),
182: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,

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

176: sort_order = decode(p_sort_order, FND_API.G_MISS_NUM,
177: sort_order, p_sort_order),
178: group_code = decode(p_group_code, FND_API.G_MISS_CHAR,
179: group_code, p_group_code),
180: last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,
181: NULL, sysdate, p_last_update_date),
182: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
183: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
184: p_last_updated_by),

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

178: group_code = decode(p_group_code, FND_API.G_MISS_CHAR,
179: group_code, p_group_code),
180: last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,
181: NULL, sysdate, p_last_update_date),
182: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
183: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
184: p_last_updated_by),
185: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,
186: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,

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

181: NULL, sysdate, p_last_update_date),
182: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
183: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
184: p_last_updated_by),
185: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,
186: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,
187: p_last_update_login)
188: WHERE msite_resp_id = p_msite_resp_id;
189: -- AND object_version_number = decode(p_object_version_number,

Line 190: -- FND_API.G_MISS_NUM,

186: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,
187: p_last_update_login)
188: WHERE msite_resp_id = p_msite_resp_id;
189: -- AND object_version_number = decode(p_object_version_number,
190: -- FND_API.G_MISS_NUM,
191: -- object_version_number,
192: -- p_object_version_number);
193: IF (sql%NOTFOUND) THEN
194: RAISE NO_DATA_FOUND;

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

196:
197: -- update tl
198: UPDATE ibe_msite_resps_tl SET
199: object_version_number = object_version_number + 1,
200: display_name = decode(p_display_name, FND_API.G_MISS_CHAR,
201: display_name, p_display_name),
202: last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,
203: NULL, sysdate, p_last_update_date),
204: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,

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

198: UPDATE ibe_msite_resps_tl SET
199: object_version_number = object_version_number + 1,
200: display_name = decode(p_display_name, FND_API.G_MISS_CHAR,
201: display_name, p_display_name),
202: last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,
203: NULL, sysdate, p_last_update_date),
204: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
205: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
206: p_last_updated_by),

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

200: display_name = decode(p_display_name, FND_API.G_MISS_CHAR,
201: display_name, p_display_name),
202: last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate,
203: NULL, sysdate, p_last_update_date),
204: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
205: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
206: p_last_updated_by),
207: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,
208: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,

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

203: NULL, sysdate, p_last_update_date),
204: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
205: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
206: p_last_updated_by),
207: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,
208: FND_GLOBAL.login_id, NULL, FND_GLOBAL.login_id,
209: p_last_update_login),
210: source_lang = USERENV('LANG')
211: WHERE msite_resp_id = p_msite_resp_id

Line 213: -- FND_API.G_MISS_NUM,

209: p_last_update_login),
210: source_lang = USERENV('LANG')
211: WHERE msite_resp_id = p_msite_resp_id
212: -- AND object_version_number = decode(p_object_version_number,
213: -- FND_API.G_MISS_NUM,
214: -- object_version_number,
215: -- p_object_version_number)
216: AND USERENV('LANG') IN (language, source_lang);
217: