APPS.CAC_SYNC_CONTACT_MAPPINGS_PVT SQL Statements

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

Line: 33

        SELECT sync_contact_mapping_id
             , org_party_id
             , person_party_id
             , party_site_id
             , work_contact_point_id
             , home_contact_point_id
             , fax_contact_point_id
             , cell_contact_point_id
             , pager_contact_point_id
             , email_contact_point_id
          FROM cac_sync_contact_mappings
         WHERE contact_party_id = p_contact_party_id;

Line: 70

            UPDATE_CONTACT_MAPPING
            ( p_api_version             => p_api_version
            , p_init_msg_list           => p_init_msg_list
            , p_commit                  => p_commit
            , p_sync_contact_mapping_id => rec_mapping.sync_contact_mapping_id
            , p_contact_party_id        => p_contact_party_id
            , p_org_party_id            => p_org_party_id
            , p_person_party_id         => p_person_party_id
            , p_party_site_id           => p_party_site_id
            , p_work_contact_point_id   => p_work_contact_point_id
            , p_home_contact_point_id   => p_home_contact_point_id
            , p_fax_contact_point_id    => p_fax_contact_point_id
            , p_cell_contact_point_id   => p_cell_contact_point_id
            , p_pager_contact_point_id  => p_pager_contact_point_id
            , p_email_contact_point_id  => p_email_contact_point_id
            , p_last_sync_date          => p_last_sync_date
            , x_return_status           => x_return_status
            , x_msg_count               => x_msg_count
            , x_msg_data                => x_msg_data
            );

Line: 104

            SELECT cac_sync_contact_mappings_s.nextval
              INTO x_sync_contact_mapping_id
              FROM DUAL;

Line: 111

        cac_sync_contact_mappings_pkg.insert_row
        ( x_rowid                   => l_rowid
        , x_sync_contact_mapping_id => p_sync_contact_mapping_id
        , x_contact_party_id        => p_contact_party_id
        , x_org_party_id            => p_org_party_id
        , x_person_party_id         => p_person_party_id
        , x_party_site_id           => p_party_site_id
        , x_work_contact_point_id   => p_work_contact_point_id
        , x_home_contact_point_id   => p_home_contact_point_id
        , x_fax_contact_point_id    => p_fax_contact_point_id
        , x_cell_contact_point_id   => p_cell_contact_point_id
        , x_pager_contact_point_id  => p_pager_contact_point_id
        , x_email_contact_point_id  => p_email_contact_point_id
        , x_created_by              => fnd_global.user_id
        , x_creation_date           => NVL(p_last_sync_date,SYSDATE)
        , x_last_updated_by         => fnd_global.user_id
        , x_last_update_date        => NVL(p_last_sync_date,SYSDATE)
        , x_last_update_login       => fnd_global.login_id
        );

Line: 159

    PROCEDURE UPDATE_CONTACT_MAPPING
    ( p_api_version             IN  NUMBER
    , p_init_msg_list           IN  VARCHAR2
    , p_commit                  IN  VARCHAR2
    , p_sync_contact_mapping_id IN  NUMBER
    , p_contact_party_id        IN  NUMBER
    , p_org_party_id            IN  NUMBER
    , p_person_party_id         IN  NUMBER
    , p_party_site_id           IN  NUMBER
    , p_work_contact_point_id   IN  NUMBER
    , p_home_contact_point_id   IN  NUMBER
    , p_fax_contact_point_id    IN  NUMBER
    , p_cell_contact_point_id   IN  NUMBER
    , p_pager_contact_point_id  IN  NUMBER
    , p_email_contact_point_id  IN  NUMBER
    , p_last_sync_date          IN  DATE
    , x_return_status           OUT NOCOPY VARCHAR2
    , x_msg_count               OUT NOCOPY NUMBER
    , x_msg_data                OUT NOCOPY VARCHAR2
    )
    IS
        l_rowid ROWID;

Line: 185

        SELECT NULL
          FROM cac_sync_contact_mappings
         WHERE sync_contact_mapping_id = p_sync_contact_mapping_id;

Line: 191

        SAVEPOINT update_contact_mapping_sv;

Line: 218

        cac_sync_contact_mappings_pkg.update_row
        ( x_sync_contact_mapping_id => p_sync_contact_mapping_id
        , x_contact_party_id        => p_contact_party_id
        , x_org_party_id            => p_org_party_id
        , x_person_party_id         => p_person_party_id
        , x_party_site_id           => p_party_site_id
        , x_work_contact_point_id   => p_work_contact_point_id
        , x_home_contact_point_id   => p_home_contact_point_id
        , x_fax_contact_point_id    => p_fax_contact_point_id
        , x_cell_contact_point_id   => p_cell_contact_point_id
        , x_pager_contact_point_id  => p_pager_contact_point_id
        , x_email_contact_point_id  => p_email_contact_point_id
        , x_last_updated_by         => fnd_global.user_id
        , x_last_update_date        => NVL(p_last_sync_date,SYSDATE)
        , x_last_update_login       => fnd_global.login_id
        );

Line: 244

            ROLLBACK TO update_contact_mapping_sv;

Line: 252

            ROLLBACK TO update_contact_mapping_sv;

Line: 258

    END UPDATE_CONTACT_MAPPING;

Line: 261

    PROCEDURE DELETE_CONTACT_MAPPING
    ( p_api_version             IN  NUMBER
    , p_init_msg_list           IN  VARCHAR2
    , p_commit                  IN  VARCHAR2
    , p_sync_contact_mapping_id IN  NUMBER
    , x_return_status           OUT NOCOPY VARCHAR2
    , x_msg_count               OUT NOCOPY NUMBER
    , x_msg_data               OUT NOCOPY VARCHAR2
    )
    IS
        l_rowid ROWID;

Line: 273

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

Line: 275

        SAVEPOINT delete_contact_mapping_sv;

Line: 290

        cac_sync_contact_mappings_pkg.delete_row
        (x_sync_contact_mapping_id => p_sync_contact_mapping_id);

Line: 302

            ROLLBACK TO delete_contact_mapping_sv;

Line: 307

            ROLLBACK TO delete_contact_mapping_sv;

Line: 313

    END DELETE_CONTACT_MAPPING;