eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_EGO_WRAPPER_PUB SQL Statements

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

Line: 11


PROCEDURE check_delete_phase_ok(
	p_api_version			IN	NUMBER   :=1.0			,
	p_phase_id 			IN	NUMBER				,
	p_init_msg_list			IN	VARCHAR2 := NULL		,
	x_delete_ok			OUT	NOCOPY VARCHAR2			, -- NOCOPY change for Bug 4939368
	x_return_status			OUT	NOCOPY VARCHAR2			, -- NOCOPY change for Bug 4939368
	x_errorcode			OUT	NOCOPY NUMBER				, -- NOCOPY change for Bug 4939368
	x_msg_count			OUT	NOCOPY NUMBER				, -- NOCOPY change for Bug 4939368
	x_msg_data			OUT	NOCOPY VARCHAR2  -- NOCOPY change for Bug 4939368
	)
IS
	l_api_name	     CONSTANT VARCHAR(30) := 'check_delete_phase_ok';

Line: 32


        l_delete_ok                   VARCHAR2(1);

Line: 44


	x_delete_ok     := FND_API.G_FALSE;

Line: 46


	EGO_LIFECYCLE_ADMIN_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_delete_ok		,
		x_return_status		=> l_return_status	,
		x_errorcode		=> l_errorcode		,
		x_msg_count		=> l_msg_count		,
		x_msg_data		=> l_msg_data );

Line: 56


/* Bug 2760719 -- Added check for l_delete_ok  <> FND_API.G_TRUE and moved raise statement
                  outside the IF l_msg_count > 0 */

	IF l_delete_ok  <> FND_API.G_TRUE OR l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
		l_msg_count := FND_MSG_PUB.count_msg;

Line: 79


x_delete_ok          := l_delete_ok;

Line: 86


    x_delete_ok     := FND_API.G_FALSE;            -- NOCOPY change for Bug 4939368

Line: 91


                            p_procedure_name => 'check_delete_phase_ok',
                            p_error_text     => x_msg_data);

Line: 96


    x_delete_ok     := FND_API.G_FALSE;            -- NOCOPY change for Bug 4939368

Line: 101


                            p_procedure_name => 'check_delete_phase_ok',
                            p_error_text     => x_msg_data); -- NOCOPY change for Bug 4939368

Line: 107


    x_delete_ok     := FND_API.G_FALSE;            -- NOCOPY change for Bug 4939368

Line: 112


                            p_procedure_name => 'check_delete_phase_ok',
                            p_error_text     => x_msg_data);

Line: 115


END check_delete_phase_ok;

Line: 121


PROCEDURE process_phase_delete(
	p_api_version	IN	NUMBER	:= 1.0		,
	p_phase_id 	IN	NUMBER			,
	p_init_msg_list	IN	VARCHAR2 := NULL	,
	p_commit       	IN	VARCHAR2 := NULL	,
	x_errorcode   	OUT	NOCOPY NUMBER			, -- NOCOPY change for Bug 4939368
	x_return_status	OUT	NOCOPY VARCHAR2		, -- NOCOPY change for Bug 4939368
	x_msg_count	OUT	NOCOPY NUMBER			, -- NOCOPY change for Bug 4939368
	x_msg_data	OUT	NOCOPY VARCHAR2 -- NOCOPY change for Bug 4939368
	)
IS
	l_api_name	     CONSTANT VARCHAR(30) := 'process_phase_delete';

Line: 145


	  SAVEPOINT wrapper_process_phase_delete;

Line: 160


	EGO_LIFECYCLE_ADMIN_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_msg_count		=> l_msg_count		,
		x_return_status 	=> l_return_status	,
		x_msg_data		=> l_msg_data
		);

Line: 204


       ROLLBACK TO wrapper_process_phase_delete;

Line: 211


                            p_procedure_name => 'process_phase_delete',
                            p_error_text     =>  x_msg_data); -- NOCOPY change for Bug 4939368

Line: 220


                            p_procedure_name => 'process_phase_delete',
                            p_error_text     =>  x_msg_data); -- NOCOPY change for Bug 4939368

Line: 223


       ROLLBACK TO wrapper_process_phase_delete;

Line: 228


       ROLLBACK TO wrapper_process_phase_delete;

Line: 235


                            p_procedure_name => 'process_phase_delete',
                            p_error_text     =>  x_msg_data); -- NOCOPY change for Bug 4939368

