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_FP_VIEW_PLANS_PUB dependencies on PA_PRJ_PERIOD_PROFILE_UTILS

Line 102: -- local variables for calling Pa_Prj_Period_Profile_Utils.Get_Prj_Period_Profile_Dtls

98: l_cost_locked_by_person_id NUMBER;
99: l_is_rev_locked_by_user VARCHAR2(1);
100: l_rev_locked_by_person_id NUMBER;
101:
102: -- local variables for calling Pa_Prj_Period_Profile_Utils.Get_Prj_Period_Profile_Dtls
103: l_period_profile_id NUMBER;
104: l_period_profile_type VARCHAR2(80);
105: l_plan_period_type VARCHAR2(80);
106: l_period_set_name VARCHAR2(80);

Line 112: -- local variables for calling Pa_Prj_Period_Profile_Utils procedures

108: l_plan_start_date DATE;
109: l_plan_end_date DATE;
110: l_number_of_periods NUMBER;
111:
112: -- local variables for calling Pa_Prj_Period_Profile_Utils procedures
113: l_cur_period_profile_id pa_proj_period_profiles.period_profile_id%TYPE;
114: l_cur_start_period VARCHAR2(30);
115: l_cur_end_period VARCHAR2(30);
116: l_cur_period_number NUMBER;

