DBA Data[Home] [Help]

APPS.OKC_SUBCLASS_PUB SQL Statements

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

Line: 20

    l_scsv_rec.last_updated_by       := p_scsv_rec1.last_updated_by;
Line: 21

    l_scsv_rec.last_update_date      := p_scsv_rec1.last_update_date;
Line: 22

    l_scsv_rec.last_update_login     := p_scsv_rec1.last_update_login;
Line: 43

    l_srev_rec.last_updated_by       := p_srev_rec1.last_updated_by;
Line: 44

    l_srev_rec.last_update_date      := p_srev_rec1.last_update_date;
Line: 45

    l_srev_rec.last_update_login     := p_srev_rec1.last_update_login;
Line: 63

    l_srdv_rec.last_updated_by       := p_srdv_rec1.last_updated_by;
Line: 64

    l_srdv_rec.last_update_date      := p_srdv_rec1.last_update_date;
Line: 65

    l_srdv_rec.last_update_login     := p_srdv_rec1.last_update_login;
Line: 83

    l_rrdv_rec.last_updated_by       := p_rrdv_rec1.last_updated_by;
Line: 84

    l_rrdv_rec.last_update_date      := p_rrdv_rec1.last_update_date;
Line: 85

    l_rrdv_rec.last_update_login     := p_rrdv_rec1.last_update_login;
Line: 118

    l_stlv_rec.last_updated_by       := p_stlv_rec1.last_updated_by;
Line: 119

    l_stlv_rec.last_update_date      := p_stlv_rec1.last_update_date;
Line: 120

    l_stlv_rec.last_update_login     := p_stlv_rec1.last_update_login;
Line: 137

    l_lsrv_rec.last_updated_by       := p_lsrv_rec1.last_updated_by;
Line: 138

    l_lsrv_rec.last_update_date      := p_lsrv_rec1.last_update_date;
Line: 139

    l_lsrv_rec.last_update_login     := p_lsrv_rec1.last_update_login;
Line: 154

    l_lrgv_rec.last_updated_by       := p_lrgv_rec1.last_updated_by;
Line: 155

    l_lrgv_rec.last_update_date      := p_lrgv_rec1.last_update_date;
Line: 156

    l_lrgv_rec.last_update_login     := p_lrgv_rec1.last_update_login;
Line: 171

    l_srav_rec.last_updated_by       := p_srav_rec1.last_updated_by;
Line: 172

    l_srav_rec.last_update_date      := p_srav_rec1.last_update_date;
Line: 173

    l_srav_rec.last_update_login     := p_srav_rec1.last_update_login;
Line: 309

 PROCEDURE update_subclass(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_scsv_rec                     IN scsv_rec_type,
    x_scsv_rec                     OUT NOCOPY scsv_rec_type) IS
    l_api_name                     CONSTANT VARCHAR2(30) := 'update_subclass';
Line: 340

    okc_subclass_pvt.update_subclass(
                p_api_version,
                p_init_msg_list,
                x_return_status,
                x_msg_count,
                x_msg_data,
                l_scsv_rec,
                x_scsv_rec);
Line: 388

 END update_subclass;
Line: 391

 PROCEDURE update_subclass(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_scsv_tbl                     IN  scsv_tbl_type,
    x_scsv_tbl                     OUT NOCOPY scsv_tbl_type) IS
    i				   NUMBER := 0;
Line: 406

        update_subclass(
                p_api_version,
                p_init_msg_list,
                l_return_status,
                x_msg_count,
                x_msg_data,
                p_scsv_tbl(i),
                x_scsv_tbl(i));
Line: 437

 END update_subclass;
Line: 439

 PROCEDURE delete_subclass(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_scsv_rec                     IN scsv_rec_type) IS
    l_api_name                     CONSTANT VARCHAR2(30) := 'delete_subclass';
Line: 468

    okc_subclass_pvt.delete_subclass(
                p_api_version,
                p_init_msg_list,
                x_return_status,
                x_msg_count,
                x_msg_data,
                p_scsv_rec);
Line: 514

 END delete_subclass;
Line: 516

 PROCEDURE delete_subclass(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_scsv_tbl                     IN  scsv_tbl_type) IS
    i				   NUMBER := 0;
Line: 530

        delete_subclass(
                p_api_version,
                p_init_msg_list,
                l_return_status,
                x_msg_count,
                x_msg_data,
                p_scsv_tbl(i));
Line: 560

 END delete_subclass;
Line: 759

 PROCEDURE update_subclass_roles(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_srev_rec                     IN srev_rec_type,
    x_srev_rec                     OUT NOCOPY srev_rec_type) IS
    l_api_name                     CONSTANT VARCHAR2(30) := 'update_subclass_roles';
