APPS.PA_LIFECYCLES_PUB SQL Statements

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

Line: 287

Select 'Y'
From dual
Where exists(SELECT 'XYZ' from pa_proj_elements
	     WHERE  proj_element_id = P_lifecycle_id
	     AND    object_type='PA_STRUCTURES'
	     AND    project_id=c_project_id);

Line: 296

SELECT project_status_code
from pa_project_statuses
WHERE  project_status_name = P_phase_status_name
AND    status_type = 'PHASE';

Line: 507

PROCEDURE delete_lifecycle (
	P_api_version			IN	NUMBER	  := 1.0			,
	P_init_msg_list			IN	VARCHAR2  := FND_API.G_TRUE  		,
	P_commit			IN	VARCHAR2  := FND_API.G_FALSE 		,
	P_validate_only			IN	VARCHAR2  := FND_API.G_TRUE  		,
	P_validation_level		IN	NUMBER    := FND_API.G_VALID_LEVEL_FULL	,
	P_calling_module		IN	VARCHAR2  := 'SELF-SERVICE'  		,
	P_debug_mode			IN	VARCHAR2  := 'N'	     		,
	P_max_msg_count			IN	NUMBER    := G_MISS_NUM			,
	P_lifecycle_id			IN	NUMBER 	 				,
	p_record_version_number         IN      NUMBER					,
	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_api_name           CONSTANT VARCHAR(30) := 'delete_lifecycle';

Line: 550

Select 'Y'
From dual
Where exists(SELECT 'XYZ' from pa_proj_elements
             WHERE   proj_element_id = P_lifecycle_id
	     AND    object_type= c_object_type
	     AND    project_id=c_project_id
	     );

Line: 560

Select elem.proj_element_id, elem.record_version_number
From pa_proj_element_versions ever
, pa_proj_elements  elem
Where ever.parent_structure_version_id = l_life_elem_ver_id
AND   ever.object_type= 'PA_TASKS'
AND   ever.project_id=c_project_id
AND   ever.proj_element_id = elem.proj_element_id
AND   elem.project_id = c_project_id
AND   elem.object_type = 'PA_TASKS';

Line: 572

Select 	ELEMENT_VERSION_ID
From pa_proj_element_versions
Where 	PROJ_ELEMENT_ID = p_lifecycle_id;

Line: 580

	  pa_debug.debug('PA_LIFECYCLES_PUB.delete_lifecycle : Entered delete_lifecycle...');

Line: 584

		SAVEPOINT LCYL_DELETE_LIFECYCLE_PUB;

Line: 601

	    pa_debug.debug('PA_LIFECYCLES_PUB.delete_lifecycle : Initialising message stack...');

Line: 604

	pa_debug.init_err_stack('PA_LIFECYCLES_PUB.DELETE_LIFECYCLE');

Line: 611

	  pa_debug.debug('PA_LIFECYCLES_PUB.delete_lifecycle :After initialising the stack...');

Line: 630

	select 'Y'
	into l_project_usage_exists
	from SYS.DUAL
	where exists( select 'XYZ' from pa_lifecycle_usages
			where lifecycle_id=P_lifecycle_id  AND
				usage_type=c_project_type);

Line: 643

	select 'Y'
	into l_product_usage_exists
	from SYS.DUAL
	where exists( select 'XYZ' from pa_lifecycle_usages
			where lifecycle_id=P_lifecycle_id  AND
				usage_type=c_product_type);

Line: 655

	        pa_debug.debug('PA_LIFECYCLES_PUB.delete_lifecycle : checking message count');

Line: 681

	  pa_debug.debug('PA_LIFECYCLES_PUB.delete_lifecycle : Before call to private API check_delete_phase_ok');

Line: 686

	pa_lifecycles_pvt.check_delete_lifecycle_ok(
		P_api_version			=> P_api_version	,
		p_calling_module		=> p_calling_module	,
		p_debug_mode			=> p_debug_mode		,
		p_max_msg_count			=> p_max_msg_count	,
		P_lifecycle_id			=> p_lifecycle_id	,
		P_lifecycle_version_id          => l_life_elem_ver_id	,
		X_return_status			=> l_return_status	,
		X_msg_count			=> l_msg_count		,
		X_msg_data			=> l_msg_data		,
		x_del_lifecycle_ok              => l_del_lifecycle_ok
		);

Line: 702

	PA_EGO_WRAPPER_PUB.check_delete_lifecycle_ok(
		p_api_version			=> P_api_version	,
		p_lifecycle_id 			=> p_lifecycle_id	,
		p_init_msg_list			=> p_init_msg_list	,
		x_delete_ok			=> l_del_lifecycle_ok	,
		x_return_status			=> l_return_status	,
		x_errorcode			=> l_errorcode		,
		x_msg_count			=> l_msg_count		,
		x_msg_data			=> l_msg_data
		);

Line: 717

	        pa_debug.debug('PA_LIFECYCLES_PUB.delete_lifecycle : checking message count');

Line: 742

	        pa_debug.debug('PA_LIFECYCLES_PUB.delete_lifecycle : calling pa_lifecycles_pvt.delete_lifecycle_phase for each phase');

Line: 746

     		pa_lifecycles_pub.delete_lifecycle_phase(
			P_api_version			=> P_api_version		,
			p_init_msg_list			=> p_init_msg_list		,
			p_commit			=> p_commit			,
			p_validate_only			=> p_validate_only		,
			p_validation_level		=> p_validation_level		,
			p_calling_module		=> p_calling_module		,
			p_debug_mode			=> p_debug_mode			,
			p_max_msg_count			=> p_max_msg_count		,
			P_lifecycle_id			=> p_lifecycle_id		,
			p_phase_id			=> r.proj_element_id		,
			p_record_version_number         => r.record_version_number	,
			X_return_status			=> l_return_status		,
			X_msg_count			=> l_msg_count			,
			X_msg_data			=> l_msg_data
			);

Line: 766

	        pa_debug.debug('PA_LIFECYCLES_PUB.delete_lifecycle : checking message count');

Line: 789

		PA_EGO_WRAPPER_PUB.delete_stale_data_for_lc(
			p_api_version		=> P_api_version	,
			p_lifecycle_id 		=> p_lifecycle_id	,
			p_init_msg_list		=> p_init_msg_list	,
			p_commit       		=> p_commit		,
			x_errorcode   		=> l_errorcode		,
			x_return_status		=> l_return_status	,
			x_msg_count		=> l_msg_count		,
			x_msg_data		=> l_msg_data);

Line: 800

	  pa_debug.debug('PA_LIFECYCLES_PUB.delete_lifecycle : Before call to private API delete_lifecycle');

Line: 803

	pa_lifecycles_pvt.delete_lifecycle(
	P_api_version			=> P_api_version,
	p_commit			=> p_commit,
	p_validate_only			=> p_validate_only,
	p_validation_level		=> p_validation_level,
	p_calling_module		=> p_calling_module,
	p_debug_mode			=> p_debug_mode,
	p_max_msg_count			=> p_max_msg_count,
	p_lifecycle_id			=> p_lifecycle_id,
	p_record_version_number         => p_record_version_number,
	X_return_status			=> l_return_status,
	X_msg_count			=> l_msg_count,
	X_msg_data			=> l_msg_data
	);

Line: 819

	        pa_debug.debug('PA_LIFECYCLES_PUB.delete_lifecycle : checking message count');

Line: 851

       ROLLBACK TO LCYL_DELETE_LIFECYCLE_PUB;

Line: 855

                            p_procedure_name => 'DELETE_LIFECYCLE',
                            p_error_text     => SUBSTRB(SQLERRM,1,240));

Line: 862

       ROLLBACK TO LCYL_DELETE_LIFECYCLE_PUB;

Line: 868

       ROLLBACK TO LCYL_DELETE_LIFECYCLE_PUB;

Line: 871

                            p_procedure_name => 'DELETE_LIFECYCLE',
                            p_error_text     => SUBSTRB(SQLERRM,1,240));

Line: 874

END delete_lifecycle;

Line: 881

PROCEDURE delete_lifecycle_phase (
	P_api_version			IN	NUMBER	  := 1.0			,
	P_init_msg_list			IN	VARCHAR2  := FND_API.G_TRUE  		,
	P_commit			IN	VARCHAR2  := FND_API.G_FALSE 		,
	P_validate_only			IN	VARCHAR2  := FND_API.G_TRUE  		,
	P_validation_level		IN	NUMBER    := FND_API.G_VALID_LEVEL_FULL	,
	P_calling_module		IN	VARCHAR2  := 'SELF-SERVICE'  		,
	P_debug_mode			IN	VARCHAR2  := 'N'	     		,
	P_max_msg_count			IN	NUMBER    := G_MISS_NUM			,
	P_lifecycle_id                  IN      NUMBER					,
	P_phase_id			IN	NUMBER 	 				,
	p_record_version_number         IN      NUMBER					,
	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_api_name           CONSTANT VARCHAR(30) := 'delete_lifecycle_phase';

Line: 923

Select 'Y'
From dual
Where exists(
        Select 'XYZ'
	from pa_proj_element_versions child
	 , pa_proj_element_versions parent
	where child.proj_element_id = P_phase_id
	and child.parent_structure_version_id = parent.element_version_id
	and parent.proj_element_id = P_lifecycle_id
	AND child.object_type= c_object_type
	AND child.project_id=c_project_id
	and parent.object_type = 'PA_STRUCTURES'
	and parent.project_id = c_project_id);

Line: 941

	  pa_debug.debug('PA_LIFECYCLES_PUB.delete_lifecycle_phase : Entered delete_lifecycle_phase...');

Line: 945

		SAVEPOINT LCYL_DELETE_LCYL_PHASE_PUB;

Line: 962

	    pa_debug.debug('PA_LIFECYCLES_PUB.delete_lifecycle_phase : Initialising message stack...');

Line: 965

	pa_debug.init_err_stack('PA_LIFECYCLES_PUB.DELETE_LIFECYCLE_PHASE');

Line: 972

	  pa_debug.debug('PA_LIFECYCLES_PUB.delete_lifecycle_phase :After initialising the stack...');

Line: 978

	   Select 'Y' into l_phase_exists
	   From dual
           Where exists(
	   Select 'XYZ' from pa_proj_element_versions child
	 , pa_proj_element_versions parent
	where child.proj_element_id = P_phase_id
	and child.parent_structure_version_id = parent.element_version_id
	and parent.proj_element_id = P_lifecycle_id
	AND child.object_type= c_object_type
	AND child.project_id=c_project_id
	and parent.object_type = 'PA_STRUCTURES'
	and parent.project_id = c_project_id);

Line: 1005

	select 'Y'
	into l_project_usage_exists
	from SYS.DUAL
	where exists( select 'XYZ' from pa_lifecycle_usages
			where lifecycle_id=P_lifecycle_id  AND
				usage_type=c_project_type);

Line: 1018

	select 'Y'
	into l_product_usage_exists
	from SYS.DUAL
	where exists(select 'XYZ' from pa_lifecycle_usages
			where lifecycle_id=P_lifecycle_id  AND
				usage_type=c_product_type);

Line: 1030

	        pa_debug.debug('PA_LIFECYCLES_PUB.delete_lifecycle_phase: checking message count');

Line: 1053

	  pa_debug.debug('PA_LIFECYCLES_PUB.delete_lifecycle : Before call to private API check_delete_lcyl_phase_ok');

Line: 1056

	pa_lifecycles_pvt.check_delete_lcyl_phase_ok(
		P_api_version			=> P_api_version	,
		p_calling_module		=> p_calling_module	,
		p_debug_mode			=> p_debug_mode		,
		p_max_msg_count			=> p_max_msg_count	,
		P_lifecycle_id			=> P_lifecycle_id       ,
		P_lifecycle_phase_id		=> p_phase_id		,
		X_return_status			=> l_return_status	,
		X_msg_count			=> l_msg_count		,
		X_msg_data			=> l_msg_data		,
		x_delete_ok	                => l_del_phase_ok
		);

Line: 1074

	  pa_debug.debug('PA_EGO_WRAPPER_PUB.check_delete_phase_ok  : Before call to private API check_delete_lcyl_phase_ok');

Line: 1077

	PA_EGO_WRAPPER_PUB.check_delete_phase_ok (
		p_api_version			=> P_api_version	,
		p_phase_id 			=> p_phase_id		,
		p_init_msg_list			=> p_init_msg_list	,
		x_delete_ok			=> l_del_phase_ok	,
		x_return_status			=> l_return_status	,
		x_errorcode			=> l_errorcode		,
		x_msg_count			=> l_msg_count		,
		x_msg_data			=> l_msg_data
		);

Line: 1091

	        pa_debug.debug('PA_LIFECYCLES_PUB.delete_lifecycle : checking message count');

Line: 1117

		PA_EGO_WRAPPER_PUB.process_phase_delete(
			p_api_version			=> P_api_version		,
			p_phase_id			=> p_phase_id			,
			p_init_msg_list                 => p_init_msg_list		,
			p_commit       	                => p_commit			,
			x_errorcode			=> l_errorcode			,
			x_return_status			=> l_return_status		,
			x_msg_count			=> l_msg_count			,
			x_msg_data			=> l_msg_data);

Line: 1129

	        pa_debug.debug('PA_LIFECYCLES_PUB.delete_lifecycle_phase : calling pa_lifecycles_pvt.delete_lifecycle_phase for each phase');

Line: 1133

      pa_lifecycles_pvt.delete_lifecycle_phase(
			P_api_version			=> P_api_version		,
			p_commit			=> p_commit			,
			p_validate_only			=> p_validate_only		,
			p_validation_level		=> p_validation_level		,
			p_calling_module		=> p_calling_module		,
			p_debug_mode			=> p_debug_mode			,
			p_max_msg_count			=> p_max_msg_count		,
			p_phase_id			=> p_phase_id			,
			p_record_version_number         => p_record_version_number	,
			X_return_status			=> l_return_status		,
			X_msg_count			=> l_msg_count			,
			X_msg_data			=> l_msg_data
			);

Line: 1149

	        pa_debug.debug('PA_LIFECYCLES_PUB.delete_lifecycle_phase : checking message count');

Line: 1181

       ROLLBACK TO LCYL_DELETE_LCYL_PHASE_PUB;

Line: 1185

                            p_procedure_name => 'DELETE_LIFECYCLE_PHASE',
                            p_error_text     => SUBSTRB(SQLERRM,1,240));

