APPS.HZ_EBI_CUST_LOAD SQL Statements

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

Line: 13

      DELETE FROM HZ_EBI_CUST_LOAD_LOG;

Line: 39

       SELECT count(*) INTO  l_logCustCount  FROM HZ_EBI_CUST_LOAD_LOG;

Line: 44

          x_err_msg := x_err_msg || '\n Inserting Records to Event log table';

Line: 47

          INSERT INTO HZ_EBI_CUST_LOAD_LOG( PARTY_ID , EVENT_ID)
          Select distinct party.PARTY_ID ,NULL
          from HZ_PARTIES party, HZ_CUST_ACCOUNTS accnt where
          accnt.status='A' and party.PARTY_ID = accnt.party_id;

Line: 56

           SELECT MAX(NVL(EVENT_ID,0)) into l_eventId FROM HZ_EBI_CUST_LOAD_LOG;

Line: 62

       SELECT count(*) INTO l_CustCount FROM HZ_EBI_CUST_LOAD_LOG WHERE EVENT_ID IS NULL;

Line: 68

          UPDATE HZ_EBI_CUST_LOAD_LOG
          SET EVENT_ID = l_eventId
          WHERE EVENT_ID IS NULL AND  ROWNUM < l_batch_size +1;

Line: 103

  SELECT count(*) INTO  l_logCustCount
  FROM HZ_EBI_CUST_LOAD_LOG
  WHERE  EVENT_ID = p_event_id;

Line: 113

     DELETE FROM  HZ_EBI_CUST_LOAD_LOG
     WHERE EVENT_ID = p_event_id AND
           PARTY_ID NOT IN(
                    SELECT DISTINCT party.PARTY_ID
                     FROM HZ_PARTIES party, HZ_CUST_ACCOUNTS accnt
                     WHERE  accnt.STATUS='A' and party.PARTY_ID = accnt.PARTY_ID);

Line: 120

     SELECT MAX(NVL(EVENT_ID,0))+1 into l_eventId FROM HZ_EBI_CUST_LOAD_LOG;

Line: 122

     UPDATE  HZ_EBI_CUST_LOAD_LOG
           SET EVENT_ID = l_eventId
           WHERE EVENT_ID = p_event_id    ;

Line: 157

      l_parameter_list.DELETE;

Line: 180

       SELECT party_id from HZ_EBI_CUST_LOAD_LOG where event_id = p_event_id;