APPS.EGO_UCCNET_EVENTS_PVT SQL Statements

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

Line: 8

PROCEDURE Update_Event_Disposition (
         p_api_version                  IN      NUMBER
        ,p_commit                       IN      VARCHAR2 DEFAULT FND_API.g_FALSE
        ,p_init_msg_list                IN      VARCHAR2 DEFAULT FND_API.G_FALSE
        ,p_cln_id                       IN      NUMBER
        ,p_disposition_code             IN      VARCHAR2
        ,p_disposition_date             IN      DATE
        ,x_return_status                OUT NOCOPY VARCHAR2
        ,x_msg_count                    OUT NOCOPY VARCHAR2
        ,x_msg_data                     OUT NOCOPY VARCHAR2
)
IS
        --we don't use l_api_version yet, but eventually we might:
        --if we change required parameters, version goes from n.x to (n+1).x
        --if we change optional parameters, version goes from x.n to x.(n+1)

        l_api_version            CONSTANT NUMBER := 1.0;

Line: 26

        l_api_name              CONSTANT        VARCHAR2(30) := 'Update_Event_Disposition';

Line: 32

        SAVEPOINT Update_Disposition_PVT;

Line: 48

        UPDATE EGO_UCCNET_EVENTS
          SET DISPOSITION_CODE = p_disposition_code,
              DISPOSITION_DATE = p_disposition_date
          WHERE cln_id = p_cln_id;

Line: 63

           ROLLBACK TO Update_Disposition_PVT;

Line: 74

END Update_Event_Disposition;

Line: 119

        UPDATE EGO_UCCNET_EVENTS
          SET cln_id = p_cln_id
          WHERE batch_id = p_batch_id
          AND   subbatch_id = p_subbatch_id
          AND   top_gtin = p_top_gtin;

Line: 186

      INSERT INTO EGO_UCCNET_ADD_CIC_INFO
        (
        CLN_ID
        ,CODE
        ,DESCRIPTION
        ,ACTION_NEEDED
        ,CREATED_BY
        ,CREATION_DATE
        ,LAST_UPDATED_BY
        ,LAST_UPDATE_DATE
        ,LAST_UPDATE_LOGIN
        )
        VALUES
        (
        p_cln_id
        ,p_cic_code
        ,p_cic_description
        ,p_cic_action_needed
        ,fnd_global.user_id
        ,sysdate
        ,fnd_global.user_id
        ,sysdate
        ,fnd_global.login_id
        );