161:
162: BEGIN
163:
164:
165: if not icx_sec.validateSession THEN
166: return;
167: end if;
168:
169: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
165: if not icx_sec.validateSession THEN
166: return;
167: end if;
168:
169: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
170:
171: L_BUSINESS_PLAN_ID := icx_sec.getSessionAttributeValue( 'BUSINESS PLAN', l_session_id );
172: L_ORGANIZATION_ID := icx_sec.getSessionAttributeValue( 'ORGANIZATION_ID', l_session_id );
173: L_PLAN1 := icx_sec.getSessionAttributeValue( 'PLAN1', l_session_id );
167: end if;
168:
169: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
170:
171: L_BUSINESS_PLAN_ID := icx_sec.getSessionAttributeValue( 'BUSINESS PLAN', l_session_id );
172: L_ORGANIZATION_ID := icx_sec.getSessionAttributeValue( 'ORGANIZATION_ID', l_session_id );
173: L_PLAN1 := icx_sec.getSessionAttributeValue( 'PLAN1', l_session_id );
174: L_PLAN2 := icx_sec.getSessionAttributeValue( 'PLAN2', l_session_id );
175: L_PERIOD_TYPE := icx_sec.getSessionAttributeValue( 'PERIOD TYPE', l_session_id );
168:
169: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
170:
171: L_BUSINESS_PLAN_ID := icx_sec.getSessionAttributeValue( 'BUSINESS PLAN', l_session_id );
172: L_ORGANIZATION_ID := icx_sec.getSessionAttributeValue( 'ORGANIZATION_ID', l_session_id );
173: L_PLAN1 := icx_sec.getSessionAttributeValue( 'PLAN1', l_session_id );
174: L_PLAN2 := icx_sec.getSessionAttributeValue( 'PLAN2', l_session_id );
175: L_PERIOD_TYPE := icx_sec.getSessionAttributeValue( 'PERIOD TYPE', l_session_id );
176:
169: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
170:
171: L_BUSINESS_PLAN_ID := icx_sec.getSessionAttributeValue( 'BUSINESS PLAN', l_session_id );
172: L_ORGANIZATION_ID := icx_sec.getSessionAttributeValue( 'ORGANIZATION_ID', l_session_id );
173: L_PLAN1 := icx_sec.getSessionAttributeValue( 'PLAN1', l_session_id );
174: L_PLAN2 := icx_sec.getSessionAttributeValue( 'PLAN2', l_session_id );
175: L_PERIOD_TYPE := icx_sec.getSessionAttributeValue( 'PERIOD TYPE', l_session_id );
176:
177:
170:
171: L_BUSINESS_PLAN_ID := icx_sec.getSessionAttributeValue( 'BUSINESS PLAN', l_session_id );
172: L_ORGANIZATION_ID := icx_sec.getSessionAttributeValue( 'ORGANIZATION_ID', l_session_id );
173: L_PLAN1 := icx_sec.getSessionAttributeValue( 'PLAN1', l_session_id );
174: L_PLAN2 := icx_sec.getSessionAttributeValue( 'PLAN2', l_session_id );
175: L_PERIOD_TYPE := icx_sec.getSessionAttributeValue( 'PERIOD TYPE', l_session_id );
176:
177:
178: /* launch the report if we have the necessary parameters */
171: L_BUSINESS_PLAN_ID := icx_sec.getSessionAttributeValue( 'BUSINESS PLAN', l_session_id );
172: L_ORGANIZATION_ID := icx_sec.getSessionAttributeValue( 'ORGANIZATION_ID', l_session_id );
173: L_PLAN1 := icx_sec.getSessionAttributeValue( 'PLAN1', l_session_id );
174: L_PLAN2 := icx_sec.getSessionAttributeValue( 'PLAN2', l_session_id );
175: L_PERIOD_TYPE := icx_sec.getSessionAttributeValue( 'PERIOD TYPE', l_session_id );
176:
177:
178: /* launch the report if we have the necessary parameters */
179:
404: l_launch_success boolean;
405:
406: BEGIN
407:
408: if not icx_sec.validateSession THEN
409: return;
410: end if;
411:
412: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
408: if not icx_sec.validateSession THEN
409: return;
410: end if;
411:
412: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
413: /*
414: IF( Validate_Org
415: ( P_ORGANIZATION_ID, P_ORGANIZATION_NAME,
416: L_ORGANIZATION_ID ) = FALSE OR
426: L_ORGANIZATION_ID := p_organization_id;
427: L_PLAN1 := p_plan1;
428: L_PLAN2 := p_plan2;
429:
430: icx_sec.putSessionAttributeValue( 'BUSINESS PLAN', L_BUSINESS_PLAN_ID , l_session_id );
431: icx_sec.putSessionAttributeValue( 'ORGANIZATION', L_ORGANIZATION_ID , l_session_id );
432: icx_sec.putSessionAttributeValue( 'PLAN1', L_PLAN1 , l_session_id );
433: icx_sec.putSessionAttributeValue( 'PLAN2', L_PLAN2 , l_session_id );
434: icx_sec.putSessionAttributeValue( 'PERIOD TYPE', L_PERIOD_TYPE , l_session_id );
427: L_PLAN1 := p_plan1;
428: L_PLAN2 := p_plan2;
429:
430: icx_sec.putSessionAttributeValue( 'BUSINESS PLAN', L_BUSINESS_PLAN_ID , l_session_id );
431: icx_sec.putSessionAttributeValue( 'ORGANIZATION', L_ORGANIZATION_ID , l_session_id );
432: icx_sec.putSessionAttributeValue( 'PLAN1', L_PLAN1 , l_session_id );
433: icx_sec.putSessionAttributeValue( 'PLAN2', L_PLAN2 , l_session_id );
434: icx_sec.putSessionAttributeValue( 'PERIOD TYPE', L_PERIOD_TYPE , l_session_id );
435:
428: L_PLAN2 := p_plan2;
429:
430: icx_sec.putSessionAttributeValue( 'BUSINESS PLAN', L_BUSINESS_PLAN_ID , l_session_id );
431: icx_sec.putSessionAttributeValue( 'ORGANIZATION', L_ORGANIZATION_ID , l_session_id );
432: icx_sec.putSessionAttributeValue( 'PLAN1', L_PLAN1 , l_session_id );
433: icx_sec.putSessionAttributeValue( 'PLAN2', L_PLAN2 , l_session_id );
434: icx_sec.putSessionAttributeValue( 'PERIOD TYPE', L_PERIOD_TYPE , l_session_id );
435:
436:
429:
430: icx_sec.putSessionAttributeValue( 'BUSINESS PLAN', L_BUSINESS_PLAN_ID , l_session_id );
431: icx_sec.putSessionAttributeValue( 'ORGANIZATION', L_ORGANIZATION_ID , l_session_id );
432: icx_sec.putSessionAttributeValue( 'PLAN1', L_PLAN1 , l_session_id );
433: icx_sec.putSessionAttributeValue( 'PLAN2', L_PLAN2 , l_session_id );
434: icx_sec.putSessionAttributeValue( 'PERIOD TYPE', L_PERIOD_TYPE , l_session_id );
435:
436:
437: l_launch_success := LaunchReport
430: icx_sec.putSessionAttributeValue( 'BUSINESS PLAN', L_BUSINESS_PLAN_ID , l_session_id );
431: icx_sec.putSessionAttributeValue( 'ORGANIZATION', L_ORGANIZATION_ID , l_session_id );
432: icx_sec.putSessionAttributeValue( 'PLAN1', L_PLAN1 , l_session_id );
433: icx_sec.putSessionAttributeValue( 'PLAN2', L_PLAN2 , l_session_id );
434: icx_sec.putSessionAttributeValue( 'PERIOD TYPE', L_PERIOD_TYPE , l_session_id );
435:
436:
437: l_launch_success := LaunchReport
438: (