Line: 238


END process_phase_delete;

Line: 246


PROCEDURE check_delete_lifecycle_ok(
	p_api_version			IN	NUMBER	:= 1.0			,
	p_lifecycle_id 			IN	NUMBER				,
	p_init_msg_list			IN	VARCHAR2 := NULL		,
	x_delete_ok			OUT	NOCOPY VARCHAR2			, -- NOCOPY change for Bug 4939368
	x_return_status			OUT	NOCOPY VARCHAR2			, -- NOCOPY change for Bug 4939368
	x_errorcode			OUT	NOCOPY NUMBER				, -- NOCOPY change for Bug 4939368
	x_msg_count			OUT	NOCOPY NUMBER				, -- NOCOPY change for Bug 4939368
	x_msg_data			OUT	NOCOPY VARCHAR2 -- NOCOPY change for Bug 4939368
	)
IS
	l_api_name	     CONSTANT VARCHAR(30) := 'check_delete_lifecycle_ok';

Line: 267


	l_delete_ok		      VARCHAR2(1);

Line: 280


	x_delete_ok     := FND_API.G_FALSE;

Line: 282


	EGO_LIFECYCLE_ADMIN_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_delete_ok		,
		x_return_status		=> l_return_status	,
		x_errorcode		=> l_errorcode		,
		x_msg_count		=> l_msg_count		,
		x_msg_data		=> l_msg_data );

Line: 292


/* Bug 2760719 -- Added check for l_delete_ok  <> FND_API.G_TRUE and moved raise statement
                  outside the IF l_msg_count > 0 */

	IF l_delete_ok  <> FND_API.G_TRUE OR l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
		l_msg_count := FND_MSG_PUB.count_msg;

Line: 315


x_delete_ok	     := l_delete_ok;

Line: 323


    x_delete_ok     := FND_API.G_FALSE;            -- NOCOPY change for Bug 4939368

Line: 328


                            p_procedure_name => 'check_delete_lifecycle_ok',
                            p_error_text     =>  x_msg_data); -- NOCOPY change for Bug 4939368

Line: 333


    x_delete_ok     := FND_API.G_FALSE;            -- NOCOPY change for Bug 4939368

Line: 338


                            p_procedure_name => 'check_delete_lifecycle_ok',
                            p_error_text     =>  x_msg_data); -- NOCOPY change for Bug 4939368

Line: 344


    x_delete_ok     := FND_API.G_FALSE;            -- NOCOPY change for Bug 4939368

Line: 349


                            p_procedure_name => 'check_delete_lifecycle_ok',
                            p_error_text     =>  x_msg_data);

Line: 352


END check_delete_lifecycle_ok;

Line: 360


PROCEDURE delete_stale_data_for_lc(
	p_api_version			IN NUMBER := 1.0			,
	p_lifecycle_id 			IN NUMBER				,
	p_init_msg_list			IN VARCHAR2 := NULL			,
	p_commit       			IN VARCHAR2 := NULL			,
	x_errorcode   			OUT NOCOPY NUMBER				, -- NOCOPY change for Bug 4939368
	x_return_status			OUT NOCOPY VARCHAR2				, -- NOCOPY change for Bug 4939368
	x_msg_count			OUT NOCOPY NUMBER				, -- NOCOPY change for Bug 4939368
	x_msg_data			OUT NOCOPY VARCHAR2 -- NOCOPY change for Bug 4939368
	)

IS
	l_api_name	     CONSTANT VARCHAR(30) := 'delete_stale_data_for_lc';

Line: 385


	  SAVEPOINT wrapper_delete_data_for_lc;

Line: 400


	EGO_LIFECYCLE_ADMIN_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_msg_count		=> l_msg_count		,
		x_return_status 	=> l_return_status	,
		x_msg_data		=> l_msg_data
		);

Line: 444


       ROLLBACK TO wrapper_delete_data_for_lc;

Line: 451


                            p_procedure_name => 'delete_stale_data_for_lc',
                            p_error_text     =>  x_msg_data); -- NOCOPY change for Bug 4939368

Line: 460


                            p_procedure_name => 'delete_stale_data_for_lc',
                            p_error_text     =>  x_msg_data); -- NOCOPY change for Bug 4939368

Line: 463


       ROLLBACK TO wrapper_delete_data_for_lc;

