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

Line 266: dbms_aw.execute('LMT project_d TO ' || p_project_id );

262: end if;
263:
264: if(p_scorecard_tbl.count > 0) then
265:
266: dbms_aw.execute('LMT project_d TO ' || p_project_id );
267:
268: l_scorecards_tl_rec.project_id := p_project_id;
269: l_scorecards_tl_rec.scenario_id := -1;
270:

Line 309: dbms_aw.execute('LMT strategic_obj_d TO ' || l_scorecard_rec.strategic_obj_id );

305:
306: end if;
307:
308: --DIMENSION investment_criteria from strategic_obj_d
309: dbms_aw.execute('LMT strategic_obj_d TO ' || l_scorecard_rec.strategic_obj_id );
310:
311: if(l_scorecard_rec.new_score is null) then
312: dbms_aw.execute('project_entered_obj_score_m = NA' );
313: else

Line 312: dbms_aw.execute('project_entered_obj_score_m = NA' );

308: --DIMENSION investment_criteria from strategic_obj_d
309: dbms_aw.execute('LMT strategic_obj_d TO ' || l_scorecard_rec.strategic_obj_id );
310:
311: if(l_scorecard_rec.new_score is null) then
312: dbms_aw.execute('project_entered_obj_score_m = NA' );
313: else
314: dbms_aw.execute('project_entered_obj_score_m = ' || FND_NUMBER.number_to_canonical(l_scorecard_rec.new_score));
315: end if;
316:

Line 314: dbms_aw.execute('project_entered_obj_score_m = ' || FND_NUMBER.number_to_canonical(l_scorecard_rec.new_score));

310:
311: if(l_scorecard_rec.new_score is null) then
312: dbms_aw.execute('project_entered_obj_score_m = NA' );
313: else
314: dbms_aw.execute('project_entered_obj_score_m = ' || FND_NUMBER.number_to_canonical(l_scorecard_rec.new_score));
315: end if;
316:
317: end loop;
318:

Line 319: dbms_aw.execute('CALL CALC_PROJ_SCORECARD_PRG(' ||

315: end if;
316:
317: end loop;
318:
319: dbms_aw.execute('CALL CALC_PROJ_SCORECARD_PRG(' ||
320: p_planning_cycle_id || ',' ||
321: p_project_id || ')' );
322: -- Overwrite Root and Financial Category weighted score
323: dbms_aw.execute('LMT strategic_obj_d TO strategic_obj_d le 2');

Line 323: dbms_aw.execute('LMT strategic_obj_d TO strategic_obj_d le 2');

319: dbms_aw.execute('CALL CALC_PROJ_SCORECARD_PRG(' ||
320: p_planning_cycle_id || ',' ||
321: p_project_id || ')' );
322: -- Overwrite Root and Financial Category weighted score
323: dbms_aw.execute('LMT strategic_obj_d TO strategic_obj_d le 2');
324: dbms_aw.execute('project_strategic_obj_weights_score_m = NA' );
325:
326: end if;
327: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;

Line 324: dbms_aw.execute('project_strategic_obj_weights_score_m = NA' );

320: p_planning_cycle_id || ',' ||
321: p_project_id || ')' );
322: -- Overwrite Root and Financial Category weighted score
323: dbms_aw.execute('LMT strategic_obj_d TO strategic_obj_d le 2');
324: dbms_aw.execute('project_strategic_obj_weights_score_m = NA' );
325:
326: end if;
327: x_return_status := FPA_UTILITIES_PVT.G_RET_STS_SUCCESS;
328:

Line 435: dbms_aw.execute('LMT project_d TO ' || p_project_id );

431: end if;
432:
433: if(p_scorecard_tbl.count > 0) then
434:
435: dbms_aw.execute('LMT project_d TO ' || p_project_id );
436: dbms_aw.execute('LMT scenario_d TO ' || p_scenario_id );
437:
438: l_scorecards_tl_rec.project_id := p_project_id;
439: l_scorecards_tl_rec.scenario_id := p_scenario_id;

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

