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.

[Home] [Help]

APPS.MST_COPY_PLAN_OPTIONS dependencies on FND_GLOBAL

Line 32: l_user_id := fnd_global.user_id;

28: -- 1 Use plan dates from default plan options template
29: -- 2 Use plan dates from the source plan
30: -- 3 User user specified plan dates
31:
32: l_user_id := fnd_global.user_id;
33:
34: IF NVL(fnd_profile.value('MST_MTO_LICENSED'),'N') = 'Y' Then
35: l_POOLING_FLAG := 1;
36: ELSE

Line 187: p_dest_plan_desc, v_dest_start_date, v_dest_end_date, fnd_global.user_id,

183: 'where plan_id = :p_source_plan_id';
184:
185:
186: EXECUTE IMMEDIATE v_statement USING v_dest_plan_id, p_dest_plan_name,
187: p_dest_plan_desc, v_dest_start_date, v_dest_end_date, fnd_global.user_id,
188: sysdate, fnd_global.user_id, sysdate, fnd_global.login_id,
189: p_source_plan_id;
190:
191: v_statement :=

Line 188: sysdate, fnd_global.user_id, sysdate, fnd_global.login_id,

184:
185:
186: EXECUTE IMMEDIATE v_statement USING v_dest_plan_id, p_dest_plan_name,
187: p_dest_plan_desc, v_dest_start_date, v_dest_end_date, fnd_global.user_id,
188: sysdate, fnd_global.user_id, sysdate, fnd_global.login_id,
189: p_source_plan_id;
190:
191: v_statement :=
192: 'INSERT INTO MST_PLAN_FACILITIES(' ||

Line 219: EXECUTE IMMEDIATE v_statement USING v_dest_plan_id, fnd_global.user_id,

215: ':v_login_id ' ||
216: 'from MST_PLAN_FACILITIES ' ||
217: 'where plan_id = :p_source_plan_id';
218:
219: EXECUTE IMMEDIATE v_statement USING v_dest_plan_id, fnd_global.user_id,
220: sysdate, fnd_global.user_id, sysdate, fnd_global.login_id,
221: p_source_plan_id;
222:
223: v_statement :=

Line 220: sysdate, fnd_global.user_id, sysdate, fnd_global.login_id,

216: 'from MST_PLAN_FACILITIES ' ||
217: 'where plan_id = :p_source_plan_id';
218:
219: EXECUTE IMMEDIATE v_statement USING v_dest_plan_id, fnd_global.user_id,
220: sysdate, fnd_global.user_id, sysdate, fnd_global.login_id,
221: p_source_plan_id;
222:
223: v_statement :=
224: ' INSERT INTO MST_PLAN_CONSTRAINT_RULES(' ||

Line 247: EXECUTE IMMEDIATE v_statement USING v_dest_plan_id, fnd_global.user_id,

243: ':v_login_id ' ||
244: 'from mst_plan_constraint_rules ' ||
245: 'where plan_id = :p_source_plan_id';
246:
247: EXECUTE IMMEDIATE v_statement USING v_dest_plan_id, fnd_global.user_id,
248: sysdate, fnd_global.user_id, sysdate, fnd_global.login_id,
249: p_source_plan_id;
250:
251:

Line 248: sysdate, fnd_global.user_id, sysdate, fnd_global.login_id,

244: 'from mst_plan_constraint_rules ' ||
245: 'where plan_id = :p_source_plan_id';
246:
247: EXECUTE IMMEDIATE v_statement USING v_dest_plan_id, fnd_global.user_id,
248: sysdate, fnd_global.user_id, sysdate, fnd_global.login_id,
249: p_source_plan_id;
250:
251:
252: v_statement :=

Line 280: EXECUTE IMMEDIATE v_statement USING v_dest_plan_id, fnd_global.user_id,

276: ':v_login_id ' ||
277: 'from mst_plan_penalty_breaks ' ||
278: 'where plan_id = :p_source_plan_id ';
279:
280: EXECUTE IMMEDIATE v_statement USING v_dest_plan_id, fnd_global.user_id,
281: sysdate, fnd_global.user_id, sysdate, fnd_global.login_id,
282: p_source_plan_id;
283:
284: commit;

Line 281: sysdate, fnd_global.user_id, sysdate, fnd_global.login_id,

277: 'from mst_plan_penalty_breaks ' ||
278: 'where plan_id = :p_source_plan_id ';
279:
280: EXECUTE IMMEDIATE v_statement USING v_dest_plan_id, fnd_global.user_id,
281: sysdate, fnd_global.user_id, sysdate, fnd_global.login_id,
282: p_source_plan_id;
283:
284: commit;
285:

Line 336: EXECUTE IMMEDIATE v_statement USING p_plan_id, fnd_global.user_id,

332: ':v_login_id ' ||
333: 'from MST_PLAN_FACILITIES ' ||
334: 'where plan_id = -1 and created_by = :p_created_by';
335:
336: EXECUTE IMMEDIATE v_statement USING p_plan_id, fnd_global.user_id,
337: sysdate, fnd_global.user_id, sysdate, fnd_global.login_id,
338: p_created_by;
339:
340: v_statement :=

Line 337: sysdate, fnd_global.user_id, sysdate, fnd_global.login_id,

333: 'from MST_PLAN_FACILITIES ' ||
334: 'where plan_id = -1 and created_by = :p_created_by';
335:
336: EXECUTE IMMEDIATE v_statement USING p_plan_id, fnd_global.user_id,
337: sysdate, fnd_global.user_id, sysdate, fnd_global.login_id,
338: p_created_by;
339:
340: v_statement :=
341: ' INSERT INTO MST_PLAN_CONSTRAINT_RULES(' ||

Line 364: EXECUTE IMMEDIATE v_statement USING p_plan_id, fnd_global.user_id,

360: ':v_login_id ' ||
361: 'from mst_plan_constraint_rules ' ||
362: 'where plan_id = -1 and created_by = :p_created_by';
363:
364: EXECUTE IMMEDIATE v_statement USING p_plan_id, fnd_global.user_id,
365: sysdate, fnd_global.user_id, sysdate, fnd_global.login_id,
366: p_created_by;
367:
368:

Line 365: sysdate, fnd_global.user_id, sysdate, fnd_global.login_id,

361: 'from mst_plan_constraint_rules ' ||
362: 'where plan_id = -1 and created_by = :p_created_by';
363:
364: EXECUTE IMMEDIATE v_statement USING p_plan_id, fnd_global.user_id,
365: sysdate, fnd_global.user_id, sysdate, fnd_global.login_id,
366: p_created_by;
367:
368:
369: v_statement :=

Line 397: EXECUTE IMMEDIATE v_statement USING p_plan_id, fnd_global.user_id,

393: ':v_login_id ' ||
394: 'from mst_plan_penalty_breaks ' ||
395: 'where plan_id = -1 and created_by = :p_created_by';
396:
397: EXECUTE IMMEDIATE v_statement USING p_plan_id, fnd_global.user_id,
398: sysdate, fnd_global.user_id, sysdate, fnd_global.login_id,
399: p_created_by;
400:
401: commit;

Line 398: sysdate, fnd_global.user_id, sysdate, fnd_global.login_id,

394: 'from mst_plan_penalty_breaks ' ||
395: 'where plan_id = -1 and created_by = :p_created_by';
396:
397: EXECUTE IMMEDIATE v_statement USING p_plan_id, fnd_global.user_id,
398: sysdate, fnd_global.user_id, sysdate, fnd_global.login_id,
399: p_created_by;
400:
401: commit;
402: