APPS.PA_REPORT_UTIL dependencies on PA_REP_UTIL_RES_ORGS_V

Line 778: l_org_id pa_rep_util_res_orgs_v.organization_id%TYPE;

774: l_invalid_value EXCEPTION;
775: l_exist VARCHAR2(1) := 'N';
776: l_period_type pa_rep_period_types_v.period_type_desc%type;
777: l_period_name pa_rep_periods_v.period_name%TYPE;
778: l_org_id pa_rep_util_res_orgs_v.organization_id%TYPE;
779: l_mgr_id pa_rep_util_mgr_org_v.manager_id%TYPE;
780: l_orgz_id pa_rep_util_res_orgs_v.organization_id%TYPE;
781: l_mgnr_id pa_rep_util_res_orgs_v.organization_id%TYPE;
782: l_prd_quarter pa_rep_periods_v.mon_or_qtr%type;

Line 780: l_orgz_id pa_rep_util_res_orgs_v.organization_id%TYPE;

776: l_period_type pa_rep_period_types_v.period_type_desc%type;
777: l_period_name pa_rep_periods_v.period_name%TYPE;
778: l_org_id pa_rep_util_res_orgs_v.organization_id%TYPE;
779: l_mgr_id pa_rep_util_mgr_org_v.manager_id%TYPE;
780: l_orgz_id pa_rep_util_res_orgs_v.organization_id%TYPE;
781: l_mgnr_id pa_rep_util_res_orgs_v.organization_id%TYPE;
782: l_prd_quarter pa_rep_periods_v.mon_or_qtr%type;
783: l_glb_wek_dt pa_rep_periods_v.ge_week_dt%type;
784: l_period_year pa_rep_periods_v.period_year%TYPE;

Line 781: l_mgnr_id pa_rep_util_res_orgs_v.organization_id%TYPE;

777: l_period_name pa_rep_periods_v.period_name%TYPE;
778: l_org_id pa_rep_util_res_orgs_v.organization_id%TYPE;
779: l_mgr_id pa_rep_util_mgr_org_v.manager_id%TYPE;
780: l_orgz_id pa_rep_util_res_orgs_v.organization_id%TYPE;
781: l_mgnr_id pa_rep_util_res_orgs_v.organization_id%TYPE;
782: l_prd_quarter pa_rep_periods_v.mon_or_qtr%type;
783: l_glb_wek_dt pa_rep_periods_v.ge_week_dt%type;
784: l_period_year pa_rep_periods_v.period_year%TYPE;
785: l_msg_index_out INTEGER:=1;

Line 804: FROM pa_rep_util_res_orgs_v

800: /* BEGIN
801: IF (p_calling_mode = 'RESMGR') THEN
802: SELECT organization_id
803: INTO l_org_id
804: FROM pa_rep_util_res_orgs_v
805: WHERE organization_name = p_org_name;
806: l_orgz_id := l_org_id;
807: l_mgnr_id := p_mgr_id;
808: ELSIF (p_calling_mode = 'ORGMGR') THEN