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 467: Pa_Prj_Period_Profile_Utils.Get_Prj_Period_Profile_Dtls(

463: END;
464: --hr_utility.trace('after selecting from pa_proj_period_profiles: 300 succeeded');
465:
466: -- get period info based on period_profile_id
467: Pa_Prj_Period_Profile_Utils.Get_Prj_Period_Profile_Dtls(
468: p_period_profile_id => l_period_profile_id,
469: p_debug_mode => 'Y',
470: p_add_msg_in_stack => 'Y',
471: x_period_profile_type => l_period_profile_type,

Line 484: Pa_Prj_Period_Profile_Utils.Get_Curr_Period_Profile_Info(

480: -- get current period info
481: --hr_utility.trace('executed get_prj_Period_profile_dtls');
482: --hr_utility.trace('l_period_profile_type= ' || l_period_profile_type);
483: --hr_utility.trace('l_plan_period_type= ' || l_plan_period_type);
484: Pa_Prj_Period_Profile_Utils.Get_Curr_Period_Profile_Info(
485: p_project_id => l_project_id
486: ,p_period_type => l_plan_period_type
487: ,p_period_profile_type => 'FINANCIAL_PLANNING'
488: ,x_period_profile_id => l_cur_period_profile_id

Line 522: Pa_Prj_Period_Profile_Utils.get_current_period_info

518: l_num_of_periods := 13;
519: end if;
520:
521: -- get current period profile info
522: Pa_Prj_Period_Profile_Utils.get_current_period_info
523: (p_period_profile_id => l_period_profile_id,
524: x_cur_period_number => l_cur_period_number,
525: x_cur_period_name => l_cur_period_name,
526: x_cur_period_start_date => l_cur_period_start_date,

Line 664: x_prec_pds_flag := Pa_Prj_Period_Profile_Utils.has_preceding_periods

660: select nvl(all_time_phased_code, 'N')
661: into x_time_phase_code -- OUTPUT: x_time_phase_code
662: from pa_proj_fp_options
663: where fin_plan_version_id = pa_fp_view_plans_pub.G_FP_ALL_VERSION_ID;
664: x_prec_pds_flag := Pa_Prj_Period_Profile_Utils.has_preceding_periods
665: (pa_fp_view_plans_pub.G_FP_ALL_VERSION_ID);
666: x_succ_pds_flag := Pa_Prj_Period_Profile_Utils.has_succeeding_periods
667: (pa_fp_view_plans_pub.G_FP_ALL_VERSION_ID);
668: select plan_processing_code,

Line 666: x_succ_pds_flag := Pa_Prj_Period_Profile_Utils.has_succeeding_periods

662: from pa_proj_fp_options
663: where fin_plan_version_id = pa_fp_view_plans_pub.G_FP_ALL_VERSION_ID;
664: x_prec_pds_flag := Pa_Prj_Period_Profile_Utils.has_preceding_periods
665: (pa_fp_view_plans_pub.G_FP_ALL_VERSION_ID);
666: x_succ_pds_flag := Pa_Prj_Period_Profile_Utils.has_succeeding_periods
667: (pa_fp_view_plans_pub.G_FP_ALL_VERSION_ID);
668: select plan_processing_code,
669: request_id
670: into l_plan_processing_code,

Line 686: x_prec_pds_flag := Pa_Prj_Period_Profile_Utils.has_preceding_periods

682: select nvl(cost_time_phased_code, 'N')
683: into x_time_phase_code -- OUTPUT: x_time_phase_code
684: from pa_proj_fp_options
685: where fin_plan_version_id = pa_fp_view_plans_pub.G_FP_COST_VERSION_ID;
686: x_prec_pds_flag := Pa_Prj_Period_Profile_Utils.has_preceding_periods
687: (pa_fp_view_plans_pub.G_FP_COST_VERSION_ID);
688: x_succ_pds_flag := Pa_Prj_Period_Profile_Utils.has_succeeding_periods
689: (pa_fp_view_plans_pub.G_FP_COST_VERSION_ID);
690: select plan_processing_code,

Line 688: x_succ_pds_flag := Pa_Prj_Period_Profile_Utils.has_succeeding_periods

684: from pa_proj_fp_options
685: where fin_plan_version_id = pa_fp_view_plans_pub.G_FP_COST_VERSION_ID;
686: x_prec_pds_flag := Pa_Prj_Period_Profile_Utils.has_preceding_periods
687: (pa_fp_view_plans_pub.G_FP_COST_VERSION_ID);
688: x_succ_pds_flag := Pa_Prj_Period_Profile_Utils.has_succeeding_periods
689: (pa_fp_view_plans_pub.G_FP_COST_VERSION_ID);
690: select plan_processing_code,
691: request_id
692: into l_plan_processing_code,

Line 708: x_prec_pds_flag := Pa_Prj_Period_Profile_Utils.has_preceding_periods

704: select nvl(revenue_time_phased_code, 'N')
705: into x_time_phase_code -- OUTPUT: x_time_phase_code
706: from pa_proj_fp_options
707: where fin_plan_version_id = pa_fp_view_plans_pub.G_FP_REV_VERSION_ID;
708: x_prec_pds_flag := Pa_Prj_Period_Profile_Utils.has_preceding_periods
709: (pa_fp_view_plans_pub.G_FP_REV_VERSION_ID);
710: x_succ_pds_flag := Pa_Prj_Period_Profile_Utils.has_succeeding_periods
711: (pa_fp_view_plans_pub.G_FP_REV_VERSION_ID);
712: select plan_processing_code,

Line 710: x_succ_pds_flag := Pa_Prj_Period_Profile_Utils.has_succeeding_periods

706: from pa_proj_fp_options
707: where fin_plan_version_id = pa_fp_view_plans_pub.G_FP_REV_VERSION_ID;
708: x_prec_pds_flag := Pa_Prj_Period_Profile_Utils.has_preceding_periods
709: (pa_fp_view_plans_pub.G_FP_REV_VERSION_ID);
710: x_succ_pds_flag := Pa_Prj_Period_Profile_Utils.has_succeeding_periods
711: (pa_fp_view_plans_pub.G_FP_REV_VERSION_ID);
712: select plan_processing_code,
713: request_id
714: into l_plan_processing_code,

Line 754: if Pa_Prj_Period_Profile_Utils.has_preceding_periods

750: x_primary_pp_bv_id := pa_fp_view_plans_pub.G_FP_REV_VERSION_ID;
751: end if;
752: end if;
753: */
754: if Pa_Prj_Period_Profile_Utils.has_preceding_periods
755: (pa_fp_view_plans_pub.G_FP_COST_VERSION_ID) = 'Y' or
756: Pa_Prj_Period_Profile_Utils.has_preceding_periods
757: (pa_fp_view_plans_pub.G_FP_REV_VERSION_ID) = 'Y' then
758: x_prec_pds_flag := 'Y';

Line 756: Pa_Prj_Period_Profile_Utils.has_preceding_periods

752: end if;
753: */
754: if Pa_Prj_Period_Profile_Utils.has_preceding_periods
755: (pa_fp_view_plans_pub.G_FP_COST_VERSION_ID) = 'Y' or
756: Pa_Prj_Period_Profile_Utils.has_preceding_periods
757: (pa_fp_view_plans_pub.G_FP_REV_VERSION_ID) = 'Y' then
758: x_prec_pds_flag := 'Y';
759: else
760: x_prec_pds_flag := 'N';

Line 762: if Pa_Prj_Period_Profile_Utils.has_succeeding_periods

758: x_prec_pds_flag := 'Y';
759: else
760: x_prec_pds_flag := 'N';
761: end if;
762: if Pa_Prj_Period_Profile_Utils.has_succeeding_periods
763: (pa_fp_view_plans_pub.G_FP_COST_VERSION_ID) = 'Y' or
764: Pa_Prj_Period_Profile_Utils.has_succeeding_periods
765: (pa_fp_view_plans_pub.G_FP_REV_VERSION_ID) = 'Y' then
766: x_succ_pds_flag := 'Y';

Line 764: Pa_Prj_Period_Profile_Utils.has_succeeding_periods

760: x_prec_pds_flag := 'N';
761: end if;
762: if Pa_Prj_Period_Profile_Utils.has_succeeding_periods
763: (pa_fp_view_plans_pub.G_FP_COST_VERSION_ID) = 'Y' or
764: Pa_Prj_Period_Profile_Utils.has_succeeding_periods
765: (pa_fp_view_plans_pub.G_FP_REV_VERSION_ID) = 'Y' then
766: x_succ_pds_flag := 'Y';
767: else
768: x_succ_pds_flag := 'N';

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

1011: l_cost_locked_by_person_id NUMBER;
1012: l_is_rev_locked_by_user VARCHAR2(1);
1013: l_rev_locked_by_person_id NUMBER;
1014:
1015: -- local variables for calling Pa_Prj_Period_Profile_Utils.Get_Prj_Period_Profile_Dtls
1016: l_period_profile_id NUMBER;
1017: l_period_profile_type VARCHAR2(80);
1018: l_plan_period_type VARCHAR2(80);
1019: l_period_set_name VARCHAR2(80);

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

1021: l_plan_start_date DATE;
1022: l_plan_end_date DATE;
1023: l_number_of_periods NUMBER;
1024:
1025: -- local variables for calling Pa_Prj_Period_Profile_Utils.Get_Curr_Period_Profile_Info
1026: l_cur_period_profile_id pa_proj_period_profiles.period_profile_id%TYPE;
1027: l_cur_start_period VARCHAR2(30);
1028: l_cur_end_period VARCHAR2(30);
1029:

Line 1750: Pa_Prj_Period_Profile_Utils.Get_Prj_Period_Profile_Dtls(

1746: -- ONLY IF IN PERIODIC MODE --
1747:
1748: if p_amt_or_pd = 'P' then
1749: -- get period info based on period_profile_id
1750: Pa_Prj_Period_Profile_Utils.Get_Prj_Period_Profile_Dtls(
1751: p_period_profile_id => l_period_profile_id,
1752: p_debug_mode => 'Y',
1753: p_add_msg_in_stack => 'Y',
1754: x_period_profile_type => l_period_profile_type,

Line 1767: Pa_Prj_Period_Profile_Utils.Get_Curr_Period_Profile_Info(

1763: -- get current period info
1764: --hr_utility.trace('executed get_prj_Period_profile_dtls');
1765: --hr_utility.trace('l_period_profile_type= ' || l_period_profile_type);
1766: --hr_utility.trace('l_plan_period_type= ' || l_plan_period_type);
1767: Pa_Prj_Period_Profile_Utils.Get_Curr_Period_Profile_Info(
1768: p_project_id => l_project_id
1769: ,p_period_type => l_plan_period_type
1770: ,p_period_profile_type => 'FINANCIAL_PLANNING'
1771: ,x_period_profile_id => l_cur_period_profile_id