APPS.PA_PROGRESS_REPORT_UTILS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 28

select (MAX(Report_End_Date))
FROM PA_PROGRESS_REPORT_VERS
WHERE Object_Id = P_Object_Id
AND Object_Type = P_Object_Type
AND Report_Status_Code = decode(Publish_Report_Flag,'Y','PROGRESS_REPORT_PUBLISHED',Report_Status_Code);

Line: 35

select (MAX(Report_End_Date))
FROM PA_PROGRESS_REPORT_VERS
WHERE Object_Id = P_Object_Id
AND Object_Type = P_Object_Type
AND report_type_id = p_report_type_id
AND Report_Status_Code = decode(Publish_Report_Flag,'Y','PROGRESS_REPORT_PUBLISHED',Report_Status_Code);

Line: 43

select NVL(Start_date, Creation_date)
INTO l_Project_Start_Date
FROM PA_PROJECTS_ALL
WHERE Project_Id = Object_Id;

Line: 111

   Select project_system_status_code
   from pa_project_statuses
   where project_status_code = p_current_rep_status;

Line: 117

   Select nvl(approval_required,'N') approval_required
         -- ,nvl(auto_publish,'N') auto_publish
   from pa_object_page_layouts pop
        ,pa_progress_report_vers prv
   where pop.object_type = prv.object_type
   and   pop.object_id = prv.object_id
   and   pop.report_type_id = prv.report_type_id ---report_type_id will be there for PPR
   and   pop.page_type_code = prv.page_type_code
   and   prv.version_id = p_version_id;

Line: 316

      is select page_type_code
      from pa_object_page_layouts
      where page_id = p_page_id;

Line: 322

	   SELECT page_type_code
	     FROM pa_page_layouts
	     WHERE page_id = p_page_id;

Line: 326

      CURSOR check_update_report_ok
	IS SELECT 'N' FROM
	  dual
	  WHERE exists
	  (SELECT * FROM
	   pa_progress_report_vers
	   WHERE page_id = p_page_id
	   AND (report_status_code = 'PROGRESS_REPORT_PUBLISHED' OR
		report_status_code = 'PROGRESS_REPORT_SUBMITTED' OR
		report_status_code = 'PROGRESS_REPORT_APPROVED'));

Line: 338

      l_ok_to_delete      VARCHAR2(1):= 'Y';

Line: 353

     l_ok_to_delete := 'N';

Line: 364

          l_ok_to_delete := 'Y';

Line: 366

         OPEN check_update_report_ok;

Line: 367

         FETCH check_update_report_ok INTO l_dummy;

Line: 368

         IF (check_update_report_ok%found) THEN
           l_ok_to_delete := 'N';

Line: 371

         CLOSE check_update_report_ok;

Line: 383

       l_ok_to_delete := 'N';

Line: 396

	 l_ok_to_delete := 'N';

Line: 401

   IF (l_ok_to_delete = 'N') then
     PA_UTILS.Add_Message( p_app_short_name => 'PA'
   		          ,p_msg_name       => 'PA_EDIT_TEMPLATE_INV');

Line: 420

PROCEDURE update_perccomplete
  (
   p_object_id  NUMBER,
   p_object_type VARCHAR2,
   p_percent_complete NUMBER,
   p_asof_date   DATE,

   x_return_status               OUT    NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
   x_msg_count                   OUT    NOCOPY NUMBER, --File.Sql.39 bug 4440895
   x_msg_data                    OUT    NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
   ) IS

      l_project_id NUMBER;

Line: 436

	 SELECT project_id FROM pa_tasks
	   WHERE task_id = l_task_id;

Line: 441

  PA_DEBUG.init_err_stack('PA_PROGRESS_REPORT_UTILS.update_perccomplete');

Line: 446

  SAVEPOINT update_perccomplete;

Line: 477

       pa_percent_complete_pkg.insert_row
       (
	l_project_id,
	l_task_id,
	p_percent_complete,
	p_asof_date,
	NULL,
	Sysdate,
	fnd_global.user_id,
	Sysdate,
	fnd_global.user_id,
	fnd_global.user_id,
	x_return_status,
	x_msg_data
	 );

Line: 498

     ROLLBACK TO update_perccomplete;

Line: 504

       ROLLBACK TO update_perccomplete;

Line: 508

       FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_Progress_Report_Utils.update_perccomplete'
                                 ,p_procedure_name => PA_DEBUG.G_Err_Stack );

Line: 515

END update_perccomplete;

Line: 527

       IS SELECT 'Y'
	 FROM dual
	 WHERE exists(
		      SELECT version_id
		      FROM pa_progress_report_vers
		      WHERE object_id = p_object_id
		      AND object_type = p_object_type
		      );

Line: 561

       IS SELECT 'Y'
	 FROM dual
	 WHERE exists(
		      SELECT page_id
		      FROM pa_object_page_layouts
		      WHERE object_id = p_object_id
		      AND object_type = p_object_type
		      );

