eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_REPORT_UTIL dependencies on PA_REP_PERIODS_V

Line 546: l_period_year pa_rep_periods_v.period_year%TYPE;

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
550: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 639: FROM pa_rep_periods_v

635: -- Validating select year
636: BEGIN
637: SELECT period_year
638: INTO l_period_year
639: FROM pa_rep_periods_v
640: WHERE period_type = l_period_type
641: AND period_year = p_select_yr
642: AND ROWNUM = 1;
643: EXCEPTION

Line 666: FROM pa_rep_periods_v

662: BEGIN
663: IF (l_period_type = 'PA' OR l_period_type = 'GL' OR l_period_type = 'GE') THEN
664: SELECT period_name
665: INTO x_period_name
666: FROM pa_rep_periods_v
667: WHERE period_type = l_period_type
668: AND ( period_name = p_period_name
669: OR period_name||' '||period_status = p_period_name)
670: AND period_year = p_select_yr;

Line 674: FROM pa_rep_periods_v

670: AND period_year = p_select_yr;
671: ELSIF (l_period_type = 'QR') THEN
672: SELECT TO_CHAR(mon_or_qtr)
673: INTO x_period_name
674: FROM pa_rep_periods_v
675: WHERE period_type = l_period_type
676: AND ( period_name = p_period_name
677: OR period_name||' '||period_status = p_period_name)
678: AND period_year = p_select_yr;

Line 744: l_period_name pa_rep_periods_v.period_name%TYPE;

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;
748: l_mgnr_id pa_rep_util_res_orgs_v.organization_id%TYPE;

Line 749: l_prd_quarter pa_rep_periods_v.mon_or_qtr%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;
753: l_init_msg_list VARCHAR2(20) := FND_API.G_TRUE;

Line 750: l_glb_wek_dt pa_rep_periods_v.ge_week_dt%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;
753: l_init_msg_list VARCHAR2(20) := FND_API.G_TRUE;
754: l_calling_mode VARCHAR2(15);

Line 751: l_period_year pa_rep_periods_v.period_year%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;
753: l_init_msg_list VARCHAR2(20) := FND_API.G_TRUE;
754: l_calling_mode VARCHAR2(15);
755:

Line 848: FROM pa_rep_periods_v

844: -- Validating period year
845: BEGIN
846: SELECT period_year
847: INTO l_period_year
848: FROM pa_rep_periods_v
849: WHERE period_type = l_period_type
850: AND period_year = p_period_year
851: AND ROWNUM =1;
852:

Line 875: FROM pa_rep_periods_v

871: -- Validating period name
872: BEGIN
873: SELECT period_name
874: INTO l_period_name
875: FROM pa_rep_periods_v
876: WHERE period_type = l_period_type
877: AND ( period_name = p_period_name
878: OR period_name||' '||period_status = p_period_name)
879: AND period_year = p_period_year;

Line 903: FROM pa_rep_periods_v

899:
900: IF (l_period_type = 'QR') THEN
901: SELECT MON_OR_QTR
902: INTO l_prd_quarter
903: FROM pa_rep_periods_v
904: WHERE period_type = l_period_type
905: AND ( period_name = p_period_name
906: OR period_name||' '||period_status = p_period_name)
907: AND period_year = p_period_year;

Line 915: FROM pa_rep_periods_v

911:
912: IF (l_period_type = 'GE') THEN
913: SELECT ge_week_dt
914: INTO l_glb_wek_dt
915: FROM pa_rep_periods_v
916: WHERE period_type = l_period_type
917: AND ( period_name = p_period_name
918: OR period_name||' '||period_status = p_period_name)
919: AND period_year = p_period_year;

Line 1532: --Select from pa_rep_periods_v gives ' ' but this was giving NULL

1528: x_def_period_sts_code := ' ';
1529: END IF;
1530: END IF;
1531: --Added the below cos for GE status = NULL
1532: --Select from pa_rep_periods_v gives ' ' but this was giving NULL
1533: x_def_period := x_def_period_typ||'#'||x_def_period_name||'#'||x_def_period_sts_code||'#'||x_def_period_sts||'#'||x_def_mon_or_qtr||'#'||x_def_period_yr||'#'||x_def_period_num;
1534: EXCEPTION
1535: WHEN OTHERS THEN
1536: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;