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

Line 537: dbms_aw.execute('MAINTAIN project_d ADD '|| p_project_id );

533: PROCEDURE save_project
534: IS
535: BEGIN
536: BEGIN
537: dbms_aw.execute('MAINTAIN project_d ADD '|| p_project_id );
538: EXCEPTION
539: WHEN OTHERS THEN
540: NULL;
541: END;

Line 542: dbms_aw.execute('oknullstatus = yes');

538: EXCEPTION
539: WHEN OTHERS THEN
540: NULL;
541: END;
542: dbms_aw.execute('oknullstatus = yes');
543: dbms_aw.execute('push portfolio_d');
544: dbms_aw.execute('push planning_cycle_d');
545: dbms_aw.execute('push project_d');
546:

Line 543: dbms_aw.execute('push portfolio_d');

539: WHEN OTHERS THEN
540: NULL;
541: END;
542: dbms_aw.execute('oknullstatus = yes');
543: dbms_aw.execute('push portfolio_d');
544: dbms_aw.execute('push planning_cycle_d');
545: dbms_aw.execute('push project_d');
546:
547: dbms_aw.execute('LIMIT project_d TO '|| p_project_id );

Line 544: dbms_aw.execute('push planning_cycle_d');

540: NULL;
541: END;
542: dbms_aw.execute('oknullstatus = yes');
543: dbms_aw.execute('push portfolio_d');
544: dbms_aw.execute('push planning_cycle_d');
545: dbms_aw.execute('push project_d');
546:
547: dbms_aw.execute('LIMIT project_d TO '|| p_project_id );
548: dbms_aw.execute('class_code_project_r = '||l_class_code_id);

Line 545: dbms_aw.execute('push project_d');

541: END;
542: dbms_aw.execute('oknullstatus = yes');
543: dbms_aw.execute('push portfolio_d');
544: dbms_aw.execute('push planning_cycle_d');
545: dbms_aw.execute('push project_d');
546:
547: dbms_aw.execute('LIMIT project_d TO '|| p_project_id );
548: dbms_aw.execute('class_code_project_r = '||l_class_code_id);
549: dbms_aw.execute('portfolio_project_r = '||l_portfolio_id);

Line 547: dbms_aw.execute('LIMIT project_d TO '|| p_project_id );

543: dbms_aw.execute('push portfolio_d');
544: dbms_aw.execute('push planning_cycle_d');
545: dbms_aw.execute('push project_d');
546:
547: dbms_aw.execute('LIMIT project_d TO '|| p_project_id );
548: dbms_aw.execute('class_code_project_r = '||l_class_code_id);
549: dbms_aw.execute('portfolio_project_r = '||l_portfolio_id);
550: dbms_aw.execute('LIMIT planning_cycle_d TO '|| l_current_pc_id );
551: dbms_aw.execute('pc_project_r = planning_cycle_d');

Line 548: dbms_aw.execute('class_code_project_r = '||l_class_code_id);

544: dbms_aw.execute('push planning_cycle_d');
545: dbms_aw.execute('push project_d');
546:
547: dbms_aw.execute('LIMIT project_d TO '|| p_project_id );
548: dbms_aw.execute('class_code_project_r = '||l_class_code_id);
549: dbms_aw.execute('portfolio_project_r = '||l_portfolio_id);
550: dbms_aw.execute('LIMIT planning_cycle_d TO '|| l_current_pc_id );
551: dbms_aw.execute('pc_project_r = planning_cycle_d');
552:

Line 549: dbms_aw.execute('portfolio_project_r = '||l_portfolio_id);

545: dbms_aw.execute('push project_d');
546:
547: dbms_aw.execute('LIMIT project_d TO '|| p_project_id );
548: dbms_aw.execute('class_code_project_r = '||l_class_code_id);
549: dbms_aw.execute('portfolio_project_r = '||l_portfolio_id);
550: dbms_aw.execute('LIMIT planning_cycle_d TO '|| l_current_pc_id );
551: dbms_aw.execute('pc_project_r = planning_cycle_d');
552:
553: dbms_aw.execute('pop portfolio_d');

Line 550: dbms_aw.execute('LIMIT planning_cycle_d TO '|| l_current_pc_id );

546:
547: dbms_aw.execute('LIMIT project_d TO '|| p_project_id );
548: dbms_aw.execute('class_code_project_r = '||l_class_code_id);
549: dbms_aw.execute('portfolio_project_r = '||l_portfolio_id);
550: dbms_aw.execute('LIMIT planning_cycle_d TO '|| l_current_pc_id );
551: dbms_aw.execute('pc_project_r = planning_cycle_d');
552:
553: dbms_aw.execute('pop portfolio_d');
554: dbms_aw.execute('pop planning_cycle_d');

