APPS.HZ_MERGE_BATCH_PUB SQL Statements

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

Line: 17

    p_batch_delete                      IN VARCHAR2,
    p_merge_reason_code                 IN VARCHAR2,
    x_batch_id                   OUT NOCOPY     NUMBER,
    x_return_status              IN OUT NOCOPY  VARCHAR2
);

Line: 24

    p_create_update_flag             IN     VARCHAR2,
    p_batch_name                 IN VARCHAR2,
    p_batch_commit               IN VARCHAR2,
    p_batch_delete               IN VARCHAR2,
    p_merge_reason_code         IN VARCHAR2,
    x_return_status              IN OUT NOCOPY VARCHAR2);

Line: 54

 |                    p_batch_delete,
 |                    p_merge_reason_code,
 |                    x_return_status
 |
 | RETURNS    : NONE
 |
 | NOTES
 |
 | MODIFICATION HISTORY
 |
 +===========================================================================**/
PROCEDURE do_create_merge_batch(
    p_batch_name                        IN  VARCHAR2,
    p_batch_commit                      IN VARCHAR2,
    p_batch_delete                      IN VARCHAR2,
    p_merge_reason_code                 IN VARCHAR2,
    x_batch_id                   OUT NOCOPY     NUMBER,
    x_return_status              IN OUT NOCOPY  VARCHAR2
    ) IS


BEGIN

    x_batch_id  := NULL;

Line: 84

     p_batch_delete,
     p_merge_reason_code,
     x_return_status);

Line: 93

 HZ_MERGE_BATCH_PKG.INSERT_ROW(
          px_BATCH_ID   => x_batch_id,
          p_RULE_SET_NAME   => 'DEFAULT',
          p_BATCH_NAME   =>  p_BATCH_NAME,
          p_REQUEST_ID    => HZ_UTILITY_PUB.REQUEST_ID,
          p_BATCH_STATUS    => 'PENDING',
          p_BATCH_COMMIT    => p_BATCH_COMMIT,
          p_BATCH_DELETE    => p_BATCH_DELETE,
          p_MERGE_REASON_CODE    => p_MERGE_REASON_CODE,
          p_CREATED_BY    => HZ_UTILITY_PUB.CREATED_BY,
          p_CREATION_DATE  =>  HZ_UTILITY_PUB.CREATION_DATE,
          p_LAST_UPDATE_LOGIN  =>  HZ_UTILITY_PUB.LAST_UPDATE_LOGIN,
          p_LAST_UPDATE_DATE    =>HZ_UTILITY_PUB.LAST_UPDATE_DATE,
          p_LAST_UPDATED_BY  =>  HZ_UTILITY_PUB.LAST_UPDATED_BY);

Line: 113

    p_create_update_flag             IN     VARCHAR2,
    p_batch_name                 IN VARCHAR2,
    p_batch_commit               IN VARCHAR2,
    p_batch_delete               IN VARCHAR2,
    p_merge_reason_code         IN VARCHAR2,
    x_return_status              IN OUT NOCOPY VARCHAR2

) IS

l_dummy                                 VARCHAR2(1);

Line: 127

    IF p_create_update_flag = 'C' AND p_merge_reason_code is NOT NULL
    THEN
        HZ_UTILITY_V2PUB.validate_lookup (
            p_column                                => 'merge_reason_code',
            p_lookup_type                           => 'MERGE_REASON_CODE',
            p_column_value                          => p_merge_reason_code,
            x_return_status                         => x_return_status );

Line: 185

    p_batch_delete               IN VARCHAR2,
    p_merge_reason_code          IN VARCHAR2,
    x_return_status              OUT NOCOPY    VARCHAR2,
    x_msg_count                  OUT NOCOPY    NUMBER,
    x_msg_data                   OUT NOCOPY    VARCHAR2,
    x_batch_id                   OUT NOCOPY    NUMBER,
    p_validation_level           IN    NUMBER:= FND_API.G_VALID_LEVEL_FULL
) IS

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

Line: 199

    l_batch_delete      VARCHAR2(1)  :=   p_batch_delete;

Line: 230

                      l_batch_delete,
                      l_merge_reason_code,
                      x_batch_id,
                      x_return_status);