APPS.PA_REPORT_UTIL dependencies on PA_REP_PERIOD_TYPES_V

Line 578: l_period_type pa_rep_period_types_v.period_type%TYPE;

574:
575: IS
576: l_invalid_value EXCEPTION;
577: l_exist VARCHAR2(1) := 'N';
578: l_period_type pa_rep_period_types_v.period_type%TYPE;
579: l_period_year pa_rep_periods_v.period_year%TYPE;
580: l_msg_index_out INTEGER:=1;
581: l_init_msg_list VARCHAR2(20) := FND_API.G_TRUE;
582: BEGIN

Line 622: FROM pa_rep_period_types_v

618: -- Validating period type
619: BEGIN
620: SELECT period_type
621: INTO l_period_type
622: FROM pa_rep_period_types_v
623: WHERE period_type_desc = p_period_type_desc;
624:
625: x_period_type := l_period_type;
626:

Line 776: l_period_type pa_rep_period_types_v.period_type_desc%type;

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

Line 828: FROM pa_rep_period_types_v

824: -- Validating period type
825: BEGIN
826: SELECT PERIOD_TYPE
827: INTO l_period_type
828: FROM pa_rep_period_types_v
829: WHERE period_type_desc = p_period_type_desc;
830:
831: EXCEPTION
832: WHEN NO_DATA_FOUND THEN