APPS.EDR_EVENT_RELATIONSHIP_PUB SQL Statements

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

Line: 22

                        last_update_date  out nocopy date,
                        last_updated_by   out nocopy number,
                        last_update_login out nocopy number)
is
begin
  creation_date := sysdate;

Line: 29

  last_update_date := sysdate;

Line: 30

  last_updated_by := fnd_global.user_id();

Line: 31

  last_update_login := fnd_global.login_id();

Line: 61

  	L_LAST_UPDATE_DATE    	 DATE;

Line: 62

  	L_LAST_UPDATED_BY     	 NUMBER;

Line: 63

  	L_LAST_UPDATE_LOGIN   	 NUMBER;

Line: 112

	-- after all the validations are done, insert the row in the
	-- database

	select edr_event_relationship_s.nextval into x_relationship_id
    	from dual;

Line: 120

                  	l_last_update_date,
                  	l_last_updated_by,
                  	l_last_update_login);

Line: 124

    	insert into EDR_EVENT_RELATIONSHIP(
               RELATIONSHIP_ID
              ,PARENT_EVENT_NAME
              ,PARENT_EVENT_KEY
              ,PARENT_ERECORD_ID
              ,CHILD_EVENT_NAME
              ,CHILD_EVENT_KEY
              ,CHILD_ERECORD_ID
              ,CREATION_DATE
              ,CREATED_BY
              ,LAST_UPDATE_DATE
              ,LAST_UPDATED_BY
              ,LAST_UPDATE_LOGIN
    	) values (
               X_RELATIONSHIP_ID
              ,P_PARENT_EVENT_NAME
              ,P_PARENT_EVENT_KEY
              ,P_PARENT_ERECORD_ID
              ,P_CHILD_EVENT_NAME
              ,P_CHILD_EVENT_KEY
              ,P_CHILD_ERECORD_ID
              ,L_CREATION_DATE
              ,L_CREATED_BY
              ,L_LAST_UPDATE_DATE
              ,L_LAST_UPDATED_BY
              ,L_LAST_UPDATE_LOGIN
    	);