340:
341: BEGIN
342:
343:
344: if not icx_sec.validateSession THEN
345: return;
346: end if;
347:
348: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
344: if not icx_sec.validateSession THEN
345: return;
346: end if;
347:
348: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
349:
350: L_BUSINESS_PLAN_ID := icx_sec.getSessionAttributeValue( 'BUSINESS PLAN', l_session_id );
351: L_ORGANIZATION_ID := icx_sec.getSessionAttributeValue( 'ORGANIZATION_ID', l_session_id );
352: L_PLAN1 := icx_sec.getSessionAttributeValue( 'PLAN1', l_session_id );
346: end if;
347:
348: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
349:
350: L_BUSINESS_PLAN_ID := icx_sec.getSessionAttributeValue( 'BUSINESS PLAN', l_session_id );
351: L_ORGANIZATION_ID := icx_sec.getSessionAttributeValue( 'ORGANIZATION_ID', l_session_id );
352: L_PLAN1 := icx_sec.getSessionAttributeValue( 'PLAN1', l_session_id );
353: L_PLAN2 := icx_sec.getSessionAttributeValue( 'PLAN2', l_session_id );
354: L_PERIOD_TYPE := icx_sec.getSessionAttributeValue( 'PERIOD TYPE', l_session_id );
347:
348: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
349:
350: L_BUSINESS_PLAN_ID := icx_sec.getSessionAttributeValue( 'BUSINESS PLAN', l_session_id );
351: L_ORGANIZATION_ID := icx_sec.getSessionAttributeValue( 'ORGANIZATION_ID', l_session_id );
352: L_PLAN1 := icx_sec.getSessionAttributeValue( 'PLAN1', l_session_id );
353: L_PLAN2 := icx_sec.getSessionAttributeValue( 'PLAN2', l_session_id );
354: L_PERIOD_TYPE := icx_sec.getSessionAttributeValue( 'PERIOD TYPE', l_session_id );
355:
348: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
349:
350: L_BUSINESS_PLAN_ID := icx_sec.getSessionAttributeValue( 'BUSINESS PLAN', l_session_id );
351: L_ORGANIZATION_ID := icx_sec.getSessionAttributeValue( 'ORGANIZATION_ID', l_session_id );
352: L_PLAN1 := icx_sec.getSessionAttributeValue( 'PLAN1', l_session_id );
353: L_PLAN2 := icx_sec.getSessionAttributeValue( 'PLAN2', l_session_id );
354: L_PERIOD_TYPE := icx_sec.getSessionAttributeValue( 'PERIOD TYPE', l_session_id );
355:
356:
349:
350: L_BUSINESS_PLAN_ID := icx_sec.getSessionAttributeValue( 'BUSINESS PLAN', l_session_id );
351: L_ORGANIZATION_ID := icx_sec.getSessionAttributeValue( 'ORGANIZATION_ID', l_session_id );
352: L_PLAN1 := icx_sec.getSessionAttributeValue( 'PLAN1', l_session_id );
353: L_PLAN2 := icx_sec.getSessionAttributeValue( 'PLAN2', l_session_id );
354: L_PERIOD_TYPE := icx_sec.getSessionAttributeValue( 'PERIOD TYPE', l_session_id );
355:
356:
357: /* launch the report if we have the necessary parameters */
350: L_BUSINESS_PLAN_ID := icx_sec.getSessionAttributeValue( 'BUSINESS PLAN', l_session_id );
351: L_ORGANIZATION_ID := icx_sec.getSessionAttributeValue( 'ORGANIZATION_ID', l_session_id );
352: L_PLAN1 := icx_sec.getSessionAttributeValue( 'PLAN1', l_session_id );
353: L_PLAN2 := icx_sec.getSessionAttributeValue( 'PLAN2', l_session_id );
354: L_PERIOD_TYPE := icx_sec.getSessionAttributeValue( 'PERIOD TYPE', l_session_id );
355:
356:
357: /* launch the report if we have the necessary parameters */
358:
479: l_launch_success boolean;
480:
481: BEGIN
482:
483: if not icx_sec.validateSession THEN
484: return;
485: end if;
486:
487: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
483: if not icx_sec.validateSession THEN
484: return;
485: end if;
486:
487: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
488:
489: L_BUSINESS_PLAN_ID := p_business_plan;
490: L_PERIOD_TYPE := p_period_type;
491: L_ORGANIZATION_ID := p_organization_id;
491: L_ORGANIZATION_ID := p_organization_id;
492: L_PLAN1 := p_plan1;
493: L_PLAN2 := p_plan2;
494:
495: icx_sec.putSessionAttributeValue( 'BUSINESS PLAN', L_BUSINESS_PLAN_ID , l_session_id );
496: icx_sec.putSessionAttributeValue( 'ORGANIZATION', L_ORGANIZATION_ID , l_session_id );
497: icx_sec.putSessionAttributeValue( 'PLAN1', L_PLAN1 , l_session_id );
498: icx_sec.putSessionAttributeValue( 'PLAN2', L_PLAN2 , l_session_id );
499: icx_sec.putSessionAttributeValue( 'PERIOD TYPE', L_PERIOD_TYPE , l_session_id );
492: L_PLAN1 := p_plan1;
493: L_PLAN2 := p_plan2;
494:
495: icx_sec.putSessionAttributeValue( 'BUSINESS PLAN', L_BUSINESS_PLAN_ID , l_session_id );
496: icx_sec.putSessionAttributeValue( 'ORGANIZATION', L_ORGANIZATION_ID , l_session_id );
497: icx_sec.putSessionAttributeValue( 'PLAN1', L_PLAN1 , l_session_id );
498: icx_sec.putSessionAttributeValue( 'PLAN2', L_PLAN2 , l_session_id );
499: icx_sec.putSessionAttributeValue( 'PERIOD TYPE', L_PERIOD_TYPE , l_session_id );
500:
493: L_PLAN2 := p_plan2;
494:
495: icx_sec.putSessionAttributeValue( 'BUSINESS PLAN', L_BUSINESS_PLAN_ID , l_session_id );
496: icx_sec.putSessionAttributeValue( 'ORGANIZATION', L_ORGANIZATION_ID , l_session_id );
497: icx_sec.putSessionAttributeValue( 'PLAN1', L_PLAN1 , l_session_id );
498: icx_sec.putSessionAttributeValue( 'PLAN2', L_PLAN2 , l_session_id );
499: icx_sec.putSessionAttributeValue( 'PERIOD TYPE', L_PERIOD_TYPE , l_session_id );
500:
501:
494:
495: icx_sec.putSessionAttributeValue( 'BUSINESS PLAN', L_BUSINESS_PLAN_ID , l_session_id );
496: icx_sec.putSessionAttributeValue( 'ORGANIZATION', L_ORGANIZATION_ID , l_session_id );
497: icx_sec.putSessionAttributeValue( 'PLAN1', L_PLAN1 , l_session_id );
498: icx_sec.putSessionAttributeValue( 'PLAN2', L_PLAN2 , l_session_id );
499: icx_sec.putSessionAttributeValue( 'PERIOD TYPE', L_PERIOD_TYPE , l_session_id );
500:
501:
502: l_launch_success := LaunchReport
495: icx_sec.putSessionAttributeValue( 'BUSINESS PLAN', L_BUSINESS_PLAN_ID , l_session_id );
496: icx_sec.putSessionAttributeValue( 'ORGANIZATION', L_ORGANIZATION_ID , l_session_id );
497: icx_sec.putSessionAttributeValue( 'PLAN1', L_PLAN1 , l_session_id );
498: icx_sec.putSessionAttributeValue( 'PLAN2', L_PLAN2 , l_session_id );
499: icx_sec.putSessionAttributeValue( 'PERIOD TYPE', L_PERIOD_TYPE , l_session_id );
500:
501:
502: l_launch_success := LaunchReport
503: (