Line: 468


       ROLLBACK TO wrapper_delete_data_for_lc;

Line: 475


                            p_procedure_name => 'delete_stale_data_for_lc',
                            p_error_text     =>  x_msg_data); -- NOCOPY change for Bug 4939368

Line: 478


END delete_stale_data_for_lc;

Line: 848


PROCEDURE check_delete_project_ok(
	p_api_version		IN	NUMBER	   :=1.0	,
	p_project_id 		IN	NUMBER			,
	p_init_msg_list		IN	VARCHAR2   := NULL	,
	x_delete_ok		OUT	NOCOPY VARCHAR2		, -- NOCOPY change for Bug 4939368
	x_return_status		OUT	NOCOPY VARCHAR2		, -- NOCOPY change for Bug 4939368
	x_errorcode		OUT	NOCOPY NUMBER			, -- NOCOPY change for Bug 4939368
	x_msg_count		OUT	NOCOPY NUMBER			, -- NOCOPY change for Bug 4939368
	x_msg_data		OUT	NOCOPY VARCHAR2  -- NOCOPY change for Bug 4939368
	)
IS
	l_api_name	     CONSTANT VARCHAR(30) := 'check_delete_project_ok';

Line: 869


        l_delete_ok                   VARCHAR2(1);

Line: 882


	x_delete_ok     := FND_API.G_FALSE;

Line: 884


	EGO_LIFECYCLE_USER_PUB.check_delete_project_ok(
		p_api_version		=> p_api_version	,
		p_project_id		=> p_project_id		,
		p_init_msg_list		=> p_init_msg_list	,
		x_delete_ok		=> l_delete_ok		,
		x_return_status		=> l_return_status	,
		x_errorcode		=> l_errorcode		,
		x_msg_count		=> l_msg_count		,
		x_msg_data		=> l_msg_data );

Line: 894


	/* Bug 2760719 -- Added check for l_delete_ok  <> FND_API.G_TRUE and moved raise statement
                  outside the IF l_msg_count > 0 */

	IF l_delete_ok  <> FND_API.G_TRUE OR l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
		l_msg_count := FND_MSG_PUB.count_msg;

Line: 917


x_delete_ok          := l_delete_ok;

Line: 924


    x_delete_ok     := FND_API.G_FALSE;            -- NOCOPY change for Bug 4939368

Line: 929


                            p_procedure_name => 'check_delete_project_ok',
                            p_error_text     =>  x_msg_data); -- NOCOPY change for Bug 4939368

Line: 934


    x_delete_ok     := FND_API.G_FALSE;            -- NOCOPY change for Bug 4939368

Line: 939


                            p_procedure_name => 'check_delete_project_ok',
                            p_error_text     =>  x_msg_data); -- NOCOPY change for Bug 4939368

Line: 945


    x_delete_ok     := FND_API.G_FALSE;            -- NOCOPY change for Bug 4939368

Line: 950


                            p_procedure_name => 'check_delete_project_ok',
                            p_error_text     =>  x_msg_data); -- NOCOPY change for Bug 4939368

Line: 953


END check_delete_project_ok;

Line: 965


PROCEDURE delete_all_item_assocs(
	p_api_version			IN	NUMBER		:=1.0		,
	p_project_id 			IN	NUMBER				,
	p_init_msg_list			IN	VARCHAR2 := NULL		,
	p_commit       			IN	VARCHAR2 := NULL		,
	x_errorcode   			OUT	NOCOPY NUMBER				, -- NOCOPY change for Bug 4939368
	x_return_status			OUT	NOCOPY VARCHAR2			, -- NOCOPY change for Bug 4939368
	x_msg_count			OUT	NOCOPY NUMBER				, -- NOCOPY change for Bug 4939368
	x_msg_data			OUT	NOCOPY VARCHAR2 -- NOCOPY change for Bug 4939368
	)
IS
	l_api_name	     CONSTANT VARCHAR(30) := 'delete_all_item_assocs';

Line: 989


	  SAVEPOINT wrapper_delete_all_item_assocs;

Line: 1004


	EGO_LIFECYCLE_USER_PUB.delete_all_item_assocs(
		p_api_version		=> p_api_version	,
		p_project_id		=> p_project_id		,
		p_commit		=> p_commit		,
		x_errorcode		=> l_errorcode		,
		x_msg_count		=> l_msg_count		,
		x_return_status 	=> l_return_status	,
		x_msg_data		=> l_msg_data );

