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_INVESTMENT_CRITERIA_PVT dependencies on DBMS_AW

Line 34: dbms_aw.execute('define strategic_obj_d dimension text');

30: END IF;
31:
32: -- if flag eq 'Y' create the strategic objective dimension.
33: IF (p_Investment_rec_type.create_strategic_obj_d = 'Y') THEN
34: dbms_aw.execute('define strategic_obj_d dimension text');
35: END IF;
36:
37: -- if flag eq 'Y' create the strategic objective relation.
38: IF (p_Investment_rec_type.create_strategic_obj_h = 'Y') THEN

Line 39: dbms_aw.execute('define strategic_obj_h relation strategic_obj_d ');

35: END IF;
36:
37: -- if flag eq 'Y' create the strategic objective relation.
38: IF (p_Investment_rec_type.create_strategic_obj_h = 'Y') THEN
39: dbms_aw.execute('define strategic_obj_h relation strategic_obj_d ');
40: END IF;
41:
42: -- if flag eq 'Y' create the strategic_obj_weight_m measure.
43: IF (p_Investment_rec_type.create_strategic_obj_weight_m = 'Y') THEN

Line 44: dbms_aw.execute('define strategic_obj_weight_m decimal');

40: END IF;
41:
42: -- if flag eq 'Y' create the strategic_obj_weight_m measure.
43: IF (p_Investment_rec_type.create_strategic_obj_weight_m = 'Y') THEN
44: dbms_aw.execute('define strategic_obj_weight_m decimal');
45: END IF;
46:
47: -- if flag eq 'Y' create the strategic_obj_score_m measure.
48: IF (p_Investment_rec_type.create_strategic_obj_score_m = 'Y') THEN

Line 49: dbms_aw.Execute('define strategic_obj_score_m decimal');

45: END IF;
46:
47: -- if flag eq 'Y' create the strategic_obj_score_m measure.
48: IF (p_Investment_rec_type.create_strategic_obj_score_m = 'Y') THEN
49: dbms_aw.Execute('define strategic_obj_score_m decimal');
50: END IF;
51:
52: -- if flag eq 'Y' create the strategic_obj_wscore_m measure.
53: IF (p_investment_rec_type.create_strategic_obj_wscore_m = 'Y') THEN

Line 54: dbms_aw.xecute('define strategic_obj_wscore_m decimal');

50: END IF;
51:
52: -- if flag eq 'Y' create the strategic_obj_wscore_m measure.
53: IF (p_investment_rec_type.create_strategic_obj_wscore_m = 'Y') THEN
54: dbms_aw.xecute('define strategic_obj_wscore_m decimal');
55: END IF;
56:
57: -- if flag eq 'Y' create the strategic_obj_status_r measure.
58: IF (p_Investment_rec_type.create_strategic_obj_status_r = 'Y') THEN

Line 59: DBMS_AW.Execute('define strategic_obj_status_r relation attribute_library_d ');

55: END IF;
56:
57: -- if flag eq 'Y' create the strategic_obj_status_r measure.
58: IF (p_Investment_rec_type.create_strategic_obj_status_r = 'Y') THEN
59: DBMS_AW.Execute('define strategic_obj_status_r relation attribute_library_d ');
60: END IF;
61:
62: IF (p_commit = FND_API.G_TRUE) THEN
63: DBMS_AW.Execute('UPDATE');

Line 63: DBMS_AW.Execute('UPDATE');

59: DBMS_AW.Execute('define strategic_obj_status_r relation attribute_library_d ');
60: END IF;
61:
62: IF (p_commit = FND_API.G_TRUE) THEN
63: DBMS_AW.Execute('UPDATE');
64: COMMIT;
65: END IF;
66:
67:

Line 199: dbms_aw.execute('maintain strategic_obj_d add '

195: END LOOP;
196: CLOSE l_language_csr;
197: end if;
198: -- add the strategic objective to the strategic objective dimension.
199: dbms_aw.execute('maintain strategic_obj_d add '
200: || x_strategic_obj_id);
201:
202: -- if parent value is not null then add the parent to the
203: -- strategic objective hierarchy.

Line 205: dbms_aw.Execute('strategic_obj_h(strategic_obj_d '

201:
202: -- if parent value is not null then add the parent to the
203: -- strategic objective hierarchy.
204: IF (p_investment_rec_type.strategic_obj_parent IS NOT NULL) THEN
205: dbms_aw.Execute('strategic_obj_h(strategic_obj_d '
206: || x_strategic_obj_id || ') = '
207: || p_Investment_rec_type.strategic_obj_parent);
208: END IF;
209:

Line 252: dbms_aw.Execute('maintain strategic_obj_d delete ' || p_Investment_rec_type.strategic_obj_shortname);

248: );
249: END IF;
250:
251: -- Delete the Strategic Objective from the AW space.
252: dbms_aw.Execute('maintain strategic_obj_d delete ' || p_Investment_rec_type.strategic_obj_shortname);
253:
254: --Delete from FPA_OBJECTS_TL
255: delete from FPA_OBJECTS_TL
256: where object = 'INVESTMENT_CRITERIA'

Line 366: dbms_aw.execute('strategic_obj_status_r(strategic_obj_d '

362: END IF;
363:
364:
365: -- Set the strategic_obj_status_r relation according to passed values.
366: dbms_aw.execute('strategic_obj_status_r(strategic_obj_d '
367: || p_Investment_rec_type.strategic_obj_shortname || ') = '''
368: || p_Investment_rec_type.strategic_obj_status || '''');
369:
370: EXCEPTION

Line 408: dbms_aw.execute('invest_criteria_level_r(strategic_obj_d '

404: END IF;
405:
406:
407: -- Set the invest_criteria_level_r relation according to passed values.
408: dbms_aw.execute('invest_criteria_level_r(strategic_obj_d '
409: || p_Investment_rec_type.strategic_obj_shortname || ') = '''
410: || p_Investment_rec_type.strategic_obj_level || '''');
411:
412: EXCEPTION

Line 490: DBMS_AW.Execute('lmt strategic_obj_d to '

486: replace(rtrim(substr(l_temp_string,
487: (instr(l_temp_string,':')+1)), ';'), '%', '');
488:
489: -- limit the strategic objective dimension
490: DBMS_AW.Execute('lmt strategic_obj_d to '
491: || l_Investment_rec_type.strategic_obj_shortname);
492:
493: -- Set the strategic_obj_weight_m value equal to the one passed.
494: -- First check if there is a valid score.

Line 498: DBMS_AW.Execute('strategic_obj_weight_m = ' || l_Investment_rec_type.strategic_obj_weight);

494: -- First check if there is a valid score.
495: if (l_Investment_rec_type.strategic_obj_weight is null) then
496: l_Investment_rec_type.strategic_obj_weight := 0;
497: end if;
498: DBMS_AW.Execute('strategic_obj_weight_m = ' || l_Investment_rec_type.strategic_obj_weight);
499:
500: l_objective_string := substr(l_objective_string, (instr(l_objective_string, ';') + 1));
501: END LOOP;
502:

Line 533: DBMS_AW.Execute('lmt project_type_d to '''

529:
530: -- Attach the AW space read write.
531:
532: -- limit the project dimension to the current project
533: DBMS_AW.Execute('lmt project_type_d to '''
534: || p_Investment_rec_type.project_type_shortname || '''');
535:
536: -- limit the project dimension to the current project
537: DBMS_AW.Execute('lmt scenario_d to '''

Line 537: DBMS_AW.Execute('lmt scenario_d to '''

533: DBMS_AW.Execute('lmt project_type_d to '''
534: || p_Investment_rec_type.project_type_shortname || '''');
535:
536: -- limit the project dimension to the current project
537: DBMS_AW.Execute('lmt scenario_d to '''
538: || p_Investment_rec_type.scenario_shortname || '''');
539:
540: -- limit the project to the ones under the same project type.
541: DBMS_AW.Execute('lmt project_d to project_type_d');

Line 541: DBMS_AW.Execute('lmt project_d to project_type_d');

537: DBMS_AW.Execute('lmt scenario_d to '''
538: || p_Investment_rec_type.scenario_shortname || '''');
539:
540: -- limit the project to the ones under the same project type.
541: DBMS_AW.Execute('lmt project_d to project_type_d');
542: -- keep projects which belong to the current scenario.
543: DBMS_AW.Execute('lmt project_d keep scenario_project_m');
544: -- limit strategic objective dimension to all.
545: DBMS_AW.Execute('limit strategic_obj_d to all');

Line 543: DBMS_AW.Execute('lmt project_d keep scenario_project_m');

539:
540: -- limit the project to the ones under the same project type.
541: DBMS_AW.Execute('lmt project_d to project_type_d');
542: -- keep projects which belong to the current scenario.
543: DBMS_AW.Execute('lmt project_d keep scenario_project_m');
544: -- limit strategic objective dimension to all.
545: DBMS_AW.Execute('limit strategic_obj_d to all');
546: -- sum all scores into current project type and then divide it by
547: -- the number of projects in status.

Line 545: DBMS_AW.Execute('limit strategic_obj_d to all');

541: DBMS_AW.Execute('lmt project_d to project_type_d');
542: -- keep projects which belong to the current scenario.
543: DBMS_AW.Execute('lmt project_d keep scenario_project_m');
544: -- limit strategic objective dimension to all.
545: DBMS_AW.Execute('limit strategic_obj_d to all');
546: -- sum all scores into current project type and then divide it by
547: -- the number of projects in status.
548: DBMS_AW.Execute('scenario_project_type_obj_score_m = '
549: || ' total(scenario_project_obj_score_m, strategic_obj_d)/statlen(project_d)');

Line 548: DBMS_AW.Execute('scenario_project_type_obj_score_m = '

544: -- limit strategic objective dimension to all.
545: DBMS_AW.Execute('limit strategic_obj_d to all');
546: -- sum all scores into current project type and then divide it by
547: -- the number of projects in status.
548: DBMS_AW.Execute('scenario_project_type_obj_score_m = '
549: || ' total(scenario_project_obj_score_m, strategic_obj_d)/statlen(project_d)');
550:
551: IF (p_commit = FND_API.G_TRUE) THEN
552: DBMS_AW.Execute('update');

Line 552: DBMS_AW.Execute('update');

548: DBMS_AW.Execute('scenario_project_type_obj_score_m = '
549: || ' total(scenario_project_obj_score_m, strategic_obj_d)/statlen(project_d)');
550:
551: IF (p_commit = FND_API.G_TRUE) THEN
552: DBMS_AW.Execute('update');
553: COMMIT;
554: END IF;
555:
556:

Line 593: DBMS_AW.Execute('lmt project_d to ''' || p_Investment_rec_type.project_shortname || '''');

589:
590: -- Attach the AW space read write.
591:
592: -- limit the project dimension to the current project
593: DBMS_AW.Execute('lmt project_d to ''' || p_Investment_rec_type.project_shortname || '''');
594:
595: -- limit the project dimension to the current project
596: DBMS_AW.Execute('lmt scenario_d to ''' || p_Investment_rec_type.scenario_shortname || '''');
597:

Line 596: DBMS_AW.Execute('lmt scenario_d to ''' || p_Investment_rec_type.scenario_shortname || '''');

592: -- limit the project dimension to the current project
593: DBMS_AW.Execute('lmt project_d to ''' || p_Investment_rec_type.project_shortname || '''');
594:
595: -- limit the project dimension to the current project
596: DBMS_AW.Execute('lmt scenario_d to ''' || p_Investment_rec_type.scenario_shortname || '''');
597:
598: -- Set the strategic_obj_weight_m value equal to the one passed.
599: DBMS_AW.Execute('scenario_project_obj_wscore_m = (strategic_obj_weight_m/100) * (scenario_project_obj_score_m)');
600:

Line 599: DBMS_AW.Execute('scenario_project_obj_wscore_m = (strategic_obj_weight_m/100) * (scenario_project_obj_score_m)');

595: -- limit the project dimension to the current project
596: DBMS_AW.Execute('lmt scenario_d to ''' || p_Investment_rec_type.scenario_shortname || '''');
597:
598: -- Set the strategic_obj_weight_m value equal to the one passed.
599: DBMS_AW.Execute('scenario_project_obj_wscore_m = (strategic_obj_weight_m/100) * (scenario_project_obj_score_m)');
600:
601: IF (p_commit = FND_API.G_TRUE) THEN
602: DBMS_AW.Execute('update');
603: COMMIT;

Line 602: DBMS_AW.Execute('update');

598: -- Set the strategic_obj_weight_m value equal to the one passed.
599: DBMS_AW.Execute('scenario_project_obj_wscore_m = (strategic_obj_weight_m/100) * (scenario_project_obj_score_m)');
600:
601: IF (p_commit = FND_API.G_TRUE) THEN
602: DBMS_AW.Execute('update');
603: COMMIT;
604: END IF;
605:
606:

Line 642: DBMS_AW.Execute('lmt scenario_d to '''

638:
639: -- Attach the AW space read write
640:
641: -- limit scenario to the one passed.
642: DBMS_AW.Execute('lmt scenario_d to '''
643: || p_Investment_rec_type.scenario_shortname || '''');
644:
645: -- limit project to the one passed.
646: DBMS_AW.Execute('lmt project_d to '''

Line 646: DBMS_AW.Execute('lmt project_d to '''

642: DBMS_AW.Execute('lmt scenario_d to '''
643: || p_Investment_rec_type.scenario_shortname || '''');
644:
645: -- limit project to the one passed.
646: DBMS_AW.Execute('lmt project_d to '''
647: || p_Investment_rec_type.project_shortname || '''');
648:
649: -- limit project type to the one for the given project.
650: DBMS_AW.Execute('lmt project_type_d to project_d');

Line 650: DBMS_AW.Execute('lmt project_type_d to project_d');

646: DBMS_AW.Execute('lmt project_d to '''
647: || p_Investment_rec_type.project_shortname || '''');
648:
649: -- limit project type to the one for the given project.
650: DBMS_AW.Execute('lmt project_type_d to project_d');
651:
652: -- limit projects to the ones belonging to the current project type.
653: DBMS_AW.Execute('lmt project_d to project_type_d');
654:

Line 653: DBMS_AW.Execute('lmt project_d to project_type_d');

649: -- limit project type to the one for the given project.
650: DBMS_AW.Execute('lmt project_type_d to project_d');
651:
652: -- limit projects to the ones belonging to the current project type.
653: DBMS_AW.Execute('lmt project_d to project_type_d');
654:
655: -- keep those projects belonging to the current scenario.
656: DBMS_AW.Execute('lmt project_d keep scenario_project_m');
657:

Line 656: DBMS_AW.Execute('lmt project_d keep scenario_project_m');

652: -- limit projects to the ones belonging to the current project type.
653: DBMS_AW.Execute('lmt project_d to project_type_d');
654:
655: -- keep those projects belonging to the current scenario.
656: DBMS_AW.Execute('lmt project_d keep scenario_project_m');
657:
658: -- limit strategic objectives to all.
659: DBMS_AW.Execute('lmt strategic_obj_d to all');
660:

Line 659: DBMS_AW.Execute('lmt strategic_obj_d to all');

655: -- keep those projects belonging to the current scenario.
656: DBMS_AW.Execute('lmt project_d keep scenario_project_m');
657:
658: -- limit strategic objectives to all.
659: DBMS_AW.Execute('lmt strategic_obj_d to all');
660:
661: -- Get the Weighted Score for all projects into the project type and divide by the number of
662: -- projects.
663: DBMS_AW.Execute('scenario_project_type_obj_wscore_m =

Line 663: DBMS_AW.Execute('scenario_project_type_obj_wscore_m =

659: DBMS_AW.Execute('lmt strategic_obj_d to all');
660:
661: -- Get the Weighted Score for all projects into the project type and divide by the number of
662: -- projects.
663: DBMS_AW.Execute('scenario_project_type_obj_wscore_m =
664: total(scenario_project_obj_wscore_m, strategic_obj_d)/statlen(project_d)');
665:
666: IF (p_commit = FND_API.G_TRUE) THEN
667: DBMS_AW.Execute('update');

Line 667: DBMS_AW.Execute('update');

663: DBMS_AW.Execute('scenario_project_type_obj_wscore_m =
664: total(scenario_project_obj_wscore_m, strategic_obj_d)/statlen(project_d)');
665:
666: IF (p_commit = FND_API.G_TRUE) THEN
667: DBMS_AW.Execute('update');
668: COMMIT;
669: END IF;
670:
671:

Line 732: DBMS_AW.Execute('lmt project_d to ''' || p_Investment_rec_type.project_shortname || '''');

728:
729: -- Attach the AW space read write.
730:
731: -- limit the project dimension to the current project
732: DBMS_AW.Execute('lmt project_d to ''' || p_Investment_rec_type.project_shortname || '''');
733:
734: -- limit the scnearioproject dimension to the current project
735: DBMS_AW.Execute('lmt scenario_d to ''' || p_Investment_rec_type.scenario_shortname || '''');
736:

Line 735: DBMS_AW.Execute('lmt scenario_d to ''' || p_Investment_rec_type.scenario_shortname || '''');

731: -- limit the project dimension to the current project
732: DBMS_AW.Execute('lmt project_d to ''' || p_Investment_rec_type.project_shortname || '''');
733:
734: -- limit the scnearioproject dimension to the current project
735: DBMS_AW.Execute('lmt scenario_d to ''' || p_Investment_rec_type.scenario_shortname || '''');
736:
737: -- execute cursor.
738: open l_obj_csr for l_sql;
739: loop

Line 754: DBMS_AW.Execute('limit strategic_obj_d to ''' || l_obj_member_name || '''');

750: and b.tab_id = l_temp_tab_id
751: group by b.shortname;
752:
753: -- limit strategic objective to the children of the current Group.
754: DBMS_AW.Execute('limit strategic_obj_d to ''' || l_obj_member_name || '''');
755: DBMS_AW.Execute('limit strategic_obj_d to children using strategic_obj_h');
756: -- set the average score of the Group
757: DBMS_AW.Execute('scenario_project_obj_score_m(strategic_obj_d ''' || l_obj_member_name || ''') = total(scenario_project_obj_score_m)/' || l_obj_count || '');
758:

Line 755: DBMS_AW.Execute('limit strategic_obj_d to children using strategic_obj_h');

751: group by b.shortname;
752:
753: -- limit strategic objective to the children of the current Group.
754: DBMS_AW.Execute('limit strategic_obj_d to ''' || l_obj_member_name || '''');
755: DBMS_AW.Execute('limit strategic_obj_d to children using strategic_obj_h');
756: -- set the average score of the Group
757: DBMS_AW.Execute('scenario_project_obj_score_m(strategic_obj_d ''' || l_obj_member_name || ''') = total(scenario_project_obj_score_m)/' || l_obj_count || '');
758:
759: -- set the sum of weighted scores

Line 757: DBMS_AW.Execute('scenario_project_obj_score_m(strategic_obj_d ''' || l_obj_member_name || ''') = total(scenario_project_obj_score_m)/' || l_obj_count || '');

753: -- limit strategic objective to the children of the current Group.
754: DBMS_AW.Execute('limit strategic_obj_d to ''' || l_obj_member_name || '''');
755: DBMS_AW.Execute('limit strategic_obj_d to children using strategic_obj_h');
756: -- set the average score of the Group
757: DBMS_AW.Execute('scenario_project_obj_score_m(strategic_obj_d ''' || l_obj_member_name || ''') = total(scenario_project_obj_score_m)/' || l_obj_count || '');
758:
759: -- set the sum of weighted scores
760: DBMS_AW.Execute('scenario_project_obj_wscore_m(strategic_obj_d ''' || l_obj_member_name || ''') = total(scenario_project_obj_wscore_m)');
761:

Line 760: DBMS_AW.Execute('scenario_project_obj_wscore_m(strategic_obj_d ''' || l_obj_member_name || ''') = total(scenario_project_obj_wscore_m)');

756: -- set the average score of the Group
757: DBMS_AW.Execute('scenario_project_obj_score_m(strategic_obj_d ''' || l_obj_member_name || ''') = total(scenario_project_obj_score_m)/' || l_obj_count || '');
758:
759: -- set the sum of weighted scores
760: DBMS_AW.Execute('scenario_project_obj_wscore_m(strategic_obj_d ''' || l_obj_member_name || ''') = total(scenario_project_obj_wscore_m)');
761:
762: -- We must set the status of the dimension equal to all. Views based on AW use the current
763: -- dimension status.
764: DBMS_AW.Execute('limit strategic_obj_d to all');

Line 764: DBMS_AW.Execute('limit strategic_obj_d to all');

760: DBMS_AW.Execute('scenario_project_obj_wscore_m(strategic_obj_d ''' || l_obj_member_name || ''') = total(scenario_project_obj_wscore_m)');
761:
762: -- We must set the status of the dimension equal to all. Views based on AW use the current
763: -- dimension status.
764: DBMS_AW.Execute('limit strategic_obj_d to all');
765:
766: end loop;
767:
768: -- Now we get the average of all five strategic objectives.

Line 769: DBMS_AW.Execute('lmt strategic_obj_d to ''FPASTRALIGN''');

765:
766: end loop;
767:
768: -- Now we get the average of all five strategic objectives.
769: DBMS_AW.Execute('lmt strategic_obj_d to ''FPASTRALIGN''');
770: DBMS_AW.Execute('limit strategic_obj_d to children using strategic_obj_h');
771: DBMS_AW.Execute('scenario_project_obj_score_m(strategic_obj_d ''FPASTRALIGN'') = total(scenario_project_obj_score_m)/5');
772:
773: DBMS_AW.Execute('update');

Line 770: DBMS_AW.Execute('limit strategic_obj_d to children using strategic_obj_h');

766: end loop;
767:
768: -- Now we get the average of all five strategic objectives.
769: DBMS_AW.Execute('lmt strategic_obj_d to ''FPASTRALIGN''');
770: DBMS_AW.Execute('limit strategic_obj_d to children using strategic_obj_h');
771: DBMS_AW.Execute('scenario_project_obj_score_m(strategic_obj_d ''FPASTRALIGN'') = total(scenario_project_obj_score_m)/5');
772:
773: DBMS_AW.Execute('update');
774:

Line 771: DBMS_AW.Execute('scenario_project_obj_score_m(strategic_obj_d ''FPASTRALIGN'') = total(scenario_project_obj_score_m)/5');

767:
768: -- Now we get the average of all five strategic objectives.
769: DBMS_AW.Execute('lmt strategic_obj_d to ''FPASTRALIGN''');
770: DBMS_AW.Execute('limit strategic_obj_d to children using strategic_obj_h');
771: DBMS_AW.Execute('scenario_project_obj_score_m(strategic_obj_d ''FPASTRALIGN'') = total(scenario_project_obj_score_m)/5');
772:
773: DBMS_AW.Execute('update');
774:
775: if (p_commit = FND_API.G_TRUE) then

Line 773: DBMS_AW.Execute('update');

769: DBMS_AW.Execute('lmt strategic_obj_d to ''FPASTRALIGN''');
770: DBMS_AW.Execute('limit strategic_obj_d to children using strategic_obj_h');
771: DBMS_AW.Execute('scenario_project_obj_score_m(strategic_obj_d ''FPASTRALIGN'') = total(scenario_project_obj_score_m)/5');
772:
773: DBMS_AW.Execute('update');
774:
775: if (p_commit = FND_API.G_TRUE) then
776: commit;
777: end if;

Line 806: DBMS_AW.Execute('aw attach ' || p_Investment_rec_type.AW_space || ' rw first');

802:
803: begin
804:
805: -- Attach the AW space read write
806: DBMS_AW.Execute('aw attach ' || p_Investment_rec_type.AW_space || ' rw first');
807:
808: -- limit project type to the one passed.
809: DBMS_AW.Execute('lmt project_type_d to ''' || p_Investment_rec_type.project_type_shortname || '''');
810:

Line 809: DBMS_AW.Execute('lmt project_type_d to ''' || p_Investment_rec_type.project_type_shortname || '''');

805: -- Attach the AW space read write
806: DBMS_AW.Execute('aw attach ' || p_Investment_rec_type.AW_space || ' rw first');
807:
808: -- limit project type to the one passed.
809: DBMS_AW.Execute('lmt project_type_d to ''' || p_Investment_rec_type.project_type_shortname || '''');
810:
811: -- limit scenario to the one passed.
812: DBMS_AW.Execute('lmt scenario_d to ''' || p_Investment_rec_type.scenario_shortname || '''');
813:

Line 812: DBMS_AW.Execute('lmt scenario_d to ''' || p_Investment_rec_type.scenario_shortname || '''');

808: -- limit project type to the one passed.
809: DBMS_AW.Execute('lmt project_type_d to ''' || p_Investment_rec_type.project_type_shortname || '''');
810:
811: -- limit scenario to the one passed.
812: DBMS_AW.Execute('lmt scenario_d to ''' || p_Investment_rec_type.scenario_shortname || '''');
813:
814: -- limit projects to the ones belonging to the current project type.
815: DBMS_AW.Execute('lmt project_d to project_type_d');
816:

Line 815: DBMS_AW.Execute('lmt project_d to project_type_d');

811: -- limit scenario to the one passed.
812: DBMS_AW.Execute('lmt scenario_d to ''' || p_Investment_rec_type.scenario_shortname || '''');
813:
814: -- limit projects to the ones belonging to the current project type.
815: DBMS_AW.Execute('lmt project_d to project_type_d');
816:
817: -- keep those projects belonging to the current scenario.
818: DBMS_AW.Execute('lmt project_d keep scenario_project_m');
819:

Line 818: DBMS_AW.Execute('lmt project_d keep scenario_project_m');

814: -- limit projects to the ones belonging to the current project type.
815: DBMS_AW.Execute('lmt project_d to project_type_d');
816:
817: -- keep those projects belonging to the current scenario.
818: DBMS_AW.Execute('lmt project_d keep scenario_project_m');
819:
820: -- limit strategic objectives to all.
821: DBMS_AW.Execute('lmt strategic_obj_d to all');
822:

Line 821: DBMS_AW.Execute('lmt strategic_obj_d to all');

817: -- keep those projects belonging to the current scenario.
818: DBMS_AW.Execute('lmt project_d keep scenario_project_m');
819:
820: -- limit strategic objectives to all.
821: DBMS_AW.Execute('lmt strategic_obj_d to all');
822:
823: -- Get the average score of all projects into the project type and divide it by the
824: -- number of projects in status.
825: DBMS_AW.Execute('scenario_project_type_obj

Line 825: DBMS_AW.Execute('scenario_project_type_obj

821: DBMS_AW.Execute('lmt strategic_obj_d to all');
822:
823: -- Get the average score of all projects into the project type and divide it by the
824: -- number of projects in status.
825: DBMS_AW.Execute('scenario_project_type_obj
826:
827:
828: EXCEPTION
829: WHEN FND_API.G_EXC_ERROR THEN

Line 830: DBMS_AW.Execute('aw detach ' || p_Investment_rec_type.AW_space);

826:
827:
828: EXCEPTION
829: WHEN FND_API.G_EXC_ERROR THEN
830: DBMS_AW.Execute('aw detach ' || p_Investment_rec_type.AW_space);
831: rollback;
832: x_return_status := FND_API.G_RET_STS_ERROR;
833: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
834: ,p_data => x_msg_data);

Line 837: DBMS_AW.Execute('aw detach ' || p_Investment_rec_type.AW_space);

833: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
834: ,p_data => x_msg_data);
835: raise;
836: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
837: DBMS_AW.Execute('aw detach ' || p_Investment_rec_type.AW_space);
838: rollback;
839: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
840: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
841: ,p_data => x_msg_data);

Line 844: DBMS_AW.Execute('aw detach ' || p_Investment_rec_type.AW_space);

840: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
841: ,p_data => x_msg_data);
842: raise;
843: WHEN NO_DATA_FOUND THEN
844: DBMS_AW.Execute('aw detach ' || p_Investment_rec_type.AW_space);
845: rollback;
846: x_return_status := FND_API.G_RET_STS_ERROR;
847: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
848: ,p_data => x_msg_data);

Line 851: DBMS_AW.Execute('aw detach ' || p_Investment_rec_type.AW_space);

847: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
848: ,p_data => x_msg_data);
849: raise;
850: WHEN OTHERS THEN
851: DBMS_AW.Execute('aw detach ' || p_Investment_rec_type.AW_space);
852: rollback;
853: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
854: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
855: ,p_data => x_msg_data);

Line 882: DBMS_AW.Execute('lmt project_d to ''' || p_Investment_rec_type.project_shortname || '''');

878:
879: -- Attach the AW space read write.
880:
881: -- limit the project dimension to the current project
882: DBMS_AW.Execute('lmt project_d to ''' || p_Investment_rec_type.project_shortname || '''');
883:
884: -- limit the project dimension to the current project
885: DBMS_AW.Execute('lmt scenario_d to ''' || p_Investment_rec_type.scenario_shortname || '''');
886:

Line 885: DBMS_AW.Execute('lmt scenario_d to ''' || p_Investment_rec_type.scenario_shortname || '''');

881: -- limit the project dimension to the current project
882: DBMS_AW.Execute('lmt project_d to ''' || p_Investment_rec_type.project_shortname || '''');
883:
884: -- limit the project dimension to the current project
885: DBMS_AW.Execute('lmt scenario_d to ''' || p_Investment_rec_type.scenario_shortname || '''');
886:
887: -- get the leaf nodes only
888: DBMS_AW.Execute('lmt strategic_obj_d to all');
889: DBMS_AW.Execute('lmt strategic_obj_d remove ancestors using strategic_obj_h');

Line 888: DBMS_AW.Execute('lmt strategic_obj_d to all');

884: -- limit the project dimension to the current project
885: DBMS_AW.Execute('lmt scenario_d to ''' || p_Investment_rec_type.scenario_shortname || '''');
886:
887: -- get the leaf nodes only
888: DBMS_AW.Execute('lmt strategic_obj_d to all');
889: DBMS_AW.Execute('lmt strategic_obj_d remove ancestors using strategic_obj_h');
890:
891: -- get the next level parents.
892: DBMS_AW.Execute('lmt strategic_obj_d add parents using strategic_obj_h');

Line 889: DBMS_AW.Execute('lmt strategic_obj_d remove ancestors using strategic_obj_h');

885: DBMS_AW.Execute('lmt scenario_d to ''' || p_Investment_rec_type.scenario_shortname || '''');
886:
887: -- get the leaf nodes only
888: DBMS_AW.Execute('lmt strategic_obj_d to all');
889: DBMS_AW.Execute('lmt strategic_obj_d remove ancestors using strategic_obj_h');
890:
891: -- get the next level parents.
892: DBMS_AW.Execute('lmt strategic_obj_d add parents using strategic_obj_h');
893:

Line 892: DBMS_AW.Execute('lmt strategic_obj_d add parents using strategic_obj_h');

888: DBMS_AW.Execute('lmt strategic_obj_d to all');
889: DBMS_AW.Execute('lmt strategic_obj_d remove ancestors using strategic_obj_h');
890:
891: -- get the next level parents.
892: DBMS_AW.Execute('lmt strategic_obj_d add parents using strategic_obj_h');
893:
894: -- rollup the weighted score
895: DBMS_AW.Execute('rollup scenario_project_obj_wscore_m over strategic_obj_d using strategic_obj_h');
896:

Line 895: DBMS_AW.Execute('rollup scenario_project_obj_wscore_m over strategic_obj_d using strategic_obj_h');

891: -- get the next level parents.
892: DBMS_AW.Execute('lmt strategic_obj_d add parents using strategic_obj_h');
893:
894: -- rollup the weighted score
895: DBMS_AW.Execute('rollup scenario_project_obj_wscore_m over strategic_obj_d using strategic_obj_h');
896:
897: -- remove the leaf nodes to weight the rolled up weighted scores.
898: DBMS_AW.Execute('lmt strategic_obj_d remove descendants using strategic_obj_h');
899:

Line 898: DBMS_AW.Execute('lmt strategic_obj_d remove descendants using strategic_obj_h');

894: -- rollup the weighted score
895: DBMS_AW.Execute('rollup scenario_project_obj_wscore_m over strategic_obj_d using strategic_obj_h');
896:
897: -- remove the leaf nodes to weight the rolled up weighted scores.
898: DBMS_AW.Execute('lmt strategic_obj_d remove descendants using strategic_obj_h');
899:
900: -- weight the score
901: DBMS_AW.Execute('scenario_project_obj_wscore_m = scenario_project_obj_wscore_m * (strategic_obj_weight_m/100)');
902:

Line 901: DBMS_AW.Execute('scenario_project_obj_wscore_m = scenario_project_obj_wscore_m * (strategic_obj_weight_m/100)');

897: -- remove the leaf nodes to weight the rolled up weighted scores.
898: DBMS_AW.Execute('lmt strategic_obj_d remove descendants using strategic_obj_h');
899:
900: -- weight the score
901: DBMS_AW.Execute('scenario_project_obj_wscore_m = scenario_project_obj_wscore_m * (strategic_obj_weight_m/100)');
902:
903: -- Now we will calculate the next level
904: -- get the next level parents.
905: DBMS_AW.Execute('lmt strategic_obj_d add parents using strategic_obj_h');

Line 905: DBMS_AW.Execute('lmt strategic_obj_d add parents using strategic_obj_h');

901: DBMS_AW.Execute('scenario_project_obj_wscore_m = scenario_project_obj_wscore_m * (strategic_obj_weight_m/100)');
902:
903: -- Now we will calculate the next level
904: -- get the next level parents.
905: DBMS_AW.Execute('lmt strategic_obj_d add parents using strategic_obj_h');
906:
907: -- rollup the weighted score
908: DBMS_AW.Execute('rollup scenario_project_obj_wscore_m over strategic_obj_d using strategic_obj_h');
909:

Line 908: DBMS_AW.Execute('rollup scenario_project_obj_wscore_m over strategic_obj_d using strategic_obj_h');

904: -- get the next level parents.
905: DBMS_AW.Execute('lmt strategic_obj_d add parents using strategic_obj_h');
906:
907: -- rollup the weighted score
908: DBMS_AW.Execute('rollup scenario_project_obj_wscore_m over strategic_obj_d using strategic_obj_h');
909:
910: -- At this point we are done rolling up data and weighting it. If by some
911: -- reason more levels are added to the hierarchy this will have to be
912: -- revistited.

Line 915: DBMS_AW.Execute('update');

911: -- reason more levels are added to the hierarchy this will have to be
912: -- revistited.
913:
914: IF (p_commit = FND_API.G_TRUE) THEN
915: DBMS_AW.Execute('update');
916: COMMIT;
917: END IF;
918:
919: