APPS.PA_PROJECT_STUS_UTILS dependencies on DUAL

Line 529: From dual

525: END IF;
526: begin
527: /*Select 'PA_STATUS_CHECK_PRJSTRT','N'
528: Into x_err_stage,x_allow_deletion_flag
529: From dual
530: Where exists
531: (select '1'
532: from PA_PROJECT_TYPES_ALL T
533: where T.def_start_proj_status_code=p_project_status_code);*/

Line 546: From dual

542: -- Second check if it is a status in use in Projects
543: begin
544: Select 'PA_STATUS_CHECK_PRJUSED','N'
545: Into x_err_stage,x_allow_deletion_flag
546: From dual
547: Where exists
548: (select '1'
549: from PA_PROJECTS_ALL P
550: where P.project_status_code=p_project_status_code);

Line 596: From dual

592: -- Third check if it is a pre-defined status
593: begin
594: Select 'PA_STATUS_CHECK_PRE_DEF','N'
595: Into x_err_stage,x_allow_deletion_flag
596: From dual
597: Where exists
598: (select '1'
599: from PA_PROJECT_STATUSES S
600: where S.project_status_code=p_project_status_code

Line 613: From dual

609: -- Fourth check if it is a next allowable status
610: begin
611: Select 'PA_STATUS_CHECK_NEXT','N'
612: Into x_err_stage,x_allow_deletion_flag
613: From dual
614: Where exists
615: (select '1'
616: from PA_NEXT_ALLOW_STATUSES N
617: where N.next_allowable_status_code=p_project_status_code);

Line 629: From dual

625: -- Fifth check if it is a workflow status
626: begin
627: Select 'PA_STATUS_CHECK_WF_USED','N'
628: Into x_err_stage,x_allow_deletion_flag
629: From dual
630: Where exists
631: (select '1'
632: from PA_PROJECT_STATUSES S
633: where S.wf_success_status_code=p_project_status_code

Line 714: From dual

710: From PA_PROJECT_STATUSES
711: Where PROJECT_SYSTEM_STATUS_CODE=c_rec.NEXT_ALLOWABLE_STATUS_CODE
712: and PROJECT_STATUS_CODE=n_status_code;
713: */
714: From dual
715: Where exists(
716: select 'x'
717: from PA_PROJECT_STATUSES
718: where PROJECT_SYSTEM_STATUS_CODE=c_rec.NEXT_ALLOWABLE_STATUS_CODE

Line 905: From dual

901: BEGIN
902: -- checking whether the phase to be deleted has been used by a lifecycle
903: Select 'PA_PHASE_LIFECYCLE_USED','N'
904: Into x_err_stage,x_allow_deletion_flag
905: From dual
906: Where exists(Select 'XYZ' from pa_proj_elements
907: where project_id= 0 and object_type = 'PA_TASKS'
908: and phase_code= p_project_status_code);
909: -- check for PLM needs to be added

Line 1032: FROM dual

1028: BEGIN
1029:
1030: SELECT 'Y'
1031: INTO l_dummy
1032: FROM dual
1033: WHERE EXISTS
1034: (SELECT '1'
1035: FROM pa_project_types_all t
1036: WHERE t.def_start_proj_status_code=p_project_status_code