Line: 1192

       ROLLBACK TO LCYL_DELETE_LCYL_PHASE_PUB;

Line: 1198

       ROLLBACK TO LCYL_DELETE_LCYL_PHASE_PUB;

Line: 1201

                            p_procedure_name => 'DELETE_LIFECYCLE_PHASE',
                            p_error_text     => SUBSTRB(SQLERRM,1,240));

Line: 1205

END delete_lifecycle_phase;

Line: 1212

PROCEDURE update_lifecycle (
	P_api_version			IN	NUMBER   :=1.0					,
	p_init_msg_list			IN	VARCHAR2 := FND_API.G_TRUE			,
	p_commit			IN	VARCHAR2 :=FND_API.G_FALSE			,
	p_validate_only			IN	VARCHAR2 :=FND_API.G_TRUE			,
	p_validation_level		IN	NUMBER   :=FND_API.G_VALID_LEVEL_FULL		,
	p_calling_module		IN	VARCHAR2 :='SELF SERVICE'			,
	p_debug_mode			IN	VARCHAR2 :='N'					,
	p_max_msg_count			IN	NUMBER   :=G_MISS_NUM				,
	P_lifecycle_id			IN	NUMBER	 					,
	P_lifecycle_short_name	 	IN	VARCHAR2 :=G_MISS_CHAR				,
	P_lifecycle_name		IN	VARCHAR2 :=G_MISS_CHAR				,
	P_lifecycle_description		IN	VARCHAR2 :=G_MISS_CHAR				,
	P_lifecycle_project_usage_type	IN	VARCHAR2 :=G_MISS_CHAR				,
	P_lifecycle_product_usage_type	IN	VARCHAR2 :=G_MISS_CHAR				,
	P_record_version_number		IN	NUMBER						,
	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_api_name           CONSTANT		VARCHAR(30) := 'update_lifecycle';

Line: 1257

	  pa_debug.debug('PA_LIFECYCLES_PUB.update_lifecycle : Entered update_lifecycle...');

Line: 1261

		SAVEPOINT LCYL_UPDATE_LIFECYCLE_PUB;

Line: 1265

  	  pa_debug.debug('PA_LIFECYCLES_PUB.Update_Lifecycle: Checking api compatibility...');

Line: 1284

	    pa_debug.debug('PA_LIFECYCLES_PUB.update_lifecycle : Initialising message stack...');

Line: 1287

	pa_debug.init_err_stack('PA_LIFECYCLES_PUB.UPDATE_LIFECYCLE');

Line: 1296

	  pa_debug.debug('PA_LIFECYCLES_PUB.Update_Lifecycle:After initialising the stack..getting the data from database.');

Line: 1302

	  select name,element_number,description
	  into l_lcyl_name,l_short_name,l_lifecycle_description
	  from pa_proj_elements
	  where proj_element_id=l_lifecycle_id
	  AND object_type = c_object_type
	  AND project_id = c_project_id;

Line: 1317

	  pa_debug.debug('PA_LIFECYCLES_PUB.Update_Lifecycle:Checking for null values assigning the updated values');

Line: 1346

	  	  pa_debug.debug('PA_LIFECYCLES_PVT.Update_Lifecycle: Checking for existing parameters for  uniqueness..');

Line: 1351

			  Select 'N'
			  Into l_shname_uniq
			  from SYS.DUAL
			  Where exists(Select 'XYZ' from pa_proj_elements
				where element_number = P_lifecycle_short_name
				AND object_type=c_object_type
				AND project_id = c_project_id);

Line: 1389

	        pa_debug.debug('PA_LIFECYCLES_PUB.update_lifecycle : checking message count'||FND_MSG_PUB.count_msg);

Line: 1394

	  pa_debug.debug('PA_LIFECYCLES_PUB.update_lifecycle : Before call to private API');

Line: 1408

		select 'Y'
		into l_lifecycle_project_usage_type
		from SYS.DUAL
		where exists ( select '1' from pa_lifecycle_usages
					where lifecycle_id=l_lifecycle_id
					AND   usage_type='PROJECTS');

Line: 1427

		select 'Y'
		into l_lifecycle_product_usage_type
		from SYS.DUAL
		where exists ( select '1' from pa_lifecycle_usages
				       where lifecycle_id=l_lifecycle_id
				       AND   usage_type='PRODUCTS');

Line: 1457

                                 p_msg_name       => 'PA_NO_CHANGES_TO_UPDATE');