Line: 1046


       ROLLBACK TO wrapper_delete_all_item_assocs;

Line: 1053


                            p_procedure_name => 'delete_all_item_assocs',
                            p_error_text     =>  x_msg_data); -- NOCOPY change for Bug 4939368

Line: 1062


                            p_procedure_name => 'delete_all_item_assocs',
                            p_error_text     =>  x_msg_data); -- NOCOPY change for Bug 4939368

Line: 1065


       ROLLBACK TO wrapper_delete_all_item_assocs;

Line: 1070


       ROLLBACK TO wrapper_delete_all_item_assocs;

Line: 1077


                            p_procedure_name => 'delete_all_item_assocs',
                            p_error_text     =>  x_msg_data); -- NOCOPY change for Bug 4939368

Line: 1080


END delete_all_item_assocs;

Line: 1090


  select application_id
  from fnd_application
  where application_short_name = 'EGO';

Line: 1096


  select nvl(status,'N') from fnd_product_installations
  where application_id = x_application_id;

Line: 1256


PROCEDURE check_delete_project_ok_eng(
	p_api_version		IN	NUMBER	   :=1.0	,
	p_project_id 		IN	NUMBER			,
	p_init_msg_list		IN	VARCHAR2   := NULL	,
	x_delete_ok		OUT	NOCOPY VARCHAR2		, -- NOCOPY change for Bug 4939368
	x_return_status		OUT	NOCOPY VARCHAR2		, -- NOCOPY change for Bug 4939368
	x_errorcode		OUT	NOCOPY NUMBER			, -- NOCOPY change for Bug 4939368
	x_msg_count		OUT	NOCOPY NUMBER			, -- NOCOPY change for Bug 4939368
	x_msg_data		OUT	NOCOPY VARCHAR2  -- NOCOPY change for Bug 4939368
	)
IS
	l_api_name	     CONSTANT VARCHAR(30) := 'check_delete_project_ok_eng';

Line: 1276


        l_delete_ok                   VARCHAR2(1);

Line: 1289


	x_delete_ok     := FND_API.G_FALSE;

Line: 1291


	ENG_LIFECYCLE_USER_PUB.check_delete_project_ok(
		p_api_version		=> p_api_version	,
		p_project_id		=> p_project_id		,
		p_init_msg_list		=> p_init_msg_list	,
		x_delete_ok		=> l_delete_ok		,
		x_return_status		=> l_return_status	,
		x_errorcode		=> l_errorcode		,
		x_msg_count		=> l_msg_count		,
		x_msg_data		=> l_msg_data );

Line: 1301


	IF l_delete_ok  <> FND_API.G_TRUE OR l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
		l_msg_count := FND_MSG_PUB.count_msg;

Line: 1321


x_delete_ok          := l_delete_ok;

Line: 1328


    x_delete_ok     := FND_API.G_FALSE;            -- NOCOPY change for Bug 4939368

Line: 1333


                            p_procedure_name => 'check_delete_project_ok_eng',
                            p_error_text     => x_msg_data); -- NOCOPY change for Bug 4939368

Line: 1338


    x_delete_ok     := FND_API.G_FALSE;            -- NOCOPY change for Bug 4939368

Line: 1343


                            p_procedure_name => 'check_delete_project_ok_eng',
                            p_error_text     => x_msg_data); -- NOCOPY change for Bug 4939368

Line: 1349


    x_delete_ok     := FND_API.G_FALSE;            -- NOCOPY change for Bug 4939368

Line: 1354


                            p_procedure_name => 'check_delete_project_ok_eng',
                            p_error_text     => x_msg_data); -- NOCOPY change for Bug 4939368

Line: 1357


END check_delete_project_ok_eng;

Line: 1367


PROCEDURE check_delete_task_ok_eng(
	p_api_version		IN	NUMBER	   :=1.0	,
	p_task_id 		IN	NUMBER			,
	p_init_msg_list		IN	VARCHAR2   := NULL	,
	x_delete_ok		OUT	NOCOPY VARCHAR2		, -- NOCOPY change for Bug 4939368
	x_return_status		OUT	NOCOPY VARCHAR2		, -- NOCOPY change for Bug 4939368
	x_errorcode		OUT	NOCOPY NUMBER			, -- NOCOPY change for Bug 4939368
	x_msg_count		OUT	NOCOPY NUMBER			, -- NOCOPY change for Bug 4939368
	x_msg_data		OUT	NOCOPY VARCHAR2  -- NOCOPY change for Bug 4939368
	)