Line: 571

       IS SELECT 'Y'
	 FROM dual
	 WHERE exists(
		      SELECT placeholder_reg_code
		      FROM pa_object_regions
		      WHERE object_id = p_object_id
		      AND object_type = p_object_type
		      		      );

Line: 622

   pa_progress_report_pkg.delete_object_page_layouts
     (
      p_object_id,
      p_object_type,

      x_return_status,
      x_msg_count,
      x_msg_data
      );

Line: 684

  select page_id from pa_object_page_layouts
  where page_type_code = p_page_type_code
  and   object_type = p_object_type
  and   object_id = p_object_id;

Line: 691

  select page_id from pa_object_page_layouts
  where object_id = p_object_id
  and   object_type = p_object_type
  and   report_type_id = p_report_Type_id
  and   page_type_code = p_page_type_code;

Line: 699

   select to_number(attribute3)
   from pa_lookups
   where lookup_type = 'PA_PAGE_TYPES'
     and lookup_code = p_page_type_code;

Line: 705

     select task_progress_entry_page_id
    from pa_proj_elements ppe
    where ppe.proj_element_id = p_object_id
       and ppe.object_type = 'PA_TASKS';

Line: 711

     select ptt.task_progress_entry_page_id
      from  pa_proj_elements ppe,
            pa_task_types ptt
      where ppe.type_id = ptt.task_type_id
        and ppe.proj_element_id = p_object_id
        and ppe.object_type = 'PA_TASKS';

Line: 765

	       select substr(l_page_id_tmp,1,4) into l_model from dual;

Line: 767

		select substr(l_page_id_tmp,6) into l_page_id_s from dual;

Line: 817

 select replacement_reg_code
 from pa_object_regions
 where object_type = p_object_type
 and object_id = p_object_id
 and placeholder_reg_code = p_placeholder_reg_code;

Line: 836

 FUNCTION is_delete_page_layout_ok(
				   p_page_type_code IN varchar2,
				   p_object_type    IN varchar2,
				   p_object_id      IN NUMBER,
                                   p_report_type_id IN NUMBER
				   )
   RETURN VARCHAR2 is

      -- can not delere the ppr pagelayout when there is any report
      -- which is not published nor cancelled

      CURSOR get_ppr_pagelayout_delete_ok IS
	 select 'N'
	   from dual
	   where exists
	   (
	    select version_id
	    FROM PA_PROGRESS_REPORT_VERS
	    WHERE Object_Id = p_object_id
	    AND Object_Type = p_object_type
            AND report_Type_id = p_report_Type_id ); --- report_Type_id will be there

Line: 863

       OPEN get_ppr_pagelayout_delete_ok;

Line: 864

       FETCH get_ppr_pagelayout_delete_ok INTO l_return;

Line: 866

       IF get_ppr_pagelayout_delete_ok%notfound THEN
	  l_return := 'Y';

Line: 870

       CLOSE get_ppr_pagelayout_delete_ok;

Line: 876

 END is_delete_page_layout_ok;

Line: 890

         select 'N'
           from dual
           where exists
           (
            select version_id
            FROM PA_PROGRESS_REPORT_VERS
            WHERE Object_Id = p_object_id
            AND Object_Type = p_object_type
            AND report_Type_id = p_report_Type_id
            AND Report_Status_Code <> 'PROGRESS_REPORT_PUBLISHED'
            and Report_Status_Code <> 'PROGRESS_REPORT_CANCELED');

Line: 960

   select object_page_layout_id
     into l_object_page_layout_id
     from pa_object_page_layouts
    where object_id = p_object_id and
          object_type = p_object_type and
          report_Type_id = p_report_Type_id;

Line: 995

  select object_page_layout_id
    into l_object_page_layout_id
    from pa_object_page_layouts
   where object_id = p_object_id and
         object_type = p_object_type and
         report_Type_id = p_report_Type_id;

Line: 1092

Function is_cycle_ok_to_delete(p_reporting_cycle_id  IN  NUMBER) return varchar2
IS
   cursor rep_cycle is
   select 'N'
    from pa_object_page_layouts
   where reporting_cycle_id = p_reporting_cycle_id;

Line: 1112

End is_cycle_ok_to_delete;

Line: 1119

  select version_id
    into l_version_id
    from pa_progress_report_vers
   where object_id = p_object_id
     and object_Type = p_object_Type
     and report_Type_id = p_report_Type_id
     and report_status_code = 'PROGRESS_REPORT_WORKING'
     and (report_end_date, last_update_date) = (select max(report_end_Date), max(last_update_date)
                              from pa_progress_report_vers
                             where object_id = p_object_id
                               and object_Type = p_object_Type
                               and report_Type_id = p_report_Type_id
                               and report_status_code = 'PROGRESS_REPORT_WORKING');

Line: 1143

  SELECT menu_name
  INTO l_menu_name
  FROM fnd_menus m, pa_object_page_layouts o
  WHERE m.menu_id=o.page_id
    AND o.page_type_code='TAB_MENU'
    AND o.object_type='PA_PROJECTS'
    AND o.object_id=p_project_id;