Line 486: Pa_Prj_Period_Profile_Utils.Get_Prj_Period_Profile_Dtls(

482: --hr_utility.trace('after selecting from pa_proj_period_profiles: 300 succeeded');
483:
484: -- get period info based on period_profile_id
485: /* Starts Commented for bug 7456425
486: Pa_Prj_Period_Profile_Utils.Get_Prj_Period_Profile_Dtls(
487: p_period_profile_id => l_period_profile_id,
488: p_debug_mode => 'Y',
489: p_add_msg_in_stack => 'Y',
490: x_period_profile_type => l_period_profile_type,

Line 503: Pa_Prj_Period_Profile_Utils.Get_Curr_Period_Profile_Info(

499: -- get current period info
500: --hr_utility.trace('executed get_prj_Period_profile_dtls');
501: --hr_utility.trace('l_period_profile_type= ' || l_period_profile_type);
502: --hr_utility.trace('l_plan_period_type= ' || l_plan_period_type);
503: Pa_Prj_Period_Profile_Utils.Get_Curr_Period_Profile_Info(
504: p_project_id => l_project_id
505: ,p_period_type => l_plan_period_type
506: ,p_period_profile_type => 'FINANCIAL_PLANNING'
507: ,x_period_profile_id => l_cur_period_profile_id

Line 562: Pa_Prj_Period_Profile_Utils.get_current_period_info

558: l_num_of_periods := 13;
559: end if;
560: /* Starts commented for 7456425
561: -- get current period profile info
562: Pa_Prj_Period_Profile_Utils.get_current_period_info
563: (p_period_profile_id => l_period_profile_id,
564: x_cur_period_number => l_cur_period_number,
565: x_cur_period_name => l_cur_period_name,
566: x_cur_period_start_date => l_cur_period_start_date,

Line 760: x_prec_pds_flag := Pa_Prj_Period_Profile_Utils.has_preceding_periods

756: select nvl(all_time_phased_code, 'N')
757: into x_time_phase_code -- OUTPUT: x_time_phase_code
758: from pa_proj_fp_options
759: where fin_plan_version_id = pa_fp_view_plans_pub.G_FP_ALL_VERSION_ID;
760: x_prec_pds_flag := Pa_Prj_Period_Profile_Utils.has_preceding_periods
761: (pa_fp_view_plans_pub.G_FP_ALL_VERSION_ID);
762: x_succ_pds_flag := Pa_Prj_Period_Profile_Utils.has_succeeding_periods
763: (pa_fp_view_plans_pub.G_FP_ALL_VERSION_ID);
764: select plan_processing_code,

Line 762: x_succ_pds_flag := Pa_Prj_Period_Profile_Utils.has_succeeding_periods

758: from pa_proj_fp_options
759: where fin_plan_version_id = pa_fp_view_plans_pub.G_FP_ALL_VERSION_ID;
760: x_prec_pds_flag := Pa_Prj_Period_Profile_Utils.has_preceding_periods
761: (pa_fp_view_plans_pub.G_FP_ALL_VERSION_ID);
762: x_succ_pds_flag := Pa_Prj_Period_Profile_Utils.has_succeeding_periods
763: (pa_fp_view_plans_pub.G_FP_ALL_VERSION_ID);
764: select plan_processing_code,
765: request_id
766: into l_plan_processing_code,

Line 782: x_prec_pds_flag := Pa_Prj_Period_Profile_Utils.has_preceding_periods

778: select nvl(cost_time_phased_code, 'N')
779: into x_time_phase_code -- OUTPUT: x_time_phase_code
780: from pa_proj_fp_options
781: where fin_plan_version_id = pa_fp_view_plans_pub.G_FP_COST_VERSION_ID;
782: x_prec_pds_flag := Pa_Prj_Period_Profile_Utils.has_preceding_periods
783: (pa_fp_view_plans_pub.G_FP_COST_VERSION_ID);
784: x_succ_pds_flag := Pa_Prj_Period_Profile_Utils.has_succeeding_periods
785: (pa_fp_view_plans_pub.G_FP_COST_VERSION_ID);
786: select plan_processing_code,

Line 784: x_succ_pds_flag := Pa_Prj_Period_Profile_Utils.has_succeeding_periods

780: from pa_proj_fp_options
781: where fin_plan_version_id = pa_fp_view_plans_pub.G_FP_COST_VERSION_ID;
782: x_prec_pds_flag := Pa_Prj_Period_Profile_Utils.has_preceding_periods
783: (pa_fp_view_plans_pub.G_FP_COST_VERSION_ID);
784: x_succ_pds_flag := Pa_Prj_Period_Profile_Utils.has_succeeding_periods
785: (pa_fp_view_plans_pub.G_FP_COST_VERSION_ID);
786: select plan_processing_code,
787: request_id
788: into l_plan_processing_code,

Line 804: x_prec_pds_flag := Pa_Prj_Period_Profile_Utils.has_preceding_periods

800: select nvl(revenue_time_phased_code, 'N')
801: into x_time_phase_code -- OUTPUT: x_time_phase_code
802: from pa_proj_fp_options
803: where fin_plan_version_id = pa_fp_view_plans_pub.G_FP_REV_VERSION_ID;
804: x_prec_pds_flag := Pa_Prj_Period_Profile_Utils.has_preceding_periods
805: (pa_fp_view_plans_pub.G_FP_REV_VERSION_ID);
806: x_succ_pds_flag := Pa_Prj_Period_Profile_Utils.has_succeeding_periods
807: (pa_fp_view_plans_pub.G_FP_REV_VERSION_ID);
808: select plan_processing_code,

Line 806: x_succ_pds_flag := Pa_Prj_Period_Profile_Utils.has_succeeding_periods

802: from pa_proj_fp_options
803: where fin_plan_version_id = pa_fp_view_plans_pub.G_FP_REV_VERSION_ID;
804: x_prec_pds_flag := Pa_Prj_Period_Profile_Utils.has_preceding_periods
805: (pa_fp_view_plans_pub.G_FP_REV_VERSION_ID);
806: x_succ_pds_flag := Pa_Prj_Period_Profile_Utils.has_succeeding_periods
807: (pa_fp_view_plans_pub.G_FP_REV_VERSION_ID);
808: select plan_processing_code,
809: request_id
810: into l_plan_processing_code,

Line 850: if Pa_Prj_Period_Profile_Utils.has_preceding_periods

846: x_primary_pp_bv_id := pa_fp_view_plans_pub.G_FP_REV_VERSION_ID;
847: end if;
848: end if;
849: */
850: if Pa_Prj_Period_Profile_Utils.has_preceding_periods
851: (pa_fp_view_plans_pub.G_FP_COST_VERSION_ID) = 'Y' or
852: Pa_Prj_Period_Profile_Utils.has_preceding_periods
853: (pa_fp_view_plans_pub.G_FP_REV_VERSION_ID) = 'Y' then
854: x_prec_pds_flag := 'Y';

Line 852: Pa_Prj_Period_Profile_Utils.has_preceding_periods

848: end if;
849: */
850: if Pa_Prj_Period_Profile_Utils.has_preceding_periods
851: (pa_fp_view_plans_pub.G_FP_COST_VERSION_ID) = 'Y' or
852: Pa_Prj_Period_Profile_Utils.has_preceding_periods
853: (pa_fp_view_plans_pub.G_FP_REV_VERSION_ID) = 'Y' then
854: x_prec_pds_flag := 'Y';
855: else
856: x_prec_pds_flag := 'N';

Line 858: if Pa_Prj_Period_Profile_Utils.has_succeeding_periods

854: x_prec_pds_flag := 'Y';
855: else
856: x_prec_pds_flag := 'N';
857: end if;
858: if Pa_Prj_Period_Profile_Utils.has_succeeding_periods
859: (pa_fp_view_plans_pub.G_FP_COST_VERSION_ID) = 'Y' or
860: Pa_Prj_Period_Profile_Utils.has_succeeding_periods
861: (pa_fp_view_plans_pub.G_FP_REV_VERSION_ID) = 'Y' then
862: x_succ_pds_flag := 'Y';

Line 860: Pa_Prj_Period_Profile_Utils.has_succeeding_periods

856: x_prec_pds_flag := 'N';
857: end if;
858: if Pa_Prj_Period_Profile_Utils.has_succeeding_periods
859: (pa_fp_view_plans_pub.G_FP_COST_VERSION_ID) = 'Y' or
860: Pa_Prj_Period_Profile_Utils.has_succeeding_periods
861: (pa_fp_view_plans_pub.G_FP_REV_VERSION_ID) = 'Y' then
862: x_succ_pds_flag := 'Y';
863: else
864: x_succ_pds_flag := 'N';

Line 1111: -- local variables for calling Pa_Prj_Period_Profile_Utils.Get_Prj_Period_Profile_Dtls

1107: l_cost_locked_by_person_id NUMBER;
1108: l_is_rev_locked_by_user VARCHAR2(1);
1109: l_rev_locked_by_person_id NUMBER;
1110:
1111: -- local variables for calling Pa_Prj_Period_Profile_Utils.Get_Prj_Period_Profile_Dtls
1112: l_period_profile_id NUMBER;
1113: l_period_profile_type VARCHAR2(80);
1114: l_plan_period_type VARCHAR2(80);
1115: l_period_set_name VARCHAR2(80);

Line 1121: -- local variables for calling Pa_Prj_Period_Profile_Utils.Get_Curr_Period_Profile_Info

1117: l_plan_start_date DATE;
1118: l_plan_end_date DATE;
1119: l_number_of_periods NUMBER;
1120:
1121: -- local variables for calling Pa_Prj_Period_Profile_Utils.Get_Curr_Period_Profile_Info
1122: l_cur_period_profile_id pa_proj_period_profiles.period_profile_id%TYPE;
1123: l_cur_start_period VARCHAR2(30);
1124: l_cur_end_period VARCHAR2(30);
1125:

Line 1861: Pa_Prj_Period_Profile_Utils.Get_Prj_Period_Profile_Dtls(

1857: -- ONLY IF IN PERIODIC MODE --
1858:
1859: if p_amt_or_pd = 'P' then
1860: -- get period info based on period_profile_id
1861: Pa_Prj_Period_Profile_Utils.Get_Prj_Period_Profile_Dtls(
1862: p_period_profile_id => l_period_profile_id,
1863: p_debug_mode => 'Y',
1864: p_add_msg_in_stack => 'Y',
1865: x_period_profile_type => l_period_profile_type,

Line 1878: Pa_Prj_Period_Profile_Utils.Get_Curr_Period_Profile_Info(

1874: -- get current period info
1875: --hr_utility.trace('executed get_prj_Period_profile_dtls');
1876: --hr_utility.trace('l_period_profile_type= ' || l_period_profile_type);
1877: --hr_utility.trace('l_plan_period_type= ' || l_plan_period_type);
1878: Pa_Prj_Period_Profile_Utils.Get_Curr_Period_Profile_Info(
1879: p_project_id => l_project_id
1880: ,p_period_type => l_plan_period_type
1881: ,p_period_profile_type => 'FINANCIAL_PLANNING'
1882: ,x_period_profile_id => l_cur_period_profile_id