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),
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,
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';
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