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_PRJ_PERIOD_PROFILE_UTILS dependencies on PA_PROJ_PERIOD_PROFILES

Line 135: UPDATE pa_proj_period_profiles SET

131: END LOOP;
132:
133: l_temp := 0;
134: IF px_period_profile_id IS NOT NULL THEN
135: UPDATE pa_proj_period_profiles SET
136: number_of_periods = l_tab_count,
137: period_name1 = l_period_name_tab(1),
138: period_name2 = l_period_name_tab(2),
139: period_name3 = l_period_name_tab(3),

Line 315: INSERT INTO pa_proj_period_profiles (

311: PA_DEBUG.Reset_Curr_Function;
312: RETURN;
313: END IF;
314: ELSE
315: INSERT INTO pa_proj_period_profiles (
316: CREATION_DATE ,
317: CREATED_BY ,
318: LAST_UPDATE_LOGIN ,
319: LAST_UPDATED_BY ,

Line 491: PA_PROJ_PERIOD_PROFILES_S.nextval,

487: l_created_by ,
488: l_last_update_login ,
489: l_last_updated_by ,
490: l_last_update_date ,
491: PA_PROJ_PERIOD_PROFILES_S.nextval,
492: p_period_profile_type,
493: p_period_set_name,
494: p_gl_period_type,
495: p_plan_period_type,

Line 662: UPDATE PA_PROJ_PERIOD_PROFILES SET CURRENT_FLAG = 'N' WHERE

658: PA_DEBUG.g_err_stage := 'after inserting pd profile';
659: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
660: END IF;
661:
662: UPDATE PA_PROJ_PERIOD_PROFILES SET CURRENT_FLAG = 'N' WHERE
663: Period_Profile_Type = p_period_profile_type AND
664: Plan_Period_Type = p_plan_period_type AND
665: Project_Id = p_project_id AND
666: Current_Flag = 'Y';

Line 668: UPDATE PA_PROJ_PERIOD_PROFILES SET CURRENT_FLAG = 'Y' WHERE

664: Plan_Period_Type = p_plan_period_type AND
665: Project_Id = p_project_id AND
666: Current_Flag = 'Y';
667:
668: UPDATE PA_PROJ_PERIOD_PROFILES SET CURRENT_FLAG = 'Y' WHERE
669: Period_Profile_Id = px_period_profile_id;
670:
671: END IF;
672: IF NVL(p_commit_flag,'N') = 'Y' THEN

Line 716: x_plan_start_date FROM Pa_Proj_Period_Profiles

712: x_plan_period_type,
713: x_period_set_name,
714: x_gl_period_type,
715: x_number_of_periods,
716: x_plan_start_date FROM Pa_Proj_Period_Profiles
717: WHERE Period_Profile_Id = NVL(p_period_profile_id,0);
718:
719: l_column_name := 'PERIOD'||LTRIM(TO_CHAR(x_number_of_periods))||'_END_DATE';
720: l_cursor_id := dbms_sql.open_cursor;

Line 722: || ' from pa_proj_period_profiles where ' ||

718:
719: l_column_name := 'PERIOD'||LTRIM(TO_CHAR(x_number_of_periods))||'_END_DATE';
720: l_cursor_id := dbms_sql.open_cursor;
721: l_stmt := 'select ' ||l_column_name
722: || ' from pa_proj_period_profiles where ' ||
723: ' period_profile_id = '||to_char(p_period_profile_id);
724:
725: dbms_sql.parse(l_cursor_id,l_stmt,dbms_sql.native);
726: dbms_sql.define_column(l_cursor_id,1,l_plan_end_date);

Line 866: l_plan_period_type Pa_Proj_Period_Profiles.Plan_Period_Type%TYPE;

862: l_pa_plan_start_date DATE;
863: l_pa_plan_end_date DATE;
864: l_gl_plan_start_date DATE;
865: l_gl_plan_end_date DATE;
866: l_plan_period_type Pa_Proj_Period_Profiles.Plan_Period_Type%TYPE;
867: l_para_start_Date DATE;
868: l_para_end_Date DATE;
869: l_para_period_profile_id NUMBER;
870: l_para_number_of_periods NUMBER;

Line 881: l_old_pa_start_period Pa_Proj_Period_Profiles.Period_Name1%TYPE;

877: l_valid_pa_period_flag VARCHAR2(1);
878: l_valid_gl_period_flag VARCHAR2(1);
879: l_call_profile_pa_flag VARCHAR2(1);
880: l_call_profile_gl_flag VARCHAR2(1);
881: l_old_pa_start_period Pa_Proj_Period_Profiles.Period_Name1%TYPE;
882: l_old_gl_start_period Pa_Proj_Period_Profiles.Period_Name1%TYPE;
883: l_old_pa_end_period Pa_Proj_Period_Profiles.Period_Name1%TYPE;
884: l_old_gl_end_period Pa_Proj_Period_Profiles.Period_Name1%TYPE;
885: l_periods_count NUMBER;

Line 882: l_old_gl_start_period Pa_Proj_Period_Profiles.Period_Name1%TYPE;

878: l_valid_gl_period_flag VARCHAR2(1);
879: l_call_profile_pa_flag VARCHAR2(1);
880: l_call_profile_gl_flag VARCHAR2(1);
881: l_old_pa_start_period Pa_Proj_Period_Profiles.Period_Name1%TYPE;
882: l_old_gl_start_period Pa_Proj_Period_Profiles.Period_Name1%TYPE;
883: l_old_pa_end_period Pa_Proj_Period_Profiles.Period_Name1%TYPE;
884: l_old_gl_end_period Pa_Proj_Period_Profiles.Period_Name1%TYPE;
885: l_periods_count NUMBER;
886: l_msg_count NUMBER :=0;

Line 883: l_old_pa_end_period Pa_Proj_Period_Profiles.Period_Name1%TYPE;

879: l_call_profile_pa_flag VARCHAR2(1);
880: l_call_profile_gl_flag VARCHAR2(1);
881: l_old_pa_start_period Pa_Proj_Period_Profiles.Period_Name1%TYPE;
882: l_old_gl_start_period Pa_Proj_Period_Profiles.Period_Name1%TYPE;
883: l_old_pa_end_period Pa_Proj_Period_Profiles.Period_Name1%TYPE;
884: l_old_gl_end_period Pa_Proj_Period_Profiles.Period_Name1%TYPE;
885: l_periods_count NUMBER;
886: l_msg_count NUMBER :=0;
887: l_msg_data VARCHAR2(2000);

Line 884: l_old_gl_end_period Pa_Proj_Period_Profiles.Period_Name1%TYPE;

880: l_call_profile_gl_flag VARCHAR2(1);
881: l_old_pa_start_period Pa_Proj_Period_Profiles.Period_Name1%TYPE;
882: l_old_gl_start_period Pa_Proj_Period_Profiles.Period_Name1%TYPE;
883: l_old_pa_end_period Pa_Proj_Period_Profiles.Period_Name1%TYPE;
884: l_old_gl_end_period Pa_Proj_Period_Profiles.Period_Name1%TYPE;
885: l_periods_count NUMBER;
886: l_msg_count NUMBER :=0;
887: l_msg_data VARCHAR2(2000);
888: l_data VARCHAR2(2000);

Line 1432: Pa_Proj_Period_Profiles WHERE

1428:
1429: IF p_old_pa_profile_id IS NOT NULL THEN
1430: SELECT PERIOD_NAME1 , PROFILE_END_PERIOD_NAME INTO
1431: l_old_pa_start_period,l_old_pa_end_period FROM
1432: Pa_Proj_Period_Profiles WHERE
1433: Period_Profile_Id = p_old_pa_profile_id;
1434: IF l_old_pa_start_period = p_pa_start_period AND
1435: l_old_pa_end_period = p_pa_end_period THEN
1436: l_call_profile_pa_flag := 'N';

Line 1443: Pa_Proj_Period_Profiles WHERE

1439:
1440: IF p_old_gl_profile_id IS NOT NULL THEN
1441: SELECT PERIOD_NAME1 , PROFILE_END_PERIOD_NAME INTO
1442: l_old_gl_start_period,l_old_gl_end_period FROM
1443: Pa_Proj_Period_Profiles WHERE
1444: Period_Profile_Id = p_old_gl_profile_id;
1445: IF l_old_gl_start_period = p_gl_start_period AND
1446: l_old_gl_end_period = p_gl_end_period THEN
1447: l_call_profile_gl_flag := 'N';

Line 1685: l_dummy_pa_period_profile_id pa_proj_period_profiles.period_profile_id%TYPE;

1681: l_dummy_gl_end_date DATE;
1682: l_pd_gl_end_date DATE;
1683: l_pd_pa_end_date DATE;
1684:
1685: l_dummy_pa_period_profile_id pa_proj_period_profiles.period_profile_id%TYPE;
1686: l_dummy_gl_period_profile_id pa_proj_period_profiles.period_profile_id%TYPE;
1687: l_dummy_pa_number_of_periods NUMBER;
1688: l_dummy_gl_number_of_periods NUMBER;
1689: l_dummy_pa_plan_start_date DATE;

Line 1686: l_dummy_gl_period_profile_id pa_proj_period_profiles.period_profile_id%TYPE;

1682: l_pd_gl_end_date DATE;
1683: l_pd_pa_end_date DATE;
1684:
1685: l_dummy_pa_period_profile_id pa_proj_period_profiles.period_profile_id%TYPE;
1686: l_dummy_gl_period_profile_id pa_proj_period_profiles.period_profile_id%TYPE;
1687: l_dummy_pa_number_of_periods NUMBER;
1688: l_dummy_gl_number_of_periods NUMBER;
1689: l_dummy_pa_plan_start_date DATE;
1690: l_dummy_pa_plan_end_date DATE;

Line 1693: l_dummy_pa_period_profile_type pa_proj_period_profiles.period_profile_type%TYPE;

1689: l_dummy_pa_plan_start_date DATE;
1690: l_dummy_pa_plan_end_date DATE;
1691: l_dummy_gl_plan_start_date DATE;
1692: l_dummy_gl_plan_end_date DATE;
1693: l_dummy_pa_period_profile_type pa_proj_period_profiles.period_profile_type%TYPE;
1694: l_dummy_gl_period_profile_type pa_proj_period_profiles.period_profile_type%TYPE;
1695:
1696: /* Commenting for bug 7578853
1697: CURSOR end_period_cur(c_period_set_name varchar2,

Line 1694: l_dummy_gl_period_profile_type pa_proj_period_profiles.period_profile_type%TYPE;

1690: l_dummy_pa_plan_end_date DATE;
1691: l_dummy_gl_plan_start_date DATE;
1692: l_dummy_gl_plan_end_date DATE;
1693: l_dummy_pa_period_profile_type pa_proj_period_profiles.period_profile_type%TYPE;
1694: l_dummy_gl_period_profile_type pa_proj_period_profiles.period_profile_type%TYPE;
1695:
1696: /* Commenting for bug 7578853
1697: CURSOR end_period_cur(c_period_set_name varchar2,
1698: c_period_type varchar2,

Line 1772: FROM pa_proj_period_profiles

1768: -- Bug 2589885, 17-MAR-03, jwhite, end: --------------------------
1769:
1770:
1771: SELECT COUNT(*) INTO l_profile_count
1772: FROM pa_proj_period_profiles
1773: WHERE
1774: project_id = p_project_id AND
1775: period_profile_type = 'FINANCIAL_PLANNING' AND
1776: plan_period_type = 'PA';

Line 1781: FROM pa_proj_period_profiles

1777: IF l_profile_count = 0 THEN
1778: l_create_pa_profile := 'Y';
1779: END IF;
1780: SELECT COUNT(*) INTO l_profile_count
1781: FROM pa_proj_period_profiles
1782: WHERE
1783: project_id = p_project_id AND
1784: period_profile_type = 'FINANCIAL_PLANNING' AND
1785: plan_period_type = 'GL';

Line 2086: l_period_profile_id pa_proj_period_profiles.period_profile_id%TYPE;

2082: l_data VARCHAR2(2000);
2083: l_msg_index_out NUMBER;
2084: l_debug_mode VARCHAR2(30);
2085:
2086: l_period_profile_id pa_proj_period_profiles.period_profile_id%TYPE;
2087: l_start_period pa_proj_period_profiles.period_name1%TYPE;
2088: l_end_period pa_proj_period_profiles.profile_end_period_name%TYPE;
2089:
2090: BEGIN

Line 2087: l_start_period pa_proj_period_profiles.period_name1%TYPE;

2083: l_msg_index_out NUMBER;
2084: l_debug_mode VARCHAR2(30);
2085:
2086: l_period_profile_id pa_proj_period_profiles.period_profile_id%TYPE;
2087: l_start_period pa_proj_period_profiles.period_name1%TYPE;
2088: l_end_period pa_proj_period_profiles.profile_end_period_name%TYPE;
2089:
2090: BEGIN
2091:

Line 2088: l_end_period pa_proj_period_profiles.profile_end_period_name%TYPE;

2084: l_debug_mode VARCHAR2(30);
2085:
2086: l_period_profile_id pa_proj_period_profiles.period_profile_id%TYPE;
2087: l_start_period pa_proj_period_profiles.period_name1%TYPE;
2088: l_end_period pa_proj_period_profiles.profile_end_period_name%TYPE;
2089:
2090: BEGIN
2091:
2092: x_msg_count := 0;

Line 2154: FROM pa_proj_period_profiles

2150: ,profile_end_period_name
2151: INTO l_period_profile_id
2152: ,l_start_period
2153: ,l_end_period
2154: FROM pa_proj_period_profiles
2155: WHERE project_id = p_project_id
2156: AND current_flag = 'Y'
2157: AND period_profile_type = p_period_profile_type
2158: AND plan_period_type = p_period_type;

Line 2808: (p_period_profile_id IN pa_proj_period_profiles.period_profile_id%TYPE,

2804: -- 15-JAN-03 dlai: added a couple of flag values:
2805: -- x_cur_period_number = -2, then the current date is BEFORE first period start date
2806: -- x_cur_period_number = -1, then the current date is AFTER last period end date
2807: procedure get_current_period_info
2808: (p_period_profile_id IN pa_proj_period_profiles.period_profile_id%TYPE,
2809: x_cur_period_number OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
2810: x_cur_period_name OUT NOCOPY pa_proj_period_profiles.period_name1%TYPE, --File.Sql.39 bug 4440895
2811: x_cur_period_start_date OUT NOCOPY pa_proj_period_profiles.period1_start_date%TYPE, --File.Sql.39 bug 4440895
2812: x_cur_period_end_date OUT NOCOPY pa_proj_period_profiles.period1_end_date%TYPE, --File.Sql.39 bug 4440895

Line 2810: x_cur_period_name OUT NOCOPY pa_proj_period_profiles.period_name1%TYPE, --File.Sql.39 bug 4440895

2806: -- x_cur_period_number = -1, then the current date is AFTER last period end date
2807: procedure get_current_period_info
2808: (p_period_profile_id IN pa_proj_period_profiles.period_profile_id%TYPE,
2809: x_cur_period_number OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
2810: x_cur_period_name OUT NOCOPY pa_proj_period_profiles.period_name1%TYPE, --File.Sql.39 bug 4440895
2811: x_cur_period_start_date OUT NOCOPY pa_proj_period_profiles.period1_start_date%TYPE, --File.Sql.39 bug 4440895
2812: x_cur_period_end_date OUT NOCOPY pa_proj_period_profiles.period1_end_date%TYPE, --File.Sql.39 bug 4440895
2813: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
2814: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 2811: x_cur_period_start_date OUT NOCOPY pa_proj_period_profiles.period1_start_date%TYPE, --File.Sql.39 bug 4440895

2807: procedure get_current_period_info
2808: (p_period_profile_id IN pa_proj_period_profiles.period_profile_id%TYPE,
2809: x_cur_period_number OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
2810: x_cur_period_name OUT NOCOPY pa_proj_period_profiles.period_name1%TYPE, --File.Sql.39 bug 4440895
2811: x_cur_period_start_date OUT NOCOPY pa_proj_period_profiles.period1_start_date%TYPE, --File.Sql.39 bug 4440895
2812: x_cur_period_end_date OUT NOCOPY pa_proj_period_profiles.period1_end_date%TYPE, --File.Sql.39 bug 4440895
2813: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
2814: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
2815: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 2812: x_cur_period_end_date OUT NOCOPY pa_proj_period_profiles.period1_end_date%TYPE, --File.Sql.39 bug 4440895

2808: (p_period_profile_id IN pa_proj_period_profiles.period_profile_id%TYPE,
2809: x_cur_period_number OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
2810: x_cur_period_name OUT NOCOPY pa_proj_period_profiles.period_name1%TYPE, --File.Sql.39 bug 4440895
2811: x_cur_period_start_date OUT NOCOPY pa_proj_period_profiles.period1_start_date%TYPE, --File.Sql.39 bug 4440895
2812: x_cur_period_end_date OUT NOCOPY pa_proj_period_profiles.period1_end_date%TYPE, --File.Sql.39 bug 4440895
2813: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
2814: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
2815: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
2816: as

Line 2874: from pa_proj_period_profiles

2870: period_name49, period49_start_date, period49_end_date,
2871: period_name50, period50_start_date, period50_end_date,
2872: period_name51, period51_start_date, period51_end_date,
2873: period_name52, period52_start_date, period52_end_date
2874: from pa_proj_period_profiles
2875: where period_profile_id = p_period_profile_id;
2876: period_profile_rec period_profile_csr%ROWTYPE;
2877:
2878: BEGIN