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

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

2095: -- Raise the submit plan event
2096: wf_event.raise(p_event_name => 'oracle.apps.fpa.event.submit.submitplan',
2097: p_event_key => l_eventkey );
2098:
2099: dbms_aw.execute('UPDATE');
2100: COMMIT;
2101:
2102: -- Detach AW Workspace
2103: fpa_utilities_pvt.detach_AW(p_api_version => 1.0,

Line 2277: -- dbms_aw.execute('ALLSTAT');

2273: 'FPA_Main_Process_Pvt.approve_reject_plan.',
2274: 'Reject Plan: Approved Scenario Id '||l_sce_id
2275: );
2276: END IF;
2277: -- dbms_aw.execute('ALLSTAT');
2278: dbms_aw.execute('LMT scenario_d to '|| l_sce_id );
2279: -- get the PC
2280: dbms_aw.execute('LMT planning_cycle_d TO scenario_d' );
2281: -- get all scenarios that belong to the PC

Line 2278: dbms_aw.execute('LMT scenario_d to '|| l_sce_id );

2274: 'Reject Plan: Approved Scenario Id '||l_sce_id
2275: );
2276: END IF;
2277: -- dbms_aw.execute('ALLSTAT');
2278: dbms_aw.execute('LMT scenario_d to '|| l_sce_id );
2279: -- get the PC
2280: dbms_aw.execute('LMT planning_cycle_d TO scenario_d' );
2281: -- get all scenarios that belong to the PC
2282: dbms_aw.execute('LMT scenario_d to planning_cycle_d' );

Line 2280: dbms_aw.execute('LMT planning_cycle_d TO scenario_d' );

2276: END IF;
2277: -- dbms_aw.execute('ALLSTAT');
2278: dbms_aw.execute('LMT scenario_d to '|| l_sce_id );
2279: -- get the PC
2280: dbms_aw.execute('LMT planning_cycle_d TO scenario_d' );
2281: -- get all scenarios that belong to the PC
2282: dbms_aw.execute('LMT scenario_d to planning_cycle_d' );
2283: -- reset flags to na for all scenarios
2284: dbms_aw.execute('scenario_approved_flag_m = na');

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

2278: dbms_aw.execute('LMT scenario_d to '|| l_sce_id );
2279: -- get the PC
2280: dbms_aw.execute('LMT planning_cycle_d TO scenario_d' );
2281: -- get all scenarios that belong to the PC
2282: dbms_aw.execute('LMT scenario_d to planning_cycle_d' );
2283: -- reset flags to na for all scenarios
2284: dbms_aw.execute('scenario_approved_flag_m = na');
2285: dbms_aw.execute('scenario_recommended_flag_m = na');
2286:

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

2280: dbms_aw.execute('LMT planning_cycle_d TO scenario_d' );
2281: -- get all scenarios that belong to the PC
2282: dbms_aw.execute('LMT scenario_d to planning_cycle_d' );
2283: -- reset flags to na for all scenarios
2284: dbms_aw.execute('scenario_approved_flag_m = na');
2285: dbms_aw.execute('scenario_recommended_flag_m = na');
2286:
2287: end if;
2288:

Line 2285: dbms_aw.execute('scenario_recommended_flag_m = na');

2281: -- get all scenarios that belong to the PC
2282: dbms_aw.execute('LMT scenario_d to planning_cycle_d' );
2283: -- reset flags to na for all scenarios
2284: dbms_aw.execute('scenario_approved_flag_m = na');
2285: dbms_aw.execute('scenario_recommended_flag_m = na');
2286:
2287: end if;
2288:
2289:

Line 2290: -- dbms_aw.execute('ALLSTAT');

2286:
2287: end if;
2288:
2289:
2290: -- dbms_aw.execute('ALLSTAT');
2291:
2292: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2293: FND_LOG.String
2294: ( FND_LOG.LEVEL_PROCEDURE,

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

2306: wf_event.raise(p_event_name => 'oracle.apps.fpa.event.approve.approvepushdown',
2307: p_event_key => l_eventkey );
2308:
2309: -- Update AW
2310: dbms_aw.execute('UPDATE');
2311: COMMIT;
2312:
2313:
2314: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

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

2393: 'fpa.sql.fpa_main_process_pvt.copy_proj_from_prev_pc.begin',
2394: 'Setting Last Planning cycle ID to the planning_cycle_d');
2395: END IF;
2396:
2397: dbms_aw.execute('PUSH planning_cycle_d');
2398: dbms_aw.execute('LMT planning_cycle_d TO ' || l_last_pc_id );
2399:
2400: SELECT proj.project BULK COLLECT
2401: INTO l_project_id_tbl

Line 2398: dbms_aw.execute('LMT planning_cycle_d TO ' || l_last_pc_id );

2394: 'Setting Last Planning cycle ID to the planning_cycle_d');
2395: END IF;
2396:
2397: dbms_aw.execute('PUSH planning_cycle_d');
2398: dbms_aw.execute('LMT planning_cycle_d TO ' || l_last_pc_id );
2399:
2400: SELECT proj.project BULK COLLECT
2401: INTO l_project_id_tbl
2402: From fpa_aw_projs_v proj

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

2401: INTO l_project_id_tbl
2402: From fpa_aw_projs_v proj
2403: WHERE proj.planning_cycle = l_last_pc_id;
2404:
2405: dbms_aw.execute('POP planning_cycle_d');
2406:
2407: l_count :=0;
2408: l_count := l_project_id_tbl.COUNT;
2409:

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

2546:
2547: IF NVL(l_wf_aw_attached,'N') = 'Y' THEN
2548:
2549: -- Update AW
2550: dbms_aw.execute('UPDATE');
2551: COMMIT;
2552:
2553: Fpa_Utilities_Pvt.detach_AW
2554: (