Line 551: dbms_aw.execute('pc_project_r = planning_cycle_d');

547: dbms_aw.execute('LIMIT project_d TO '|| p_project_id );
548: dbms_aw.execute('class_code_project_r = '||l_class_code_id);
549: dbms_aw.execute('portfolio_project_r = '||l_portfolio_id);
550: dbms_aw.execute('LIMIT planning_cycle_d TO '|| l_current_pc_id );
551: dbms_aw.execute('pc_project_r = planning_cycle_d');
552:
553: dbms_aw.execute('pop portfolio_d');
554: dbms_aw.execute('pop planning_cycle_d');
555: dbms_aw.execute('pop project_d');

Line 553: dbms_aw.execute('pop portfolio_d');

549: dbms_aw.execute('portfolio_project_r = '||l_portfolio_id);
550: dbms_aw.execute('LIMIT planning_cycle_d TO '|| l_current_pc_id );
551: dbms_aw.execute('pc_project_r = planning_cycle_d');
552:
553: dbms_aw.execute('pop portfolio_d');
554: dbms_aw.execute('pop planning_cycle_d');
555: dbms_aw.execute('pop project_d');
556:
557: dbms_aw.execute('UPDATE');

Line 554: dbms_aw.execute('pop planning_cycle_d');

550: dbms_aw.execute('LIMIT planning_cycle_d TO '|| l_current_pc_id );
551: dbms_aw.execute('pc_project_r = planning_cycle_d');
552:
553: dbms_aw.execute('pop portfolio_d');
554: dbms_aw.execute('pop planning_cycle_d');
555: dbms_aw.execute('pop project_d');
556:
557: dbms_aw.execute('UPDATE');
558:

Line 555: dbms_aw.execute('pop project_d');

551: dbms_aw.execute('pc_project_r = planning_cycle_d');
552:
553: dbms_aw.execute('pop portfolio_d');
554: dbms_aw.execute('pop planning_cycle_d');
555: dbms_aw.execute('pop project_d');
556:
557: dbms_aw.execute('UPDATE');
558:
559: EXCEPTION

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

553: dbms_aw.execute('pop portfolio_d');
554: dbms_aw.execute('pop planning_cycle_d');
555: dbms_aw.execute('pop project_d');
556:
557: dbms_aw.execute('UPDATE');
558:
559: EXCEPTION
560: WHEN OTHERS then
561: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 719: dbms_aw.execute('CALL LOAD_BUDGET_FORECAST_PRG('

715: l_projects := ''''||l_projects||'''';
716: end if;
717:
718: if(p_type <> 'REFRESH') then
719: dbms_aw.execute('CALL LOAD_BUDGET_FORECAST_PRG('
720: ||p_scenario_id||','||l_projects||',''LOAD'''||')');
721: end if;
722:
723: dbms_aw.execute('CALL LOAD_BUDGET_FORECAST_PRG('

Line 723: dbms_aw.execute('CALL LOAD_BUDGET_FORECAST_PRG('

719: dbms_aw.execute('CALL LOAD_BUDGET_FORECAST_PRG('
720: ||p_scenario_id||','||l_projects||',''LOAD'''||')');
721: end if;
722:
723: dbms_aw.execute('CALL LOAD_BUDGET_FORECAST_PRG('
724: ||p_scenario_id||','||l_projects||',''COST'''||')');
725:
726: dbms_aw.execute('CALL LOAD_BUDGET_FORECAST_PRG('
727: ||p_scenario_id||','||l_projects||',''BENEFIT'''||')');

Line 726: dbms_aw.execute('CALL LOAD_BUDGET_FORECAST_PRG('

722:
723: dbms_aw.execute('CALL LOAD_BUDGET_FORECAST_PRG('
724: ||p_scenario_id||','||l_projects||',''COST'''||')');
725:
726: dbms_aw.execute('CALL LOAD_BUDGET_FORECAST_PRG('
727: ||p_scenario_id||','||l_projects||',''BENEFIT'''||')');
728:
729: dbms_aw.execute('CALL LOAD_BUDGET_FORECAST_PRG('
730: ||p_scenario_id||','||l_projects||',''SUNK_COST'''||')');

Line 729: dbms_aw.execute('CALL LOAD_BUDGET_FORECAST_PRG('

725:
726: dbms_aw.execute('CALL LOAD_BUDGET_FORECAST_PRG('
727: ||p_scenario_id||','||l_projects||',''BENEFIT'''||')');
728:
729: dbms_aw.execute('CALL LOAD_BUDGET_FORECAST_PRG('
730: ||p_scenario_id||','||l_projects||',''SUNK_COST'''||')');
731:
732: if(p_type <> 'REFRESH') then
733: