[Home] [Help]
765: IF p_plan_period_type = 'GL' THEN
766: BEGIN
767: SELECT TO_CHAR(gl.start_date,'rrrr/mm/dd'),
768: TO_CHAR(gl.end_date,'rrrr/mm/dd') INTO l_start_date,l_end_Date FROM
769: Gl_Periods gl, Pa_Implementations_All imp ,Pa_Projects_All p ,
770: Gl_Sets_Of_Books sob WHERE
771: p.Project_Id = p_project_id AND
772: nvl(p.Org_Id,-99) = NVL(imp.Org_Id,-99) AND
773: imp.Set_Of_Books_Id = sob.Set_Of_Books_Id AND
782: ELSIF p_plan_period_type = 'PA' THEN
783: BEGIN
784: SELECT TO_CHAR(gl.start_date,'rrrr/mm/dd'),
785: TO_CHAR(gl.end_date,'rrrr/mm/dd') INTO l_start_date,l_end_Date FROM
786: Gl_Periods gl, Pa_Implementations_All imp ,Pa_Projects_All p WHERE
787: p.Project_Id = p_project_id AND
788: nvl(p.Org_Id,-99) = nvl(imp.Org_Id,-99) AND
789: gl.Period_Set_Name = imp.Period_Set_Name AND
790: gl.Period_Type = imp.Pa_Period_Type AND
1004: sob.Accounted_Period_Type INTO
1005: l_pa_period_type,
1006: l_gl_period_set_name,
1007: l_gl_period_type FROM
1008: Pa_Implementations_All imp ,Pa_Projects_All p ,
1009: Gl_Sets_Of_Books sob WHERE
1010: p.Project_Id = p_project_id AND
1011: nvl(p.Org_Id,-99) = NVL(imp.Org_Id,-99) AND
1012: imp.Set_Of_Books_id = sob.Set_Of_Books_Id;
1170: SELECT start_Date
1171: , completion_date
1172: INTO l_prj_start_date
1173: , l_prj_completion_date
1174: FROM Pa_Projects_All
1175: WHERE Project_Id = p_project_id;
1176:
1177:
1178: -- PA Period Validation
1797:
1798: SELECT start_Date, completion_date, nvl(org_id,-99)
1799: INTO
1800: l_prj_start_date,l_prj_completion_date,l_prj_org_id FROM
1801: Pa_Projects_All WHERE
1802: Project_Id = p_project_id;
1803:
1804: EXCEPTION
1805: WHEN NO_DATA_FOUND THEN
1823: ,l_prj_completion_date
1824: ,l_prj_org_id
1825: ,x_prj_start_date
1826: ,x_prj_end_date
1827: FROM Pa_Projects_All
1828: WHERE Project_Id = p_project_id;
1829:
1830: EXCEPTION
1831: WHEN NO_DATA_FOUND THEN