Line: 1458

            x_msg_data := 'PA_NO_CHANGES_TO_UPDATE';

Line: 1464

	  pa_debug.debug('PA_LIFECYCLES_PUB.Update_Lifecycle:After checking for null values  assigning the updated values');

Line: 1468

	        pa_debug.debug('PA_LIFECYCLES_PUB.Update_Lifecycle: checking message count');

Line: 1490

	  pa_debug.debug('PA_LIFECYCLES_PUB.Update_Lifecycle: Before call to private update  API');

Line: 1493

	pa_lifecycles_pvt.update_lifecycle (
			P_api_version			=> P_api_version			,
			p_commit			=> p_commit				,
			p_validate_only			=> p_validate_only			,
			p_validation_level		=> p_validation_level			,
			p_calling_module		=> p_calling_module			,
			p_debug_mode			=> p_debug_mode				,
			p_max_msg_count			=> p_max_msg_count			,
			p_lifecycle_id			=> l_lifecycle_id			,
			P_lifecycle_short_name 		=> l_short_name				,
			P_lifecycle_name		=> l_lcyl_name				,
			P_lifecycle_description	        => l_lifecycle_description		,
			P_lifecycle_project_usage_type	=> l_lifecycle_project_usage_type	,
			P_lifecycle_product_usage_type	=> l_lifecycle_product_usage_type	,
			P_record_version_number		=> p_record_version_number			,
			X_return_status			=> l_return_status			,
			X_msg_count			=> l_msg_count				,
			X_msg_data			=> l_msg_data
			);

