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.FPA_SCENARIO_PVT dependencies on DBMS_AW

Line 77: dbms_aw.execute('MAINTAIN scenario_d ADD ' || x_scenario_id);

73: );
74: END IF;
75:
76: -- Add the new scenario to the dimension
77: dbms_aw.execute('MAINTAIN scenario_d ADD ' || x_scenario_id);
78:
79:
80: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
81: fnd_log.string

Line 89: dbms_aw.execute('PUSH scenario_d');

85: 'Setting PC relation for new scenario.'
86: );
87: END IF;
88:
89: dbms_aw.execute('PUSH scenario_d');
90: dbms_aw.execute('LMT scenario_d TO ' || x_scenario_id);
91: -- Associate the scenario with the planning cycle
92: dbms_aw.execute('planning_cycle_scenario_r = ' || p_pc_id);
93: dbms_aw.execute('POP scenario_d');

Line 90: dbms_aw.execute('LMT scenario_d TO ' || x_scenario_id);

86: );
87: END IF;
88:
89: dbms_aw.execute('PUSH scenario_d');
90: dbms_aw.execute('LMT scenario_d TO ' || x_scenario_id);
91: -- Associate the scenario with the planning cycle
92: dbms_aw.execute('planning_cycle_scenario_r = ' || p_pc_id);
93: dbms_aw.execute('POP scenario_d');
94:

Line 92: dbms_aw.execute('planning_cycle_scenario_r = ' || p_pc_id);

88:
89: dbms_aw.execute('PUSH scenario_d');
90: dbms_aw.execute('LMT scenario_d TO ' || x_scenario_id);
91: -- Associate the scenario with the planning cycle
92: dbms_aw.execute('planning_cycle_scenario_r = ' || p_pc_id);
93: dbms_aw.execute('POP scenario_d');
94:
95: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
96: fnd_log.string

Line 93: dbms_aw.execute('POP scenario_d');

89: dbms_aw.execute('PUSH scenario_d');
90: dbms_aw.execute('LMT scenario_d TO ' || x_scenario_id);
91: -- Associate the scenario with the planning cycle
92: dbms_aw.execute('planning_cycle_scenario_r = ' || p_pc_id);
93: dbms_aw.execute('POP scenario_d');
94:
95: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
96: fnd_log.string
97: (

Line 224: dbms_aw.execute('call copy_sce_data_prg(' || p_scenario_id_source || ' ' || p_scenario_id_target || ' ''' || p_copy_proposed_proj || ''')');

220: );
221: END IF;
222:
223:
224: dbms_aw.execute('call copy_sce_data_prg(' || p_scenario_id_source || ' ' || p_scenario_id_target || ' ''' || p_copy_proposed_proj || ''')');
225:
226: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
227: fnd_log.string
228: (

Line 291: dbms_aw.execute('LMT scenario_d TO '''

287: END IF;
288:
289: END IF;
290:
291: dbms_aw.execute('LMT scenario_d TO '''
292: || p_scenario_rec.sce_shortname || '''');
293:
294: -- Lock the scenario
295: dbms_aw.execute('is_scenario_locked_m = true');

Line 295: dbms_aw.execute('is_scenario_locked_m = true');

291: dbms_aw.execute('LMT scenario_d TO '''
292: || p_scenario_rec.sce_shortname || '''');
293:
294: -- Lock the scenario
295: dbms_aw.execute('is_scenario_locked_m = true');
296:
297: -- Set the last update date
298: dbms_aw.execute('last_update_date_scenario_r = '''
299: || to_char(SYSDATE, 'MM-DD-YYYY') || '''');

Line 298: dbms_aw.execute('last_update_date_scenario_r = '''

294: -- Lock the scenario
295: dbms_aw.execute('is_scenario_locked_m = true');
296:
297: -- Set the last update date
298: dbms_aw.execute('last_update_date_scenario_r = '''
299: || to_char(SYSDATE, 'MM-DD-YYYY') || '''');
300:
301: IF g_attach_aw THEN
302: -- Update and commit our changes

Line 304: dbms_aw.execute('UPDATE');

300:
301: IF g_attach_aw THEN
302: -- Update and commit our changes
303: IF (p_commit = FND_API.G_TRUE) THEN
304: dbms_aw.execute('UPDATE');
305: COMMIT;
306: END IF;
307:
308: -- Finally, detach the workspace

Line 423: dbms_aw.execute('LMT scenario_d TO '|| p_scenario_id );

419:
420: -- Bug 4331948 . Reset apporved flag of all scenario for this planning cycle.
421: -- this make sure there will be only one scenario is apporved
422: -- fix start
423: dbms_aw.execute('LMT scenario_d TO '|| p_scenario_id );
424: dbms_aw.execute('LMT planning_cycle_d to scenario_d');
425: dbms_aw.execute('LMT scenario_d to planning_cycle_d');
426: dbms_aw.execute('scenario_approved_flag_m = na');
427: -- fix end

Line 424: dbms_aw.execute('LMT planning_cycle_d to scenario_d');

420: -- Bug 4331948 . Reset apporved flag of all scenario for this planning cycle.
421: -- this make sure there will be only one scenario is apporved
422: -- fix start
423: dbms_aw.execute('LMT scenario_d TO '|| p_scenario_id );
424: dbms_aw.execute('LMT planning_cycle_d to scenario_d');
425: dbms_aw.execute('LMT scenario_d to planning_cycle_d');
426: dbms_aw.execute('scenario_approved_flag_m = na');
427: -- fix end
428:

Line 425: dbms_aw.execute('LMT scenario_d to planning_cycle_d');

421: -- this make sure there will be only one scenario is apporved
422: -- fix start
423: dbms_aw.execute('LMT scenario_d TO '|| p_scenario_id );
424: dbms_aw.execute('LMT planning_cycle_d to scenario_d');
425: dbms_aw.execute('LMT scenario_d to planning_cycle_d');
426: dbms_aw.execute('scenario_approved_flag_m = na');
427: -- fix end
428:
429: dbms_aw.execute('LMT scenario_d TO '|| p_scenario_id );

Line 426: dbms_aw.execute('scenario_approved_flag_m = na');

422: -- fix start
423: dbms_aw.execute('LMT scenario_d TO '|| p_scenario_id );
424: dbms_aw.execute('LMT planning_cycle_d to scenario_d');
425: dbms_aw.execute('LMT scenario_d to planning_cycle_d');
426: dbms_aw.execute('scenario_approved_flag_m = na');
427: -- fix end
428:
429: dbms_aw.execute('LMT scenario_d TO '|| p_scenario_id );
430:

Line 429: dbms_aw.execute('LMT scenario_d TO '|| p_scenario_id );

425: dbms_aw.execute('LMT scenario_d to planning_cycle_d');
426: dbms_aw.execute('scenario_approved_flag_m = na');
427: -- fix end
428:
429: dbms_aw.execute('LMT scenario_d TO '|| p_scenario_id );
430:
431: dbms_aw.execute('scenario_approved_flag_m = ' || p_approved_flag);
432:
433: -- Set the last update date

Line 431: dbms_aw.execute('scenario_approved_flag_m = ' || p_approved_flag);

427: -- fix end
428:
429: dbms_aw.execute('LMT scenario_d TO '|| p_scenario_id );
430:
431: dbms_aw.execute('scenario_approved_flag_m = ' || p_approved_flag);
432:
433: -- Set the last update date
434: -- need to wite code for this
435:

Line 506: dbms_aw.execute('PUSH scenario_d');

502: 'Setting the discount rate.'
503: );
504: END IF;
505:
506: dbms_aw.execute('PUSH scenario_d');
507: dbms_aw.execute('LMT scenario_d TO ' || p_scenario_id);
508:
509: SELECT SUBSTR(VALUE,1,1)
510: INTO l_decimal_marker

Line 507: dbms_aw.execute('LMT scenario_d TO ' || p_scenario_id);

503: );
504: END IF;
505:
506: dbms_aw.execute('PUSH scenario_d');
507: dbms_aw.execute('LMT scenario_d TO ' || p_scenario_id);
508:
509: SELECT SUBSTR(VALUE,1,1)
510: INTO l_decimal_marker
511: FROM NLS_SESSION_PARAMETERS

Line 517: dbms_aw.execute('scenario_discount_rate_m = ' || l_discount_rate);

513:
514: l_discount_rate := REPLACE( To_Char(p_discount_rate/100), l_decimal_marker,'.');
515:
516: -- Associate the scenario with the planning cycle
517: dbms_aw.execute('scenario_discount_rate_m = ' || l_discount_rate);
518: -- Update daily discount rate
519: dbms_aw.execute('scenario_discount_rate_daily_m = ((1+scenario_discount_rate_m)**(1/365))-1');
520: dbms_aw.execute('POP scenario_d');
521:

Line 519: dbms_aw.execute('scenario_discount_rate_daily_m = ((1+scenario_discount_rate_m)**(1/365))-1');

515:
516: -- Associate the scenario with the planning cycle
517: dbms_aw.execute('scenario_discount_rate_m = ' || l_discount_rate);
518: -- Update daily discount rate
519: dbms_aw.execute('scenario_discount_rate_daily_m = ((1+scenario_discount_rate_m)**(1/365))-1');
520: dbms_aw.execute('POP scenario_d');
521:
522: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
523: fnd_log.string

Line 520: dbms_aw.execute('POP scenario_d');

516: -- Associate the scenario with the planning cycle
517: dbms_aw.execute('scenario_discount_rate_m = ' || l_discount_rate);
518: -- Update daily discount rate
519: dbms_aw.execute('scenario_discount_rate_daily_m = ((1+scenario_discount_rate_m)**(1/365))-1');
520: dbms_aw.execute('POP scenario_d');
521:
522: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
523: fnd_log.string
524: (

Line 599: dbms_aw.execute('PUSH scenario_d');

595: WHERE a.planning_cycle = b.planning_cycle
596: AND a.scenario = p_scenario_id ;
597:
598:
599: dbms_aw.execute('PUSH scenario_d');
600: dbms_aw.execute('LMT scenario_d TO ' || p_scenario_id);
601:
602: SELECT SUBSTR(VALUE,1,1)
603: INTO l_decimal_marker

Line 600: dbms_aw.execute('LMT scenario_d TO ' || p_scenario_id);

596: AND a.scenario = p_scenario_id ;
597:
598:
599: dbms_aw.execute('PUSH scenario_d');
600: dbms_aw.execute('LMT scenario_d TO ' || p_scenario_id);
601:
602: SELECT SUBSTR(VALUE,1,1)
603: INTO l_decimal_marker
604: FROM NLS_SESSION_PARAMETERS

Line 609: dbms_aw.execute('scenario_funding_m = ' || l_scen_funds);

605: WHERE PARAMETER = 'NLS_NUMERIC_CHARACTERS';
606: l_scen_funds := REPLACE( To_Char(p_scenario_funds*l_pc_disply_factor), l_decimal_marker,'.');
607:
608: -- Associate the scenario with the planning cycle
609: dbms_aw.execute('scenario_funding_m = ' || l_scen_funds);
610: dbms_aw.execute('POP scenario_d');
611:
612: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
613: fnd_log.string

Line 610: dbms_aw.execute('POP scenario_d');

606: l_scen_funds := REPLACE( To_Char(p_scenario_funds*l_pc_disply_factor), l_decimal_marker,'.');
607:
608: -- Associate the scenario with the planning cycle
609: dbms_aw.execute('scenario_funding_m = ' || l_scen_funds);
610: dbms_aw.execute('POP scenario_d');
611:
612: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
613: fnd_log.string
614: (

Line 677: dbms_aw.execute('PUSH scenario_d');

673: 'Unsetting any previous flags and setting new flag.'
674: );
675: END IF;
676:
677: dbms_aw.execute('PUSH scenario_d');
678: dbms_aw.execute('PUSH planning_cycle_d');
679: dbms_aw.execute('oknullstatus = y');
680: dbms_aw.execute('limit scenario_d to ' || p_scenario_id);
681: -- dbms_aw.execute('limit scenario_d to p_scenario_id');

Line 678: dbms_aw.execute('PUSH planning_cycle_d');

674: );
675: END IF;
676:
677: dbms_aw.execute('PUSH scenario_d');
678: dbms_aw.execute('PUSH planning_cycle_d');
679: dbms_aw.execute('oknullstatus = y');
680: dbms_aw.execute('limit scenario_d to ' || p_scenario_id);
681: -- dbms_aw.execute('limit scenario_d to p_scenario_id');
682: dbms_aw.execute('limit planning_cycle_d to planning_cycle_scenario_r');

Line 679: dbms_aw.execute('oknullstatus = y');

675: END IF;
676:
677: dbms_aw.execute('PUSH scenario_d');
678: dbms_aw.execute('PUSH planning_cycle_d');
679: dbms_aw.execute('oknullstatus = y');
680: dbms_aw.execute('limit scenario_d to ' || p_scenario_id);
681: -- dbms_aw.execute('limit scenario_d to p_scenario_id');
682: dbms_aw.execute('limit planning_cycle_d to planning_cycle_scenario_r');
683: dbms_aw.execute('limit scenario_d to planning_cycle_d');

Line 680: dbms_aw.execute('limit scenario_d to ' || p_scenario_id);

676:
677: dbms_aw.execute('PUSH scenario_d');
678: dbms_aw.execute('PUSH planning_cycle_d');
679: dbms_aw.execute('oknullstatus = y');
680: dbms_aw.execute('limit scenario_d to ' || p_scenario_id);
681: -- dbms_aw.execute('limit scenario_d to p_scenario_id');
682: dbms_aw.execute('limit planning_cycle_d to planning_cycle_scenario_r');
683: dbms_aw.execute('limit scenario_d to planning_cycle_d');
684: dbms_aw.execute('limit scenario_d keep scenario_initial_m');

Line 681: -- dbms_aw.execute('limit scenario_d to p_scenario_id');

677: dbms_aw.execute('PUSH scenario_d');
678: dbms_aw.execute('PUSH planning_cycle_d');
679: dbms_aw.execute('oknullstatus = y');
680: dbms_aw.execute('limit scenario_d to ' || p_scenario_id);
681: -- dbms_aw.execute('limit scenario_d to p_scenario_id');
682: dbms_aw.execute('limit planning_cycle_d to planning_cycle_scenario_r');
683: dbms_aw.execute('limit scenario_d to planning_cycle_d');
684: dbms_aw.execute('limit scenario_d keep scenario_initial_m');
685: dbms_aw.execute('scenario_initial_m = na');

Line 682: dbms_aw.execute('limit planning_cycle_d to planning_cycle_scenario_r');

678: dbms_aw.execute('PUSH planning_cycle_d');
679: dbms_aw.execute('oknullstatus = y');
680: dbms_aw.execute('limit scenario_d to ' || p_scenario_id);
681: -- dbms_aw.execute('limit scenario_d to p_scenario_id');
682: dbms_aw.execute('limit planning_cycle_d to planning_cycle_scenario_r');
683: dbms_aw.execute('limit scenario_d to planning_cycle_d');
684: dbms_aw.execute('limit scenario_d keep scenario_initial_m');
685: dbms_aw.execute('scenario_initial_m = na');
686: dbms_aw.execute('limit scenario_d to ' || p_scenario_id);

Line 683: dbms_aw.execute('limit scenario_d to planning_cycle_d');

679: dbms_aw.execute('oknullstatus = y');
680: dbms_aw.execute('limit scenario_d to ' || p_scenario_id);
681: -- dbms_aw.execute('limit scenario_d to p_scenario_id');
682: dbms_aw.execute('limit planning_cycle_d to planning_cycle_scenario_r');
683: dbms_aw.execute('limit scenario_d to planning_cycle_d');
684: dbms_aw.execute('limit scenario_d keep scenario_initial_m');
685: dbms_aw.execute('scenario_initial_m = na');
686: dbms_aw.execute('limit scenario_d to ' || p_scenario_id);
687: -- dbms_aw.execute('limit scenario_d to p_scenario_id');

Line 684: dbms_aw.execute('limit scenario_d keep scenario_initial_m');

680: dbms_aw.execute('limit scenario_d to ' || p_scenario_id);
681: -- dbms_aw.execute('limit scenario_d to p_scenario_id');
682: dbms_aw.execute('limit planning_cycle_d to planning_cycle_scenario_r');
683: dbms_aw.execute('limit scenario_d to planning_cycle_d');
684: dbms_aw.execute('limit scenario_d keep scenario_initial_m');
685: dbms_aw.execute('scenario_initial_m = na');
686: dbms_aw.execute('limit scenario_d to ' || p_scenario_id);
687: -- dbms_aw.execute('limit scenario_d to p_scenario_id');
688: dbms_aw.execute('scenario_initial_m = yes');

Line 685: dbms_aw.execute('scenario_initial_m = na');

681: -- dbms_aw.execute('limit scenario_d to p_scenario_id');
682: dbms_aw.execute('limit planning_cycle_d to planning_cycle_scenario_r');
683: dbms_aw.execute('limit scenario_d to planning_cycle_d');
684: dbms_aw.execute('limit scenario_d keep scenario_initial_m');
685: dbms_aw.execute('scenario_initial_m = na');
686: dbms_aw.execute('limit scenario_d to ' || p_scenario_id);
687: -- dbms_aw.execute('limit scenario_d to p_scenario_id');
688: dbms_aw.execute('scenario_initial_m = yes');
689: dbms_aw.execute('POP scenario_d');

Line 686: dbms_aw.execute('limit scenario_d to ' || p_scenario_id);

682: dbms_aw.execute('limit planning_cycle_d to planning_cycle_scenario_r');
683: dbms_aw.execute('limit scenario_d to planning_cycle_d');
684: dbms_aw.execute('limit scenario_d keep scenario_initial_m');
685: dbms_aw.execute('scenario_initial_m = na');
686: dbms_aw.execute('limit scenario_d to ' || p_scenario_id);
687: -- dbms_aw.execute('limit scenario_d to p_scenario_id');
688: dbms_aw.execute('scenario_initial_m = yes');
689: dbms_aw.execute('POP scenario_d');
690: dbms_aw.execute('POP planning_cycle_d');

Line 687: -- dbms_aw.execute('limit scenario_d to p_scenario_id');

683: dbms_aw.execute('limit scenario_d to planning_cycle_d');
684: dbms_aw.execute('limit scenario_d keep scenario_initial_m');
685: dbms_aw.execute('scenario_initial_m = na');
686: dbms_aw.execute('limit scenario_d to ' || p_scenario_id);
687: -- dbms_aw.execute('limit scenario_d to p_scenario_id');
688: dbms_aw.execute('scenario_initial_m = yes');
689: dbms_aw.execute('POP scenario_d');
690: dbms_aw.execute('POP planning_cycle_d');
691:

Line 688: dbms_aw.execute('scenario_initial_m = yes');

684: dbms_aw.execute('limit scenario_d keep scenario_initial_m');
685: dbms_aw.execute('scenario_initial_m = na');
686: dbms_aw.execute('limit scenario_d to ' || p_scenario_id);
687: -- dbms_aw.execute('limit scenario_d to p_scenario_id');
688: dbms_aw.execute('scenario_initial_m = yes');
689: dbms_aw.execute('POP scenario_d');
690: dbms_aw.execute('POP planning_cycle_d');
691:
692: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 689: dbms_aw.execute('POP scenario_d');

685: dbms_aw.execute('scenario_initial_m = na');
686: dbms_aw.execute('limit scenario_d to ' || p_scenario_id);
687: -- dbms_aw.execute('limit scenario_d to p_scenario_id');
688: dbms_aw.execute('scenario_initial_m = yes');
689: dbms_aw.execute('POP scenario_d');
690: dbms_aw.execute('POP planning_cycle_d');
691:
692: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
693: fnd_log.string

Line 690: dbms_aw.execute('POP planning_cycle_d');

686: dbms_aw.execute('limit scenario_d to ' || p_scenario_id);
687: -- dbms_aw.execute('limit scenario_d to p_scenario_id');
688: dbms_aw.execute('scenario_initial_m = yes');
689: dbms_aw.execute('POP scenario_d');
690: dbms_aw.execute('POP planning_cycle_d');
691:
692: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
693: fnd_log.string
694: (

Line 757: dbms_aw.execute('PUSH scenario_d');

753: 'Unsetting any previous flags and setting new flag.'
754: );
755: END IF;
756:
757: dbms_aw.execute('PUSH scenario_d');
758: dbms_aw.execute('PUSH planning_cycle_d');
759: dbms_aw.execute('oknullstatus = y');
760: dbms_aw.execute('limit scenario_d to ' || p_scenario_id);
761: dbms_aw.execute('limit planning_cycle_d to planning_cycle_scenario_r');

Line 758: dbms_aw.execute('PUSH planning_cycle_d');

754: );
755: END IF;
756:
757: dbms_aw.execute('PUSH scenario_d');
758: dbms_aw.execute('PUSH planning_cycle_d');
759: dbms_aw.execute('oknullstatus = y');
760: dbms_aw.execute('limit scenario_d to ' || p_scenario_id);
761: dbms_aw.execute('limit planning_cycle_d to planning_cycle_scenario_r');
762: dbms_aw.execute('limit scenario_d to planning_cycle_d');

Line 759: dbms_aw.execute('oknullstatus = y');

755: END IF;
756:
757: dbms_aw.execute('PUSH scenario_d');
758: dbms_aw.execute('PUSH planning_cycle_d');
759: dbms_aw.execute('oknullstatus = y');
760: dbms_aw.execute('limit scenario_d to ' || p_scenario_id);
761: dbms_aw.execute('limit planning_cycle_d to planning_cycle_scenario_r');
762: dbms_aw.execute('limit scenario_d to planning_cycle_d');
763: dbms_aw.execute('limit scenario_d keep scenario_working_m');

Line 760: dbms_aw.execute('limit scenario_d to ' || p_scenario_id);

756:
757: dbms_aw.execute('PUSH scenario_d');
758: dbms_aw.execute('PUSH planning_cycle_d');
759: dbms_aw.execute('oknullstatus = y');
760: dbms_aw.execute('limit scenario_d to ' || p_scenario_id);
761: dbms_aw.execute('limit planning_cycle_d to planning_cycle_scenario_r');
762: dbms_aw.execute('limit scenario_d to planning_cycle_d');
763: dbms_aw.execute('limit scenario_d keep scenario_working_m');
764: dbms_aw.execute('scenario_working_m = na');

Line 761: dbms_aw.execute('limit planning_cycle_d to planning_cycle_scenario_r');

757: dbms_aw.execute('PUSH scenario_d');
758: dbms_aw.execute('PUSH planning_cycle_d');
759: dbms_aw.execute('oknullstatus = y');
760: dbms_aw.execute('limit scenario_d to ' || p_scenario_id);
761: dbms_aw.execute('limit planning_cycle_d to planning_cycle_scenario_r');
762: dbms_aw.execute('limit scenario_d to planning_cycle_d');
763: dbms_aw.execute('limit scenario_d keep scenario_working_m');
764: dbms_aw.execute('scenario_working_m = na');
765: dbms_aw.execute('limit scenario_d to ' || p_scenario_id);

Line 762: dbms_aw.execute('limit scenario_d to planning_cycle_d');

758: dbms_aw.execute('PUSH planning_cycle_d');
759: dbms_aw.execute('oknullstatus = y');
760: dbms_aw.execute('limit scenario_d to ' || p_scenario_id);
761: dbms_aw.execute('limit planning_cycle_d to planning_cycle_scenario_r');
762: dbms_aw.execute('limit scenario_d to planning_cycle_d');
763: dbms_aw.execute('limit scenario_d keep scenario_working_m');
764: dbms_aw.execute('scenario_working_m = na');
765: dbms_aw.execute('limit scenario_d to ' || p_scenario_id);
766: dbms_aw.execute('scenario_working_m = yes');

Line 763: dbms_aw.execute('limit scenario_d keep scenario_working_m');

759: dbms_aw.execute('oknullstatus = y');
760: dbms_aw.execute('limit scenario_d to ' || p_scenario_id);
761: dbms_aw.execute('limit planning_cycle_d to planning_cycle_scenario_r');
762: dbms_aw.execute('limit scenario_d to planning_cycle_d');
763: dbms_aw.execute('limit scenario_d keep scenario_working_m');
764: dbms_aw.execute('scenario_working_m = na');
765: dbms_aw.execute('limit scenario_d to ' || p_scenario_id);
766: dbms_aw.execute('scenario_working_m = yes');
767: dbms_aw.execute('POP scenario_d');

Line 764: dbms_aw.execute('scenario_working_m = na');

760: dbms_aw.execute('limit scenario_d to ' || p_scenario_id);
761: dbms_aw.execute('limit planning_cycle_d to planning_cycle_scenario_r');
762: dbms_aw.execute('limit scenario_d to planning_cycle_d');
763: dbms_aw.execute('limit scenario_d keep scenario_working_m');
764: dbms_aw.execute('scenario_working_m = na');
765: dbms_aw.execute('limit scenario_d to ' || p_scenario_id);
766: dbms_aw.execute('scenario_working_m = yes');
767: dbms_aw.execute('POP scenario_d');
768: dbms_aw.execute('POP planning_cycle_d');

Line 765: dbms_aw.execute('limit scenario_d to ' || p_scenario_id);

761: dbms_aw.execute('limit planning_cycle_d to planning_cycle_scenario_r');
762: dbms_aw.execute('limit scenario_d to planning_cycle_d');
763: dbms_aw.execute('limit scenario_d keep scenario_working_m');
764: dbms_aw.execute('scenario_working_m = na');
765: dbms_aw.execute('limit scenario_d to ' || p_scenario_id);
766: dbms_aw.execute('scenario_working_m = yes');
767: dbms_aw.execute('POP scenario_d');
768: dbms_aw.execute('POP planning_cycle_d');
769:

Line 766: dbms_aw.execute('scenario_working_m = yes');

762: dbms_aw.execute('limit scenario_d to planning_cycle_d');
763: dbms_aw.execute('limit scenario_d keep scenario_working_m');
764: dbms_aw.execute('scenario_working_m = na');
765: dbms_aw.execute('limit scenario_d to ' || p_scenario_id);
766: dbms_aw.execute('scenario_working_m = yes');
767: dbms_aw.execute('POP scenario_d');
768: dbms_aw.execute('POP planning_cycle_d');
769:
770: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 767: dbms_aw.execute('POP scenario_d');

763: dbms_aw.execute('limit scenario_d keep scenario_working_m');
764: dbms_aw.execute('scenario_working_m = na');
765: dbms_aw.execute('limit scenario_d to ' || p_scenario_id);
766: dbms_aw.execute('scenario_working_m = yes');
767: dbms_aw.execute('POP scenario_d');
768: dbms_aw.execute('POP planning_cycle_d');
769:
770: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
771: fnd_log.string

Line 768: dbms_aw.execute('POP planning_cycle_d');

764: dbms_aw.execute('scenario_working_m = na');
765: dbms_aw.execute('limit scenario_d to ' || p_scenario_id);
766: dbms_aw.execute('scenario_working_m = yes');
767: dbms_aw.execute('POP scenario_d');
768: dbms_aw.execute('POP planning_cycle_d');
769:
770: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
771: fnd_log.string
772: (

Line 839: dbms_aw.execute('PUSH scenario_d');

835: 'Unsetting any previous flags and setting new flag.'
836: );
837: END IF;
838:
839: dbms_aw.execute('PUSH scenario_d');
840: dbms_aw.execute('lmt scenario_d to ' || p_scenario_id);
841: dbms_aw.execute('scenario_recommended_flag_m = ' || p_scenario_reccom_status);
842: dbms_aw.execute('POP scenario_d');
843:

Line 840: dbms_aw.execute('lmt scenario_d to ' || p_scenario_id);

836: );
837: END IF;
838:
839: dbms_aw.execute('PUSH scenario_d');
840: dbms_aw.execute('lmt scenario_d to ' || p_scenario_id);
841: dbms_aw.execute('scenario_recommended_flag_m = ' || p_scenario_reccom_status);
842: dbms_aw.execute('POP scenario_d');
843:
844: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 841: dbms_aw.execute('scenario_recommended_flag_m = ' || p_scenario_reccom_status);

837: END IF;
838:
839: dbms_aw.execute('PUSH scenario_d');
840: dbms_aw.execute('lmt scenario_d to ' || p_scenario_id);
841: dbms_aw.execute('scenario_recommended_flag_m = ' || p_scenario_reccom_status);
842: dbms_aw.execute('POP scenario_d');
843:
844: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
845: fnd_log.string

Line 842: dbms_aw.execute('POP scenario_d');

838:
839: dbms_aw.execute('PUSH scenario_d');
840: dbms_aw.execute('lmt scenario_d to ' || p_scenario_id);
841: dbms_aw.execute('scenario_recommended_flag_m = ' || p_scenario_reccom_status);
842: dbms_aw.execute('POP scenario_d');
843:
844: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
845: fnd_log.string
846: (

Line 919: dbms_aw.execute('PUSH scenario_d');

915: 'Limiting to scenario id passed.'
916: );
917: END IF;
918:
919: dbms_aw.execute('PUSH scenario_d');
920: dbms_aw.execute('LMT scenario_d TO ' || p_scenario_id);
921:
922: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
923: fnd_log.string

Line 920: dbms_aw.execute('LMT scenario_d TO ' || p_scenario_id);

916: );
917: END IF;
918:
919: dbms_aw.execute('PUSH scenario_d');
920: dbms_aw.execute('LMT scenario_d TO ' || p_scenario_id);
921:
922: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
923: fnd_log.string
924: (

Line 967: dbms_aw.execute('funding_status_rec_scenario_project_r(project_d ' || l_project_id || ') = ''' || p_scenario_reccom_value || '''');

963: 'Updating FUNDING_STATUS_REC_SCENARIO_PROJECT_R relation for scenario: ' || p_scenario_id || ' and for project: ' || l_project_id
964: );
965: END IF;
966:
967: dbms_aw.execute('funding_status_rec_scenario_project_r(project_d ' || l_project_id || ') = ''' || p_scenario_reccom_value || '''');
968:
969: END LOOP;
970:
971: dbms_aw.execute('POP scenario_d');

Line 971: dbms_aw.execute('POP scenario_d');

967: dbms_aw.execute('funding_status_rec_scenario_project_r(project_d ' || l_project_id || ') = ''' || p_scenario_reccom_value || '''');
968:
969: END LOOP;
970:
971: dbms_aw.execute('POP scenario_d');
972:
973: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
974: fnd_log.string
975: (

Line 1046: dbms_aw.execute(l_str);

1042: (select planning_cycle from fpa_aw_sce_info_v where scenario = p_target_scen_id)
1043: and is_initial_scenario = 1 ;
1044:
1045: l_str := 'call copy_proj_data_prg(' || p_target_scen_id || ', ' || source_scen_id || ', '' ' || p_project_id_str || ''')';
1046: dbms_aw.execute(l_str);
1047: --('call copy_proj_data_prg(' || p_target_scen_id || ' ' || source_scen_id || ' '' ' || p_project_id_str || ''')');
1048:
1049: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1050: fnd_log.string

Line 1105: dbms_aw.execute(l_str);

1101:
1102: l_str := 'call remove_proj_from_sce_prg(' || p_scenario_id || ', ' || p_project_id || ')';
1103:
1104: -- dbms_output.put_line(l_str);
1105: dbms_aw.execute(l_str);
1106:
1107: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1108: fnd_log.string
1109: (

Line 1161: dbms_aw.execute('LMT scenario_d TO ' || p_proj_metrics(1).scenarioID );

1157: -- Update user ranking against project ID for the given scenario ID
1158: -- Limit Scenario ID
1159: IF( p_proj_metrics.Count > 0 ) THEN
1160: IF( p_proj_metrics.Count > 1 ) THEN
1161: dbms_aw.execute('LMT scenario_d TO ' || p_proj_metrics(1).scenarioID );
1162: END IF;
1163: FOR i IN p_proj_metrics.FIRST..p_proj_metrics.LAST
1164: LOOP
1165:

Line 1185: dbms_aw.execute('LMT project_d TO ' || p_proj_metrics(i).projectID );

1181: 'fpa.sql.FPA_Scenario_Pvt.Update_Proj_User_Ranks.end',
1182: 'FPA_Scenario_Pvt.Update_Proj_User_Ranks: Inside for loop:projectID='||p_proj_metrics(i).projectID);
1183: END IF;
1184: -- Limit project_d
1185: dbms_aw.execute('LMT project_d TO ' || p_proj_metrics(i).projectID );
1186:
1187: -- Set the the user rank for each project
1188: IF p_proj_metrics(i).user_rank IS NULL THEN
1189: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 1196: dbms_aw.execute( 'scenario_project_user_rank_m = na');

1192: FND_LOG.LEVEL_PROCEDURE,
1193: 'fpa.sql.FPA_Scenario_Pvt.Update_Proj_User_Ranks.end',
1194: 'FPA_Scenario_Pvt.Update_Proj_User_Ranks: Inside for loop:User Rank = na');
1195: END IF;
1196: dbms_aw.execute( 'scenario_project_user_rank_m = na');
1197: ELSE
1198: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1199: FND_LOG.String
1200: (

Line 1205: dbms_aw.execute( 'scenario_project_user_rank_m = ' || p_proj_metrics(i).user_rank );

1201: FND_LOG.LEVEL_PROCEDURE,
1202: 'fpa.sql.FPA_Scenario_Pvt.Update_Proj_User_Ranks.end',
1203: 'FPA_Scenario_Pvt.Update_Proj_User_Ranks: Inside for loop:User Rank ='||p_proj_metrics(i).user_rank);
1204: END IF;
1205: dbms_aw.execute( 'scenario_project_user_rank_m = ' || p_proj_metrics(i).user_rank );
1206: END IF;
1207:
1208: END LOOP;
1209: END IF;

Line 1289: then dbms_aw.execute('call calc_sce_all_data_prg(' || p_scenario_id || ' na na ''' || p_data_to_calc || ''')');

1285: );
1286: END IF;
1287:
1288: if p_project_id is null and p_class_code_id is null
1289: then dbms_aw.execute('call calc_sce_all_data_prg(' || p_scenario_id || ' na na ''' || p_data_to_calc || ''')');
1290: elsif p_project_id is null
1291: then dbms_aw.execute('call calc_sce_all_data_prg(' || p_scenario_id || ' na ' || p_class_code_id || '''' || p_data_to_calc || ''')');
1292: elsif p_class_code_id is null
1293: then dbms_aw.execute('call calc_sce_all_data_prg(' || p_scenario_id || ' ' || p_project_id || ' na ''' || p_data_to_calc || ''')');

Line 1291: then dbms_aw.execute('call calc_sce_all_data_prg(' || p_scenario_id || ' na ' || p_class_code_id || '''' || p_data_to_calc || ''')');

1287:
1288: if p_project_id is null and p_class_code_id is null
1289: then dbms_aw.execute('call calc_sce_all_data_prg(' || p_scenario_id || ' na na ''' || p_data_to_calc || ''')');
1290: elsif p_project_id is null
1291: then dbms_aw.execute('call calc_sce_all_data_prg(' || p_scenario_id || ' na ' || p_class_code_id || '''' || p_data_to_calc || ''')');
1292: elsif p_class_code_id is null
1293: then dbms_aw.execute('call calc_sce_all_data_prg(' || p_scenario_id || ' ' || p_project_id || ' na ''' || p_data_to_calc || ''')');
1294: end if;
1295:

Line 1293: then dbms_aw.execute('call calc_sce_all_data_prg(' || p_scenario_id || ' ' || p_project_id || ' na ''' || p_data_to_calc || ''')');

1289: then dbms_aw.execute('call calc_sce_all_data_prg(' || p_scenario_id || ' na na ''' || p_data_to_calc || ''')');
1290: elsif p_project_id is null
1291: then dbms_aw.execute('call calc_sce_all_data_prg(' || p_scenario_id || ' na ' || p_class_code_id || '''' || p_data_to_calc || ''')');
1292: elsif p_class_code_id is null
1293: then dbms_aw.execute('call calc_sce_all_data_prg(' || p_scenario_id || ' ' || p_project_id || ' na ''' || p_data_to_calc || ''')');
1294: end if;
1295:
1296: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1297: fnd_log.string