351:
352: BEGIN
353:
354:
355: if not icx_sec.validateSession THEN
356: return;
357: end if;
358:
359: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
355: if not icx_sec.validateSession THEN
356: return;
357: end if;
358:
359: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
360:
361: L_BUSINESS_PLAN_ID := icx_sec.getSessionAttributeValue( 'BUSINESS PLAN', l_session_id );
362: L_ORGANIZATION_ID := icx_sec.getSessionAttributeValue( 'ORGANIZATION_ID', l_session_id );
363: L_PLAN1 := icx_sec.getSessionAttributeValue( 'PLAN1', l_session_id );
357: end if;
358:
359: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
360:
361: L_BUSINESS_PLAN_ID := icx_sec.getSessionAttributeValue( 'BUSINESS PLAN', l_session_id );
362: L_ORGANIZATION_ID := icx_sec.getSessionAttributeValue( 'ORGANIZATION_ID', l_session_id );
363: L_PLAN1 := icx_sec.getSessionAttributeValue( 'PLAN1', l_session_id );
364: L_PLAN2 := icx_sec.getSessionAttributeValue( 'PLAN2', l_session_id );
365: L_PERIOD_TYPE := icx_sec.getSessionAttributeValue( 'PERIOD TYPE', l_session_id );
358:
359: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
360:
361: L_BUSINESS_PLAN_ID := icx_sec.getSessionAttributeValue( 'BUSINESS PLAN', l_session_id );
362: L_ORGANIZATION_ID := icx_sec.getSessionAttributeValue( 'ORGANIZATION_ID', l_session_id );
363: L_PLAN1 := icx_sec.getSessionAttributeValue( 'PLAN1', l_session_id );
364: L_PLAN2 := icx_sec.getSessionAttributeValue( 'PLAN2', l_session_id );
365: L_PERIOD_TYPE := icx_sec.getSessionAttributeValue( 'PERIOD TYPE', l_session_id );
366:
359: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
360:
361: L_BUSINESS_PLAN_ID := icx_sec.getSessionAttributeValue( 'BUSINESS PLAN', l_session_id );
362: L_ORGANIZATION_ID := icx_sec.getSessionAttributeValue( 'ORGANIZATION_ID', l_session_id );
363: L_PLAN1 := icx_sec.getSessionAttributeValue( 'PLAN1', l_session_id );
364: L_PLAN2 := icx_sec.getSessionAttributeValue( 'PLAN2', l_session_id );
365: L_PERIOD_TYPE := icx_sec.getSessionAttributeValue( 'PERIOD TYPE', l_session_id );
366:
367:
360:
361: L_BUSINESS_PLAN_ID := icx_sec.getSessionAttributeValue( 'BUSINESS PLAN', l_session_id );
362: L_ORGANIZATION_ID := icx_sec.getSessionAttributeValue( 'ORGANIZATION_ID', l_session_id );
363: L_PLAN1 := icx_sec.getSessionAttributeValue( 'PLAN1', l_session_id );
364: L_PLAN2 := icx_sec.getSessionAttributeValue( 'PLAN2', l_session_id );
365: L_PERIOD_TYPE := icx_sec.getSessionAttributeValue( 'PERIOD TYPE', l_session_id );
366:
367:
368: /* launch the report if we have the necessary parameters */
361: L_BUSINESS_PLAN_ID := icx_sec.getSessionAttributeValue( 'BUSINESS PLAN', l_session_id );
362: L_ORGANIZATION_ID := icx_sec.getSessionAttributeValue( 'ORGANIZATION_ID', l_session_id );
363: L_PLAN1 := icx_sec.getSessionAttributeValue( 'PLAN1', l_session_id );
364: L_PLAN2 := icx_sec.getSessionAttributeValue( 'PLAN2', l_session_id );
365: L_PERIOD_TYPE := icx_sec.getSessionAttributeValue( 'PERIOD TYPE', l_session_id );
366:
367:
368: /* launch the report if we have the necessary parameters */
369:
491: l_launch_success boolean;
492:
493: BEGIN
494:
495: if not icx_sec.validateSession THEN
496: return;
497: end if;
498:
499: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
495: if not icx_sec.validateSession THEN
496: return;
497: end if;
498:
499: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
500:
501: L_BUSINESS_PLAN_ID := p_business_plan;
502: L_PERIOD_TYPE := p_period_type;
503: L_ORGANIZATION_ID := p_organization_id;
503: L_ORGANIZATION_ID := p_organization_id;
504: L_PLAN1 := p_plan1;
505: L_PLAN2 := p_plan2;
506:
507: icx_sec.putSessionAttributeValue( 'BUSINESS PLAN', L_BUSINESS_PLAN_ID , l_session_id );
508: icx_sec.putSessionAttributeValue( 'ORGANIZATION', L_ORGANIZATION_ID , l_session_id );
509: icx_sec.putSessionAttributeValue( 'PLAN1', L_PLAN1 , l_session_id );
510: icx_sec.putSessionAttributeValue( 'PLAN2', L_PLAN2 , l_session_id );
511: icx_sec.putSessionAttributeValue( 'PERIOD TYPE', L_PERIOD_TYPE , l_session_id );
504: L_PLAN1 := p_plan1;
505: L_PLAN2 := p_plan2;
506:
507: icx_sec.putSessionAttributeValue( 'BUSINESS PLAN', L_BUSINESS_PLAN_ID , l_session_id );
508: icx_sec.putSessionAttributeValue( 'ORGANIZATION', L_ORGANIZATION_ID , l_session_id );
509: icx_sec.putSessionAttributeValue( 'PLAN1', L_PLAN1 , l_session_id );
510: icx_sec.putSessionAttributeValue( 'PLAN2', L_PLAN2 , l_session_id );
511: icx_sec.putSessionAttributeValue( 'PERIOD TYPE', L_PERIOD_TYPE , l_session_id );
512:
505: L_PLAN2 := p_plan2;
506:
507: icx_sec.putSessionAttributeValue( 'BUSINESS PLAN', L_BUSINESS_PLAN_ID , l_session_id );
508: icx_sec.putSessionAttributeValue( 'ORGANIZATION', L_ORGANIZATION_ID , l_session_id );
509: icx_sec.putSessionAttributeValue( 'PLAN1', L_PLAN1 , l_session_id );
510: icx_sec.putSessionAttributeValue( 'PLAN2', L_PLAN2 , l_session_id );
511: icx_sec.putSessionAttributeValue( 'PERIOD TYPE', L_PERIOD_TYPE , l_session_id );
512:
513:
506:
507: icx_sec.putSessionAttributeValue( 'BUSINESS PLAN', L_BUSINESS_PLAN_ID , l_session_id );
508: icx_sec.putSessionAttributeValue( 'ORGANIZATION', L_ORGANIZATION_ID , l_session_id );
509: icx_sec.putSessionAttributeValue( 'PLAN1', L_PLAN1 , l_session_id );
510: icx_sec.putSessionAttributeValue( 'PLAN2', L_PLAN2 , l_session_id );
511: icx_sec.putSessionAttributeValue( 'PERIOD TYPE', L_PERIOD_TYPE , l_session_id );
512:
513:
514: l_launch_success := LaunchReport
507: icx_sec.putSessionAttributeValue( 'BUSINESS PLAN', L_BUSINESS_PLAN_ID , l_session_id );
508: icx_sec.putSessionAttributeValue( 'ORGANIZATION', L_ORGANIZATION_ID , l_session_id );
509: icx_sec.putSessionAttributeValue( 'PLAN1', L_PLAN1 , l_session_id );
510: icx_sec.putSessionAttributeValue( 'PLAN2', L_PLAN2 , l_session_id );
511: icx_sec.putSessionAttributeValue( 'PERIOD TYPE', L_PERIOD_TYPE , l_session_id );
512:
513:
514: l_launch_success := LaunchReport
515: (