Line: 1515

	        pa_debug.debug('PA_LIFECYCLES_PUB.update_lifecycle : checking message count After call to private update API');

Line: 1519

	        pa_debug.debug('PA_LIFECYCLES_PUB.Update_Lifecycle: checking message count');

Line: 1552

       ROLLBACK TO LCYL_UPDATE_LIFECYCLE_PUB;

Line: 1556

                            p_procedure_name => 'UPDATE_LIFECYCLE',
                            p_error_text     => SUBSTRB(SQLERRM,1,240));

Line: 1563

       ROLLBACK TO LCYL_UPDATE_LIFECYCLE_PUB;

Line: 1569

       ROLLBACK TO LCYL_UPDATE_LIFECYCLE_PUB;

Line: 1572

                            p_procedure_name => 'UPDATE_LIFECYCLE',
                            p_error_text     => SUBSTRB(SQLERRM,1,240));

Line: 1576

END update_lifecycle;

Line: 1584

PROCEDURE update_lifecycle_phase (
	P_api_version			IN	NUMBER   :=1.0					,
	p_init_msg_list			IN	VARCHAR2 :=FND_API.G_TRUE			,
	p_commit			IN	VARCHAR2 :=FND_API.G_FALSE			,
	p_validate_only			IN	VARCHAR2 :=FND_API.G_TRUE			,
	p_validation_level		IN	NUMBER   :=FND_API.G_VALID_LEVEL_FULL		,
	p_calling_module		IN	VARCHAR2 :='SELF SERVICE'			,
	p_debug_mode			IN	VARCHAR2 :='N'					,
	P_max_msg_count			IN	NUMBER   :=G_MISS_NUM				,
	P_lifecycle_id			IN	NUMBER						,
	P_lifecycle_phase_id		IN	NUMBER						,
	P_phase_status_name		IN	VARCHAR2 :=G_MISS_CHAR		   		,
	P_phase_short_name		IN	VARCHAR2 :=G_MISS_CHAR				,
	P_phase_name			IN	VARCHAR2 :=G_MISS_CHAR				,
	P_phase_display_sequence	IN	NUMBER   :=G_MISS_NUM				,
	P_phase_description		IN	VARCHAR2 :=G_MISS_CHAR				,
	P_record_version_number		IN	NUMBER						,
	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_api_name		CONSTANT	VARCHAR(30) := 'update_lifecycle_phase';

Line: 1625

	l_update_ok                             VARCHAR2(1) := FND_API.G_FALSE;

Line: 1631

SELECT project_status_code
from pa_project_statuses
WHERE  project_status_name = P_phase_status_name
AND    status_type = 'PHASE';

Line: 1638

	/* Note that check for duplicate shortname and sequence can not be done here. as user may want to update
	   two records at the same time, swapping the values */

	IF(p_debug_mode = 'Y') then
	  pa_debug.debug('PA_LIFECYCLES_PUB.update_lifecycle_phase : Entered update_lifecycle_phase...');

Line: 1650

  	  pa_debug.debug('PA_LIFECYCLES_PUB.Update_Lifecycle_phases: Checking api compatibility...');

Line: 1668

	    pa_debug.debug('PA_LIFECYCLES_PUB.update_lifecycle_phase : Initialising message stack...');

Line: 1671

	pa_debug.init_err_stack('PA_LIFECYCLES_PUB.UPDATE_LIFECYCLE_PHASE');

Line: 1678

	  pa_debug.debug('PA_LIFECYCLES_PUB.update_lifecycle_phase :After initialising the stack..and getting the old data from database.');

Line: 1682

	  select prj.name,prj.element_number,prj.description,prj.phase_code,elem.display_sequence
	  into l_phase_name,l_phase_short_name,l_phase_description,l_phase_code,l_seqn
	  from pa_proj_elements prj
	  , pa_proj_element_versions elem
	  where prj.proj_element_id=P_lifecycle_phase_id
	  and prj.project_id=c_project_id
	  and prj.object_type=c_object_type
	  and prj.proj_element_id=elem.proj_element_id;

Line: 1704

	  pa_debug.debug('PA_LIFECYCLES_PUB.Update_lifecycle_phase:Checking for null values  assigning the updated values');

Line: 1782

	  pa_debug.debug('PA_LIFECYCLES_PUB.Update_lifecycle_phase:After checking for null values  assigning the updated values');

Line: 1788

                                 p_msg_name       => 'PA_NO_CHANGES_TO_UPDATE');

