APPS.IBU_SR_UTIL SQL Statements

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

Line: 42

            select lengthb(p_string(i)) into l_length from dual;

Line: 125

x_insert_status       VARCHAR2(10) ;

Line: 196

		             x_insert_status
			     );

Line: 218

		           x_insert_status
			   );

Line: 235

 x_insert_status := 'E';

Line: 248

SELECT /*+ index(HZ_RELATIONSHIPS_N2) */ party_id
INTO x_party_id
FROM hz_relationships
WHERE object_id = p_Object_Id
AND object_type='ORGANIZATION'
AND subject_id  = p_Subject_Id
AND subject_type ='PERSON'
AND relationship_code ='CONTACT_OF';

Line: 276

			           p_last_updated_by IN NUMBER,
			           p_last_update_date IN DATE,
			           p_last_update_login IN NUMBER,
			           x_insert_status OUT NOCOPY VARCHAR2
			          )

AS

BEGIN

INSERT INTO ibu_multi_parties(USER_ID,
                              PARTY_ID,
			      ENABLE_FLAG,
			      CURRENT_PARTY,
			      END_DATE,
			      CREATED_BY,
			      CREATION_DATE,
                              LAST_UPDATED_BY,
			      LAST_UPDATE_DATE,
			      LAST_UPDATE_LOGIN)
                       VALUES (p_user_id,
		               p_party_id,
			       p_enable_flag,
			       p_current_party,
			       p_end_date,
			       p_created_by,
			       p_creation_date,
                               p_last_updated_by,
			       p_last_update_date,
			       p_last_update_login);

Line: 307

x_insert_status := 'S';

Line: 311

x_insert_status := 'E';

Line: 315

PROCEDURE update_ibu_multi_parties(p_user_id IN NUMBER,
				   p_loggedin_user_id IN NUMBER,
                                   p_party_id IN SYSTEM.IBU_NUM_TBL_TYPE,
				   p_enable_flag  IN SYSTEM.IBU_VAR_3_TBL_TYPE,
				   x_update_status OUT NOCOPY VARCHAR2
				   )
AS
i NUMBER;

Line: 329

select ENABLE_FLAG into l_temp from ibu_multi_parties where party_id=p_party_id(i) and user_id=p_user_id;

Line: 333

UPDATE ibu_multi_parties
SET ENABLE_FLAG = l_flag,last_update_date = SYSDATE,last_updated_by = p_loggedin_user_id,last_update_login = p_loggedin_user_id
WHERE USER_ID = p_user_id
AND PARTY_ID = l_party_id1;

Line: 339

x_update_status := 'S';

Line: 342

x_update_status := 'E';

Line: 344

END update_ibu_multi_parties;

Line: 349

CURSOR C1 IS SELECT phone_number FROM hz_contact_points where owner_table_id = party_site_id and owner_table_name = 'HZ_PARTY_SITES' and contact_point_type = 'PHONE' order by primary_flag desc,creation_date asc;