APPS.EGO_PUB_WS_WRAPPER SQL Statements

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

Line: 37

	INSERT INTO EGO_PUB_WS_CONFIG (	session_id,
					odi_session_id,
					Parameter_Name,
					Data_Type,
					NUMERIC_value,
					creation_date,
					created_by,
					web_service_name)
				VALUES (p_session_id,
					p_session_id,
					'ODI_SESSION_ID',
					1,
					l_odi_session_id,
				        sysdate,
					0,
					l_odi_entscename);

Line: 55

	--and insert in parametes table

	-- Get Entity Scenario Name
	l_batch_search_str := EGO_PUB_WS_UTIL.Get_Batch_Search_Str(l_odi_entscename);

Line: 60

	/*insert into EGO.tr_temp values('wrapper p_session_id :', p_session_id);

Line: 61

          insert into tr_temp values('wrapper l_batch_search_str :', l_batch_search_str);

Line: 70

	/*insert into EGO.tr_temp values('wrapper l_mode :', l_mode);

Line: 71

	insert into EGO.tr_temp values('wrapper l_batch_id :', l_batch_id);

Line: 75

	/*INSERT INTO tr_temp (Session_id, message)
              values (p_session_id, 'invokation mode:' || l_mode);*/

Line: 79

	--inserting invocation mode as config parameter
	INSERT INTO EGO_PUB_WS_CONFIG (	session_id,
					odi_session_id,
					Parameter_Name,
					Data_Type,
					Char_value,
					creation_date,
					created_by,
					web_service_name)
				VALUES (p_session_id,
					p_session_id,
					'MODE',
					2,
					l_mode,
					sysdate,
					0,
					l_odi_entscename);

Line: 98

		--inserting batch id as config parameter
		INSERT INTO EGO_PUB_WS_CONFIG (	session_id,
						odi_session_id,
						Parameter_Name,
						Data_Type,
						Numeric_value,
						creation_date,
						created_by,
						web_service_name)
					VALUES (p_session_id,
						p_session_id,
						'BATCH_ID',
						1,
						l_batch_id,
					        sysdate,
						0,
						l_odi_entscename);

Line: 120

		-- call to ego_pub_fwk_pk - update_pub_status - api in batch mode equal to zero
		-- which will update status for all entities for all systems of the batch

		bat_ent_stat_rec(1).batch_id 	:= l_batch_id;

Line: 132

		EGO_PUB_FWK_PK.Update_Pub_Status(l_batch_id, 0, bat_ent_stat_rec,x_bat_status_out,x_return_status,x_msg_count,x_msg_data);

Line: 151

PROCEDURE Update_Batch_System_Status(p_session_id IN NUMBER,
                                     p_system_code IN VARCHAR2)
IS

l_mode VARCHAR2(10) := NULL;

Line: 169

	-- for all input entities of the batch, and the only selected, batch system,
        -- the process status would be - Failed with relevant error message.

	-- call to ego_pub_fwk_pk - update_pub_status - api in batch mode equal to one
	-- which will update status for all entities for the provided systems of the batch
        BEGIN
	   SELECT CHAR_VALUE
	   INTO l_mode
	   FROM EGO_PUB_WS_CONFIG
	   WHERE SESSION_ID = p_session_id
	   AND PARAMETER_NAME = 'MODE';

Line: 188

	   SELECT NUMERIC_VALUE
	   INTO l_batch_id
	   FROM EGO_PUB_WS_CONFIG
	   WHERE SESSION_ID = p_session_id
	   AND PARAMETER_NAME = 'BATCH_ID';

Line: 214

	   EGO_PUB_FWK_PK.Update_Pub_Status(l_batch_id, 1, bat_ent_stat_rec,x_bat_status_out,x_return_status,x_msg_count,x_msg_data);

Line: 217

END Update_Batch_System_Status;