Line: 1789

            x_msg_data := 'PA_NO_CHANGES_TO_UPDATE';

Line: 1795

	        pa_debug.debug('PA_LIFECYCLES_PUB.Update_lifecycle_phase: checking message count');

Line: 1819

	        pa_debug.debug('PA_LIFECYCLES_PUB.Update_lifecycle_phase: Calling private api check_delete_lcyl_phase_ok');

Line: 1822

	    pa_lifecycles_pvt.check_delete_lcyl_phase_ok(
			P_api_version			=>l_api_version			,
			p_calling_module		=>p_calling_module		,
			p_debug_mode			=>p_debug_mode			,
			P_max_msg_count			=>P_max_msg_count		,
			P_lifecycle_id			=>P_lifecycle_id		,
			P_lifecycle_phase_id		=>P_lifecycle_phase_id		,
			x_delete_ok			=>l_update_ok			,
			x_return_status			=>l_return_status		,
			x_msg_count			=>l_msg_count			,
			X_msg_data			=>l_data
			);

Line: 1837

	        pa_debug.debug('PA_LIFECYCLES_PUB.Update_lifecycle_phase: checking message count');

Line: 1854

	    IF (l_update_ok <>FND_API.G_TRUE) THEN
		RAISE  FND_API.G_EXC_ERROR;

