APPS.DPP_XLA_EVENT_MAP_PKG SQL Statements

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

Line: 16

    CURSOR c(C_PP_TRANSACTION_TYPE VARCHAR2) IS SELECT rowid FROM DPP_XLA_EVENT_MAP
      WHERE PP_TRANSACTION_TYPE = C_PP_TRANSACTION_TYPE;

Line: 23

    update DPP_XLA_EVENT_MAP
    set ENTITY_CODE = P_ENTITY_CODE,
    	EVENT_CLASS_CODE = P_EVENT_CLASS_CODE,
    	EVENT_TYPE_CODE =  P_EVENT_TYPE_CODE,
        LAST_UPDATE_DATE = SYSDATE,
        LAST_UPDATED_BY = l_user_id,
    	LAST_UPDATE_LOGIN = l_login_id
    where PP_TRANSACTION_TYPE = P_PP_TRANSACTION_TYPE;

Line: 34

    	Insert into DPP_XLA_EVENT_MAP
    		(PP_TRANSACTION_TYPE,
    		ENTITY_CODE,
    		EVENT_CLASS_CODE,
    		EVENT_TYPE_CODE,
    		CREATION_DATE,
    		CREATED_BY,
    		LAST_UPDATE_DATE,
    		LAST_UPDATED_BY,
    		LAST_UPDATE_LOGIN)
    	VALUES (P_PP_TRANSACTION_TYPE,
    		P_ENTITY_CODE,
    		P_EVENT_CLASS_CODE,
    		P_EVENT_TYPE_CODE,
    		SYSDATE,
    		l_user_id,
    		SYSDATE,
    		l_user_id,
    		l_login_id);