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 579: l_period_year pa_rep_periods_v.period_year%TYPE;

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

Line 672: FROM pa_rep_periods_v

668: -- Validating select year
669: BEGIN
670: SELECT period_year
671: INTO l_period_year
672: FROM pa_rep_periods_v
673: WHERE period_type = l_period_type
674: AND period_year = p_select_yr
675: AND ROWNUM = 1;
676: EXCEPTION

Line 699: FROM pa_rep_periods_v

695: BEGIN
696: IF (l_period_type = 'PA' OR l_period_type = 'GL' OR l_period_type = 'GE') THEN
697: SELECT period_name
698: INTO x_period_name
699: FROM pa_rep_periods_v
700: WHERE period_type = l_period_type
701: AND ( period_name = p_period_name
702: OR period_name||' '||period_status = p_period_name)
703: AND period_year = p_select_yr;

Line 707: FROM pa_rep_periods_v

703: AND period_year = p_select_yr;
704: ELSIF (l_period_type = 'QR') THEN
705: SELECT TO_CHAR(mon_or_qtr)
706: INTO x_period_name
707: FROM pa_rep_periods_v
708: WHERE period_type = l_period_type
709: AND ( period_name = p_period_name
710: OR period_name||' '||period_status = p_period_name)
711: AND period_year = p_select_yr;

Line 777: l_period_name pa_rep_periods_v.period_name%TYPE;

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

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

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

Line 784: l_period_year pa_rep_periods_v.period_year%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;
786: l_init_msg_list VARCHAR2(20) := FND_API.G_TRUE;
787: l_calling_mode VARCHAR2(15);
788:

Line 881: FROM pa_rep_periods_v

877: -- Validating period year
878: BEGIN
879: SELECT period_year
880: INTO l_period_year
881: FROM pa_rep_periods_v
882: WHERE period_type = l_period_type
883: AND period_year = p_period_year
884: AND ROWNUM =1;
885:

Line 908: FROM pa_rep_periods_v

904: -- Validating period name
905: BEGIN
906: SELECT period_name
907: INTO l_period_name
908: FROM pa_rep_periods_v
909: WHERE period_type = l_period_type
910: AND ( period_name = p_period_name
911: OR period_name||' '||period_status = p_period_name)
912: AND period_year = p_period_year;

Line 936: FROM pa_rep_periods_v

932:
933: IF (l_period_type = 'QR') THEN
934: SELECT MON_OR_QTR
935: INTO l_prd_quarter
936: FROM pa_rep_periods_v
937: WHERE period_type = l_period_type
938: AND ( period_name = p_period_name
939: OR period_name||' '||period_status = p_period_name)
940: AND period_year = p_period_year;

Line 948: FROM pa_rep_periods_v

944:
945: IF (l_period_type = 'GE') THEN
946: SELECT ge_week_dt
947: INTO l_glb_wek_dt
948: FROM pa_rep_periods_v
949: WHERE period_type = l_period_type
950: AND ( period_name = p_period_name
951: OR period_name||' '||period_status = p_period_name)
952: AND period_year = p_period_year;

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

1591: x_def_period_sts_code := ' ';
1592: END IF;
1593: END IF;
1594: --Added the below cos for GE status = NULL
1595: --Select from pa_rep_periods_v gives ' ' but this was giving NULL
1596: 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;
1597: EXCEPTION
1598: WHEN OTHERS THEN
1599: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;