APPS.PA_REPORT_UTIL dependencies on PA_REP_PERIOD_TYPES_V

Line 545: l_period_type pa_rep_period_types_v.period_type%TYPE;

541:
542: IS
543: l_invalid_value EXCEPTION;
544: l_exist VARCHAR2(1) := 'N';
545: l_period_type pa_rep_period_types_v.period_type%TYPE;
546: l_period_year pa_rep_periods_v.period_year%TYPE;
547: l_msg_index_out INTEGER:=1;
548: l_init_msg_list VARCHAR2(20) := FND_API.G_TRUE;
549: BEGIN

Line 589: FROM pa_rep_period_types_v

585: -- Validating period type
586: BEGIN
587: SELECT period_type
588: INTO l_period_type
589: FROM pa_rep_period_types_v
590: WHERE period_type_desc = p_period_type_desc;
591:
592: x_period_type := l_period_type;
593:

Line 743: l_period_type pa_rep_period_types_v.period_type_desc%type;

739: x_msg_data OUT NOCOPY VARCHAR2)
740: IS
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;

Line 795: FROM pa_rep_period_types_v

791: -- Validating period type
792: BEGIN
793: SELECT PERIOD_TYPE
794: INTO l_period_type
795: FROM pa_rep_period_types_v
796: WHERE period_type_desc = p_period_type_desc;
797:
798: EXCEPTION
799: WHEN NO_DATA_FOUND THEN