432:
433: if(p_scorecard_tbl.count > 0) then
434:
435: dbms_aw.execute('LMT project_d TO ' || p_project_id );
436: dbms_aw.execute('LMT scenario_d TO ' || p_scenario_id );
437:
438: l_scorecards_tl_rec.project_id := p_project_id;
439: l_scorecards_tl_rec.scenario_id := p_scenario_id;
440:

Line 479: dbms_aw.execute('LMT strategic_obj_d TO ' || l_scorecard_rec.strategic_obj_id );

475:
476: end if;
477:
478: --DIMENSION investment_criteria from strategic_obj_d
479: dbms_aw.execute('LMT strategic_obj_d TO ' || l_scorecard_rec.strategic_obj_id );
480:
481: if(l_scorecard_rec.new_score is null) then
482: dbms_aw.execute('scenario_project_obj_score_m = NA' );
483: else

Line 482: dbms_aw.execute('scenario_project_obj_score_m = NA' );

478: --DIMENSION investment_criteria from strategic_obj_d
479: dbms_aw.execute('LMT strategic_obj_d TO ' || l_scorecard_rec.strategic_obj_id );
480:
481: if(l_scorecard_rec.new_score is null) then
482: dbms_aw.execute('scenario_project_obj_score_m = NA' );
483: else
484: dbms_aw.execute('scenario_project_obj_score_m = ' || FND_NUMBER.number_to_canonical(round(l_scorecard_rec.new_score,2)));
485: end if;
486:

Line 484: dbms_aw.execute('scenario_project_obj_score_m = ' || FND_NUMBER.number_to_canonical(round(l_scorecard_rec.new_score,2)));

480:
481: if(l_scorecard_rec.new_score is null) then
482: dbms_aw.execute('scenario_project_obj_score_m = NA' );
483: else
484: dbms_aw.execute('scenario_project_obj_score_m = ' || FND_NUMBER.number_to_canonical(round(l_scorecard_rec.new_score,2)));
485: end if;
486:
487: end loop;
488:

Line 491: dbms_aw.execute('CALL CALC_SCEN_SCORECARD_PRG(' ||

487: end loop;
488:
489:
490:
491: dbms_aw.execute('CALL CALC_SCEN_SCORECARD_PRG(' ||
492: p_planning_cycle_id || ',' ||
493: p_scenario_id || ',' ||
494: p_project_id || ')' );
495: -- Overwrite Root and Financial Category weighted score

Line 496: dbms_aw.execute('LMT strategic_obj_d TO strategic_obj_d le 2');

492: p_planning_cycle_id || ',' ||
493: p_scenario_id || ',' ||
494: p_project_id || ')' );
495: -- Overwrite Root and Financial Category weighted score
496: dbms_aw.execute('LMT strategic_obj_d TO strategic_obj_d le 2');
497: dbms_aw.execute('scenario_project_obj_wscore_m = NA' );
498:
499: dbms_aw.execute('CALL CALC_SCE_COST_WSCORES_PRG(' ||
500: p_scenario_id || ')' );

Line 497: dbms_aw.execute('scenario_project_obj_wscore_m = NA' );

493: p_scenario_id || ',' ||
494: p_project_id || ')' );
495: -- Overwrite Root and Financial Category weighted score
496: dbms_aw.execute('LMT strategic_obj_d TO strategic_obj_d le 2');
497: dbms_aw.execute('scenario_project_obj_wscore_m = NA' );
498:
499: dbms_aw.execute('CALL CALC_SCE_COST_WSCORES_PRG(' ||
500: p_scenario_id || ')' );
501:

