[Home] [Help]
85: AND PRIOR ORG_STRUCTURE_VERSION_ID = P_PJP_ORG_VERSION_ID
86: START WITH ORGANIZATION_ID_PARENT = PTF.PORTFOLIO_ORGANIZATION
87: OR ORGANIZATION_ID_CHILD = PTF.PORTFOLIO_ORGANIZATION
88: UNION
89: SELECT PTF.PORTFOLIO_ORGANIZATION FROM dual --added for bug 6086945
90: ))); -- IN, OR , AND
91:
92:
93: -- current planning cycle for portfolio
306:
307: /** Verify_Budget_Versions is used to determine if projects under a given scenario have
308: the latest revenue and cost budget data .
309: This function is used in two different cases:
310: 1. To determine if an individual project under a scenario contains the latest data.
311: 2. To determine if a scenario (all projects under the scenario) contains the latest data.
312: **/
313:
314: FUNCTION Verify_Budget_Versions(
332: where scenario = p_scenario_id;
333:
334: cursor one_proj is
335: select p_project_id
336: from dual;
337:
338: BEGIN
339:
340: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
374: 'fpa.sql.fpa_project_pvt.Verify_Budget_Versions.begin',
375: 'Done fetching all projects from the scenario.');
376: end if;
377:
378: /** If p_project_id is not null then we are querying an individual project.
379: We plase the value of p_project_id in the TABLE type. **/
380: else
381:
382: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
470: ' Budget version id in PJT: ' || l_new_benefit_version_id);
471: END IF;
472:
473: /** If IDs are not identical then we return a FALSE flag, be it for
474: an individual project or for the entire scenario.
475: **/
476: if(l_cost_version_id <> l_new_cost_version_id or
477: l_benefit_version_id <> l_new_benefit_version_id) then
478: return FND_API.G_FALSE;