Line: 790

    okc_subclass_pvt.update_subclass_roles(
                p_api_version,
                p_init_msg_list,
                x_return_status,
                x_msg_count,
                x_msg_data,
                l_srev_rec,
                x_srev_rec);
Line: 838

 END update_subclass_roles;
Line: 840

 PROCEDURE update_subclass_roles(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_srev_tbl                     IN  srev_tbl_type,
    x_srev_tbl                     OUT NOCOPY srev_tbl_type) IS
    i				   NUMBER := 0;
Line: 855

        update_subclass_roles(
                p_api_version,
                p_init_msg_list,
                l_return_status,
                x_msg_count,
                x_msg_data,
                p_srev_tbl(i),
                x_srev_tbl(i));
Line: 886

 END update_subclass_roles;
Line: 888

 PROCEDURE delete_subclass_roles(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_srev_rec                     IN srev_rec_type) IS
    l_api_name                     CONSTANT VARCHAR2(30) := 'delete_subclass_roles';
Line: 917

    okc_subclass_pvt.delete_subclass_roles(
                p_api_version,
                p_init_msg_list,
                x_return_status,
                x_msg_count,
                x_msg_data,
                p_srev_rec);
Line: 963

 END delete_subclass_roles;
Line: 965

 PROCEDURE delete_subclass_roles(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_srev_tbl                     IN  srev_tbl_type) IS
    i				   NUMBER := 0;
Line: 979

        delete_subclass_roles(
                p_api_version,
                p_init_msg_list,
                l_return_status,
                x_msg_count,
                x_msg_data,
                p_srev_tbl(i));
Line: 1009

 END delete_subclass_roles;
Line: 1208

 PROCEDURE update_subclass_rg_defs(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_srdv_rec                     IN srdv_rec_type,
    x_srdv_rec                     OUT NOCOPY srdv_rec_type) IS
    l_api_name                     CONSTANT VARCHAR2(30) := 'update_subclass_rg_defs';
Line: 1239

    okc_subclass_pvt.update_subclass_rg_defs(
                p_api_version,
                p_init_msg_list,
                x_return_status,
                x_msg_count,
                x_msg_data,
                l_srdv_rec,
                x_srdv_rec);
Line: 1287

 END update_subclass_rg_defs;
Line: 1289

 PROCEDURE update_subclass_rg_defs(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_srdv_tbl                     IN  srdv_tbl_type,
    x_srdv_tbl                     OUT NOCOPY srdv_tbl_type) IS
    i				   NUMBER := 0;
Line: 1304

        update_subclass_rg_defs(
                p_api_version,
                p_init_msg_list,
                l_return_status,
                x_msg_count,
                x_msg_data,
                p_srdv_tbl(i),
                x_srdv_tbl(i));
Line: 1335

 END update_subclass_rg_defs;
Line: 1337

 PROCEDURE delete_subclass_rg_defs(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_srdv_rec                     IN srdv_rec_type) IS
    l_api_name                     CONSTANT VARCHAR2(30) := 'delete_subclass_rg_defs';
Line: 1366

    okc_subclass_pvt.delete_subclass_rg_defs(
                p_api_version,
                p_init_msg_list,
                x_return_status,
                x_msg_count,
                x_msg_data,
                p_srdv_rec);
Line: 1412

 END delete_subclass_rg_defs;
Line: 1414

 PROCEDURE delete_subclass_rg_defs(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_srdv_tbl                     IN  srdv_tbl_type) IS
    i				   NUMBER := 0;
Line: 1428

        delete_subclass_rg_defs(
                p_api_version,
                p_init_msg_list,
                l_return_status,
                x_msg_count,
                x_msg_data,
                p_srdv_tbl(i));
Line: 1458

 END delete_subclass_rg_defs;
Line: 1657

 PROCEDURE update_rg_role_defs(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_rrdv_rec                     IN rrdv_rec_type,
    x_rrdv_rec                     OUT NOCOPY rrdv_rec_type) IS
    l_api_name                     CONSTANT VARCHAR2(30) := 'update_rg_role_defs';
Line: 1688

    okc_subclass_pvt.update_rg_role_defs(
                p_api_version,
                p_init_msg_list,
                x_return_status,
                x_msg_count,
                x_msg_data,
                l_rrdv_rec,
                x_rrdv_rec);
Line: 1736

 END update_rg_role_defs;
Line: 1738

 PROCEDURE update_rg_role_defs(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_rrdv_tbl                     IN  rrdv_tbl_type,
    x_rrdv_tbl                     OUT NOCOPY rrdv_tbl_type) IS
    i				   NUMBER := 0;
Line: 1753

        update_rg_role_defs(
                p_api_version,
                p_init_msg_list,
                l_return_status,
                x_msg_count,
                x_msg_data,
                p_rrdv_tbl(i),
                x_rrdv_tbl(i));
Line: 1784

 END update_rg_role_defs;
Line: 1786

 PROCEDURE delete_rg_role_defs(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_rrdv_rec                     IN rrdv_rec_type) IS
    l_api_name                     CONSTANT VARCHAR2(30) := 'delete_rg_role_defs';
Line: 1815

    okc_subclass_pvt.delete_rg_role_defs(
                p_api_version,
                p_init_msg_list,
                x_return_status,
                x_msg_count,
                x_msg_data,
                p_rrdv_rec);
Line: 1861

 END delete_rg_role_defs;
Line: 1863

 PROCEDURE delete_rg_role_defs(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_rrdv_tbl                     IN  rrdv_tbl_type) IS
    i				   NUMBER := 0;
Line: 1877

        delete_rg_role_defs(
                p_api_version,
                p_init_msg_list,
                l_return_status,
                x_msg_count,
                x_msg_data,
                p_rrdv_tbl(i));
Line: 1907

 END delete_rg_role_defs;
Line: 2106

 PROCEDURE update_subclass_top_line(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_stlv_rec                     IN stlv_rec_type,
    x_stlv_rec                     OUT NOCOPY stlv_rec_type) IS
    l_api_name                     CONSTANT VARCHAR2(30) := 'update_subclass_top_line';
Line: 2137

    okc_subclass_pvt.update_subclass_top_line(
                p_api_version,
                p_init_msg_list,
                x_return_status,
                x_msg_count,
                x_msg_data,
                l_stlv_rec,
                x_stlv_rec);
Line: 2185

 END update_subclass_top_line;
Line: 2187

 PROCEDURE update_subclass_top_line(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_stlv_tbl                     IN  stlv_tbl_type,
    x_stlv_tbl                     OUT NOCOPY stlv_tbl_type) IS
    i				   NUMBER := 0;
Line: 2202

        update_subclass_top_line(
                p_api_version,
                p_init_msg_list,
                l_return_status,
                x_msg_count,
                x_msg_data,
                p_stlv_tbl(i),
                x_stlv_tbl(i));
Line: 2233

 END update_subclass_top_line;
Line: 2235

 PROCEDURE delete_subclass_top_line(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_stlv_rec                     IN stlv_rec_type) IS
    l_api_name                     CONSTANT VARCHAR2(30) := 'delete_subclass_top_line';
Line: 2264

    okc_subclass_pvt.delete_subclass_top_line(
                p_api_version,
                p_init_msg_list,
                x_return_status,
                x_msg_count,
                x_msg_data,
                p_stlv_rec);
Line: 2310

 END delete_subclass_top_line;
Line: 2312

 PROCEDURE delete_subclass_top_line(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_stlv_tbl                     IN  stlv_tbl_type) IS
    i				   NUMBER := 0;
Line: 2326

        delete_subclass_top_line(
                p_api_version,
                p_init_msg_list,
                l_return_status,
                x_msg_count,
                x_msg_data,
                p_stlv_tbl(i));
Line: 2356

 END delete_subclass_top_line;
Line: 2555

 PROCEDURE update_line_style_roles(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_lsrv_rec                     IN lsrv_rec_type,
    x_lsrv_rec                     OUT NOCOPY lsrv_rec_type) IS
    l_api_name                     CONSTANT VARCHAR2(30) := 'update_line_style_roles';
Line: 2586

    okc_subclass_pvt.update_line_style_roles(
                p_api_version,
                p_init_msg_list,
                x_return_status,
                x_msg_count,
                x_msg_data,
                l_lsrv_rec,
                x_lsrv_rec);
Line: 2634

 END update_line_style_roles;
Line: 2636

 PROCEDURE update_line_style_roles(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_lsrv_tbl                     IN  lsrv_tbl_type,
    x_lsrv_tbl                     OUT NOCOPY lsrv_tbl_type) IS
    i				   NUMBER := 0;
Line: 2651

        update_line_style_roles(
                p_api_version,
                p_init_msg_list,
                l_return_status,
                x_msg_count,
                x_msg_data,
                p_lsrv_tbl(i),
                x_lsrv_tbl(i));
Line: 2682

 END update_line_style_roles;
Line: 2684

 PROCEDURE delete_line_style_roles(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_lsrv_rec                     IN lsrv_rec_type) IS
    l_api_name                     CONSTANT VARCHAR2(30) := 'delete_line_style_roles';
Line: 2713

    okc_subclass_pvt.delete_line_style_roles(
                p_api_version,
                p_init_msg_list,
                x_return_status,
                x_msg_count,
                x_msg_data,
                p_lsrv_rec);
Line: 2759

 END delete_line_style_roles;
Line: 2761

 PROCEDURE delete_line_style_roles(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_lsrv_tbl                     IN  lsrv_tbl_type) IS
    i				   NUMBER := 0;
Line: 2775

        delete_line_style_roles(
                p_api_version,
                p_init_msg_list,
                l_return_status,
                x_msg_count,
                x_msg_data,
                p_lsrv_tbl(i));
Line: 2805

 END delete_line_style_roles;
Line: 3004

 PROCEDURE update_lse_rule_groups(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_lrgv_rec                     IN lrgv_rec_type,
    x_lrgv_rec                     OUT NOCOPY lrgv_rec_type) IS
    l_api_name                     CONSTANT VARCHAR2(30) := 'update_lse_rule_groups';
Line: 3035

    okc_subclass_pvt.update_lse_rule_groups(
                p_api_version,
                p_init_msg_list,
                x_return_status,
                x_msg_count,
                x_msg_data,
                l_lrgv_rec,
                x_lrgv_rec);
Line: 3083

 END update_lse_rule_groups;
Line: 3085

 PROCEDURE update_lse_rule_groups(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_lrgv_tbl                     IN  lrgv_tbl_type,
    x_lrgv_tbl                     OUT NOCOPY lrgv_tbl_type) IS
    i				   NUMBER := 0;
Line: 3100

        update_lse_rule_groups(
                p_api_version,
                p_init_msg_list,
                l_return_status,
                x_msg_count,
                x_msg_data,
                p_lrgv_tbl(i),
                x_lrgv_tbl(i));
Line: 3131

 END update_lse_rule_groups;
Line: 3133

 PROCEDURE delete_lse_rule_groups(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_lrgv_rec                     IN lrgv_rec_type) IS
    l_api_name                     CONSTANT VARCHAR2(30) := 'delete_lse_rule_groups';
Line: 3162

    okc_subclass_pvt.delete_lse_rule_groups(
                p_api_version,
                p_init_msg_list,
                x_return_status,
                x_msg_count,
                x_msg_data,
                p_lrgv_rec);
Line: 3208

 END delete_lse_rule_groups;
Line: 3210

 PROCEDURE delete_lse_rule_groups(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_lrgv_tbl                     IN  lrgv_tbl_type) IS
    i				   NUMBER := 0;
Line: 3224

        delete_lse_rule_groups(
                p_api_version,
                p_init_msg_list,
                l_return_status,
                x_msg_count,
                x_msg_data,
                p_lrgv_tbl(i));
Line: 3254

 END delete_lse_rule_groups;
Line: 3453

 PROCEDURE update_subclass_resps(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_srav_rec                     IN srav_rec_type,
    x_srav_rec                     OUT NOCOPY srav_rec_type) IS
    l_api_name                     CONSTANT VARCHAR2(30) := 'update_subclass_resps';
Line: 3484

    okc_subclass_pvt.update_subclass_resps(
                p_api_version,
                p_init_msg_list,
                x_return_status,
                x_msg_count,
                x_msg_data,
                l_srav_rec,
                x_srav_rec);
Line: 3532

 END update_subclass_resps;
Line: 3534

 PROCEDURE update_subclass_resps(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_srav_tbl                     IN  srav_tbl_type,
    x_srav_tbl                     OUT NOCOPY srav_tbl_type) IS
    i				   NUMBER := 0;
Line: 3549

        update_subclass_resps(
                p_api_version,
                p_init_msg_list,
                l_return_status,
                x_msg_count,
                x_msg_data,
                p_srav_tbl(i),
                x_srav_tbl(i));
Line: 3580

 END update_subclass_resps;
Line: 3582

 PROCEDURE delete_subclass_resps(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_srav_rec                     IN srav_rec_type) IS
    l_api_name                     CONSTANT VARCHAR2(30) := 'delete_subclass_resps';
Line: 3611

    okc_subclass_pvt.delete_subclass_resps(
                p_api_version,
                p_init_msg_list,
                x_return_status,
                x_msg_count,
                x_msg_data,
                p_srav_rec);
Line: 3657

 END delete_subclass_resps;
Line: 3659

 PROCEDURE delete_subclass_resps(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_srav_tbl                     IN  srav_tbl_type) IS
    i				   NUMBER := 0;
Line: 3673

        delete_subclass_resps(
                p_api_version,
                p_init_msg_list,
                l_return_status,
                x_msg_count,
                x_msg_data,
                p_srav_tbl(i));
Line: 3703

 END delete_subclass_resps;