IS
	l_api_name	     CONSTANT VARCHAR(30) := 'check_delete_task_ok_eng';

Line: 1386


        l_delete_ok                   VARCHAR2(1);

Line: 1399


	x_delete_ok     := FND_API.G_FALSE;

Line: 1401


	ENG_LIFECYCLE_USER_PUB.check_delete_task_ok(
		p_api_version		=> p_api_version	,
		p_task_id		=> p_task_id		,
		p_init_msg_list		=> p_init_msg_list	,
		x_delete_ok		=> l_delete_ok		,
		x_return_status		=> l_return_status	,
		x_errorcode		=> l_errorcode		,
		x_msg_count		=> l_msg_count		,
		x_msg_data		=> l_msg_data );

Line: 1411


	IF l_delete_ok  <> FND_API.G_TRUE OR l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
		l_msg_count := FND_MSG_PUB.count_msg;

Line: 1431


x_delete_ok          := l_delete_ok;

Line: 1438


    x_delete_ok     := FND_API.G_FALSE;            -- NOCOPY change for Bug 4939368

Line: 1443


                            p_procedure_name => 'check_delete_task_ok_eng',
                            p_error_text     => x_msg_data); -- NOCOPY change for Bug 4939368

Line: 1448


    x_delete_ok     := FND_API.G_FALSE;            -- NOCOPY change for Bug 4939368

Line: 1453


                            p_procedure_name => 'check_delete_task_ok_eng',
                            p_error_text     => x_msg_data); -- NOCOPY change for Bug 4939368

Line: 1459


    x_delete_ok     := FND_API.G_FALSE;            -- NOCOPY change for Bug 4939368

Line: 1464


                            p_procedure_name => 'check_delete_task_ok_eng',
                            p_error_text     => x_msg_data); -- NOCOPY change for Bug 4939368

Line: 1467


END check_delete_task_ok_eng;

Line: 1477


PROCEDURE process_phase_code_delete(
	p_api_version	IN	NUMBER	:= 1.0		        ,
	p_phase_code 	IN	NUMBER			        ,
	p_init_msg_list	IN	VARCHAR2 := FND_API.G_FALSE	,
	p_commit       	IN	VARCHAR2 := FND_API.G_FALSE	,
	x_return_status	OUT	NOCOPY VARCHAR2		        , -- NOCOPY change for Bug 4939368
	x_errorcode   	OUT	NOCOPY NUMBER			        , -- NOCOPY change for Bug 4939368
	x_msg_count	OUT	NOCOPY NUMBER			        , -- NOCOPY change for Bug 4939368
	x_msg_data	OUT	NOCOPY VARCHAR2 -- NOCOPY change for Bug 4939368
	)
IS
	l_api_name	     CONSTANT VARCHAR(30) := 'process_phase_code_delete';

Line: 1501


	  SAVEPOINT wrp_process_phase_code_delete;

Line: 1515


	EGO_LIFECYCLE_ADMIN_PUB.process_phase_code_delete(
		p_api_version		=> p_api_version	,
		p_phase_code		=> p_phase_code		,
		p_init_msg_list		=> p_init_msg_list	,
		p_commit		=> p_commit		,
		x_return_status 	=> l_return_status	,
		x_errorcode		=> l_errorcode		,
		x_msg_count		=> l_msg_count		,
		x_msg_data		=> l_msg_data
		);

Line: 1555


       ROLLBACK TO wrp_process_phase_code_delete;

Line: 1562


                            p_procedure_name => 'process_phase_code_delete',
                            p_error_text     => x_msg_data); -- NOCOPY change for Bug 4939368

Line: 1571


                            p_procedure_name => 'process_phase_code_delete',
                            p_error_text     => x_msg_data); -- NOCOPY change for Bug 4939368

Line: 1574


       ROLLBACK TO wrp_process_phase_code_delete;

Line: 1579


       ROLLBACK TO wrp_process_phase_code_delete;

Line: 1586


                            p_procedure_name => 'process_phase_code_delete',
                            p_error_text     => x_msg_data); -- NOCOPY change for Bug 4939368

Line: 1589


END process_phase_code_delete;