Line 499: dbms_aw.execute('CALL CALC_SCE_COST_WSCORES_PRG(' ||

495: -- Overwrite Root and Financial Category weighted score
496: dbms_aw.execute('LMT strategic_obj_d TO strategic_obj_d le 2');
497: dbms_aw.execute('scenario_project_obj_wscore_m = NA' );
498:
499: dbms_aw.execute('CALL CALC_SCE_COST_WSCORES_PRG(' ||
500: p_scenario_id || ')' );
501:
502:
503: dbms_aw.execute('CALL CALC_SCE_CLASS_COST_WSCORES_PRG(' ||

Line 503: dbms_aw.execute('CALL CALC_SCE_CLASS_COST_WSCORES_PRG(' ||

499: dbms_aw.execute('CALL CALC_SCE_COST_WSCORES_PRG(' ||
500: p_scenario_id || ')' );
501:
502:
503: dbms_aw.execute('CALL CALC_SCE_CLASS_COST_WSCORES_PRG(' ||
504: p_scenario_id || ',' ||
505: 'na,' ||
506: p_project_id || ')' );
507:

Line 589: dbms_aw.execute('CALL CALC_SCEN_SCORECARD_PRG(' ||

585: p_planning_cycle_id IN NUMBER,
586: p_scenario_id IN NUMBER) IS
587: BEGIN
588:
589: dbms_aw.execute('CALL CALC_SCEN_SCORECARD_PRG(' ||
590: l_planning_cycle_id || ',' ||
591: p_scenario_id || ',NA)' );
592:
593: dbms_aw.execute('CALL CALC_SCE_COST_WSCORES_PRG(' ||

Line 593: dbms_aw.execute('CALL CALC_SCE_COST_WSCORES_PRG(' ||

589: dbms_aw.execute('CALL CALC_SCEN_SCORECARD_PRG(' ||
590: l_planning_cycle_id || ',' ||
591: p_scenario_id || ',NA)' );
592:
593: dbms_aw.execute('CALL CALC_SCE_COST_WSCORES_PRG(' ||
594: p_scenario_id || ')' );
595:
596: dbms_aw.execute('CALL CALC_SCE_CLASS_COST_WSCORES_PRG(' ||
597: p_scenario_id || ', NA, NA)' );

Line 596: dbms_aw.execute('CALL CALC_SCE_CLASS_COST_WSCORES_PRG(' ||

592:
593: dbms_aw.execute('CALL CALC_SCE_COST_WSCORES_PRG(' ||
594: p_scenario_id || ')' );
595:
596: dbms_aw.execute('CALL CALC_SCE_CLASS_COST_WSCORES_PRG(' ||
597: p_scenario_id || ', NA, NA)' );
598:
599: END Calc_Scenario_Wscores;
600:

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

717: 'Setting appropriate dimension limits.'
718: );
719: END IF;
720:
721: dbms_aw.execute('limit scenario_d to ' || p_scenario_id);
722: dbms_aw.execute('limit project_d to scenario_project_m');
723: dbms_aw.execute('limit planning_cycle_d to scenario_d');
724: dbms_aw.execute('limit strategic_obj_d to pc_obj_m');
725:

Line 722: dbms_aw.execute('limit project_d to scenario_project_m');

718: );
719: END IF;
720:
721: dbms_aw.execute('limit scenario_d to ' || p_scenario_id);
722: dbms_aw.execute('limit project_d to scenario_project_m');
723: dbms_aw.execute('limit planning_cycle_d to scenario_d');
724: dbms_aw.execute('limit strategic_obj_d to pc_obj_m');
725:
726: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

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

719: END IF;
720:
721: dbms_aw.execute('limit scenario_d to ' || p_scenario_id);
722: dbms_aw.execute('limit project_d to scenario_project_m');
723: dbms_aw.execute('limit planning_cycle_d to scenario_d');
724: dbms_aw.execute('limit strategic_obj_d to pc_obj_m');
725:
726: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
727: FND_LOG.String

Line 724: dbms_aw.execute('limit strategic_obj_d to pc_obj_m');

720:
721: dbms_aw.execute('limit scenario_d to ' || p_scenario_id);
722: dbms_aw.execute('limit project_d to scenario_project_m');
723: dbms_aw.execute('limit planning_cycle_d to scenario_d');
724: dbms_aw.execute('limit strategic_obj_d to pc_obj_m');
725:
726: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
727: FND_LOG.String
728: ( FND_LOG.LEVEL_PROCEDURE,

Line 734: dbms_aw.execute('project_approved_obj_score_m = scenario_project_obj_score_m');

730: 'Updating Approved Scores.'
731: );
732: END IF;
733:
734: dbms_aw.execute('project_approved_obj_score_m = scenario_project_obj_score_m');
735:
736: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
737: FND_LOG.String
738: ( FND_LOG.LEVEL_PROCEDURE,