APPS.IBU_SR_UTIL SQL Statements

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

Line: 41

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

Line: 124

x_insert_status       VARCHAR2(10) ;

Line: 195

		             x_insert_status
			     );

Line: 217

		           x_insert_status
			   );

Line: 234

 x_insert_status := 'E';

Line: 247

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: 275

			           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: 306

x_insert_status := 'S';

Line: 310

x_insert_status := 'E';

Line: 314

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: 328

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

Line: 332

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: 338

x_update_status := 'S';

Line: 341

x_update_status := 'E';

Line: 344

END update_ibu_multi_parties;