Line: 1862

	  pa_debug.debug('PA_LIFECYCLES_PUB.update_lifecycle_phase : Before call to private API update_lifecycle_phase');

Line: 1865

	pa_lifecycles_pvt.update_lifecycle_phase (
		P_api_version			=>1.0				,
		p_commit			=>p_commit			,
		p_validate_only			=>p_validate_only		,
		p_validation_level		=>p_validation_level		,
		p_calling_module		=>p_calling_module		,
		p_debug_mode			=>p_debug_mode			,
		P_max_msg_count			=>P_max_msg_count		,
		P_lifecycle_id			=> P_lifecycle_id		,
		P_lifecycle_phase_id		=>P_lifecycle_phase_id		,
		P_phase_display_sequence	=>l_seqn			,
		P_phase_code			=>l_phase_code			,
		P_phase_short_name		=>l_phase_short_name		,
		P_phase_name			=>l_phase_name			,
		P_phase_description		=>l_phase_description		,
		P_record_version_number         =>P_record_version_number	,
		x_return_status		        =>l_return_status		,
		x_msg_count			=>l_msg_count			,
		X_msg_data			=>l_data
		);

Line: 1887

	        pa_debug.debug('PA_LIFECYCLES_PUB.update_lifecycle_phase : checking message count after call to private API update_lifecycle_phase');

Line: 1923

	                        p_procedure_name => 'UPDATE_LIFECYCLE_PHASE',
	                       p_error_text     => SUBSTRB(SQLERRM,1,240));

Line: 1939

	                      p_procedure_name => 'UPDATE_LIFECYCLE_PHASE',
		                    p_error_text     => SUBSTRB(SQLERRM,1,240));

Line: 1943

END update_lifecycle_phase;