741: l_invalid_value EXCEPTION;
742: l_exist VARCHAR2(1) := 'N';
743: l_period_type pa_rep_period_types_v.period_type_desc%type;
744: l_period_name pa_rep_periods_v.period_name%TYPE;
745: l_org_id pa_rep_util_res_orgs_v.organization_id%TYPE;
746: l_mgr_id pa_rep_util_mgr_org_v.manager_id%TYPE;
747: l_orgz_id pa_rep_util_res_orgs_v.organization_id%TYPE;
748: l_mgnr_id pa_rep_util_res_orgs_v.organization_id%TYPE;
749: l_prd_quarter pa_rep_periods_v.mon_or_qtr%type;
743: l_period_type pa_rep_period_types_v.period_type_desc%type;
744: l_period_name pa_rep_periods_v.period_name%TYPE;
745: l_org_id pa_rep_util_res_orgs_v.organization_id%TYPE;
746: l_mgr_id pa_rep_util_mgr_org_v.manager_id%TYPE;
747: l_orgz_id pa_rep_util_res_orgs_v.organization_id%TYPE;
748: l_mgnr_id pa_rep_util_res_orgs_v.organization_id%TYPE;
749: l_prd_quarter pa_rep_periods_v.mon_or_qtr%type;
750: l_glb_wek_dt pa_rep_periods_v.ge_week_dt%type;
751: l_period_year pa_rep_periods_v.period_year%TYPE;
744: l_period_name pa_rep_periods_v.period_name%TYPE;
745: l_org_id pa_rep_util_res_orgs_v.organization_id%TYPE;
746: l_mgr_id pa_rep_util_mgr_org_v.manager_id%TYPE;
747: l_orgz_id pa_rep_util_res_orgs_v.organization_id%TYPE;
748: l_mgnr_id pa_rep_util_res_orgs_v.organization_id%TYPE;
749: l_prd_quarter pa_rep_periods_v.mon_or_qtr%type;
750: l_glb_wek_dt pa_rep_periods_v.ge_week_dt%type;
751: l_period_year pa_rep_periods_v.period_year%TYPE;
752: l_msg_index_out INTEGER:=1;
767: /* BEGIN
768: IF (p_calling_mode = 'RESMGR') THEN
769: SELECT organization_id
770: INTO l_org_id
771: FROM pa_rep_util_res_orgs_v
772: WHERE organization_name = p_org_name;
773: l_orgz_id := l_org_id;
774: l_mgnr_id := p_mgr_id;
775: ELSIF (p_calling_mode = 'ORGMGR') THEN