DBA Data[Home] [Help]

APPS.OKC_SUBCLASS_PVT SQL Statements

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

Line: 20

    okc_scs_pvt.insert_row(
                p_api_version,
                p_init_msg_list,
                x_return_status,
                x_msg_count,
                x_msg_data,
                p_scsv_rec,
                x_scsv_rec);
Line: 39

    okc_scs_pvt.insert_row(
                p_api_version,
                p_init_msg_list,
                x_return_status,
                x_msg_count,
                x_msg_data,
                p_scsv_tbl,
                x_scsv_tbl);
Line: 50

 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
 BEGIN
    okc_scs_pvt.update_row(
                p_api_version,
                p_init_msg_list,
                x_return_status,
                x_msg_count,
                x_msg_data,
                p_scsv_rec,
                x_scsv_rec);
Line: 67

 END update_subclass;
Line: 70

 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
 BEGIN
    okc_scs_pvt.update_row(
                p_api_version,
                p_init_msg_list,
                x_return_status,
                x_msg_count,
                x_msg_data,
                p_scsv_tbl,
                x_scsv_tbl);
Line: 87

 END update_subclass;
Line: 89

 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
 BEGIN
    okc_scs_pvt.delete_row(
                p_api_version,
                p_init_msg_list,
                x_return_status,
                x_msg_count,
                x_msg_data,
                p_scsv_rec);
Line: 104

 END delete_subclass;
Line: 106

 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
 BEGIN
    okc_scs_pvt.delete_row(
                p_api_version,
                p_init_msg_list,
                x_return_status,
                x_msg_count,
                x_msg_data,
                p_scsv_tbl);
Line: 121

 END delete_subclass;
Line: 200

    okc_sre_pvt.insert_row(
                p_api_version,
                p_init_msg_list,
                x_return_status,
                x_msg_count,
                x_msg_data,
                p_srev_rec,
                x_srev_rec);
Line: 219

    okc_sre_pvt.insert_row(
                p_api_version,
                p_init_msg_list,
                x_return_status,
                x_msg_count,
                x_msg_data,
                p_srev_tbl,
                x_srev_tbl);
Line: 229

 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
 BEGIN
    okc_sre_pvt.update_row(
                p_api_version,
                p_init_msg_list,
                x_return_status,
                x_msg_count,
                x_msg_data,
                p_srev_rec,
                x_srev_rec);
Line: 246

 END update_subclass_roles;
Line: 248

 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
 BEGIN
    okc_sre_pvt.update_row(
                p_api_version,
                p_init_msg_list,
                x_return_status,
                x_msg_count,
                x_msg_data,
                p_srev_tbl,
                x_srev_tbl);
Line: 265

 END update_subclass_roles;
Line: 267

 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
 BEGIN
    okc_sre_pvt.delete_row(
                p_api_version,
                p_init_msg_list,
                x_return_status,
                x_msg_count,
                x_msg_data,
                p_srev_rec);
Line: 282

 END delete_subclass_roles;
Line: 284

 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
 BEGIN
    okc_sre_pvt.delete_row(
                p_api_version,
                p_init_msg_list,
                x_return_status,
                x_msg_count,
                x_msg_data,
                p_srev_tbl);
Line: 299

 END delete_subclass_roles;
Line: 378

    okc_srd_pvt.insert_row(
                p_api_version,
                p_init_msg_list,
                x_return_status,
                x_msg_count,
                x_msg_data,
                p_srdv_rec,
                x_srdv_rec);
Line: 397

    okc_srd_pvt.insert_row(
                p_api_version,
                p_init_msg_list,
                x_return_status,
                x_msg_count,
                x_msg_data,
                p_srdv_tbl,
                x_srdv_tbl);
Line: 407

 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
 BEGIN
    okc_srd_pvt.update_row(
                p_api_version,
                p_init_msg_list,
                x_return_status,
                x_msg_count,
                x_msg_data,
                p_srdv_rec,
                x_srdv_rec);
Line: 424

 END update_subclass_rg_defs;
Line: 426

 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
 BEGIN
    okc_srd_pvt.update_row(
                p_api_version,
                p_init_msg_list,
                x_return_status,
                x_msg_count,
                x_msg_data,
                p_srdv_tbl,
                x_srdv_tbl);
Line: 443

 END update_subclass_rg_defs;
Line: 445

 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
 BEGIN
    okc_srd_pvt.delete_row(
                p_api_version,
                p_init_msg_list,
                x_return_status,
                x_msg_count,
                x_msg_data,
                p_srdv_rec);
Line: 460

 END delete_subclass_rg_defs;
Line: 462

 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
 BEGIN
    okc_srd_pvt.delete_row(
                p_api_version,
                p_init_msg_list,
                x_return_status,
                x_msg_count,
                x_msg_data,
                p_srdv_tbl);
Line: 477

 END delete_subclass_rg_defs;
Line: 556

    okc_rrd_pvt.insert_row(
                p_api_version,
                p_init_msg_list,
                x_return_status,
                x_msg_count,
                x_msg_data,
                p_rrdv_rec,
                x_rrdv_rec);
Line: 575

    okc_rrd_pvt.insert_row(
                p_api_version,
                p_init_msg_list,
                x_return_status,
                x_msg_count,
                x_msg_data,
                p_rrdv_tbl,
                x_rrdv_tbl);
Line: 585

 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
 BEGIN
    okc_rrd_pvt.update_row(
                p_api_version,
                p_init_msg_list,
                x_return_status,
                x_msg_count,
                x_msg_data,
                p_rrdv_rec,
                x_rrdv_rec);
Line: 602

 END update_rg_role_defs;
Line: 604

 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
 BEGIN
    okc_rrd_pvt.update_row(
                p_api_version,
                p_init_msg_list,
                x_return_status,
                x_msg_count,
                x_msg_data,
                p_rrdv_tbl,
                x_rrdv_tbl);
Line: 621

 END update_rg_role_defs;
Line: 623

 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
 BEGIN
    okc_rrd_pvt.delete_row(
                p_api_version,
                p_init_msg_list,
                x_return_status,
                x_msg_count,
                x_msg_data,
                p_rrdv_rec);
Line: 638

 END delete_rg_role_defs;
Line: 640

 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
 BEGIN
    okc_rrd_pvt.delete_row(
                p_api_version,
                p_init_msg_list,
                x_return_status,
                x_msg_count,
                x_msg_data,
                p_rrdv_tbl);
Line: 655

 END delete_rg_role_defs;
Line: 734

    okc_stl_pvt.insert_row(
                p_api_version,
                p_init_msg_list,
                x_return_status,
                x_msg_count,
                x_msg_data,
                p_stlv_rec,
                x_stlv_rec);
Line: 753

    okc_stl_pvt.insert_row(
                p_api_version,
                p_init_msg_list,
                x_return_status,
                x_msg_count,
                x_msg_data,
                p_stlv_tbl,
                x_stlv_tbl);
Line: 763

 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
 BEGIN
    okc_stl_pvt.update_row(
                p_api_version,
                p_init_msg_list,
                x_return_status,
                x_msg_count,
                x_msg_data,
                p_stlv_rec,
                x_stlv_rec);
Line: 780

 END update_subclass_top_line;
Line: 782

 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
 BEGIN
    okc_stl_pvt.update_row(
                p_api_version,
                p_init_msg_list,
                x_return_status,
                x_msg_count,
                x_msg_data,
                p_stlv_tbl,
                x_stlv_tbl);
Line: 799

 END update_subclass_top_line;
Line: 801

 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
 BEGIN
    okc_stl_pvt.delete_row(
                p_api_version,
                p_init_msg_list,
                x_return_status,
                x_msg_count,
                x_msg_data,
                p_stlv_rec);
Line: 816

 END delete_subclass_top_line;
Line: 818

 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
 BEGIN
    okc_stl_pvt.delete_row(
                p_api_version,
                p_init_msg_list,
                x_return_status,
                x_msg_count,
                x_msg_data,
                p_stlv_tbl);
Line: 833

 END delete_subclass_top_line;
Line: 912

    okc_lsr_pvt.insert_row(
                p_api_version,
                p_init_msg_list,
                x_return_status,
                x_msg_count,
                x_msg_data,
                p_lsrv_rec,
                x_lsrv_rec);
Line: 931

    okc_lsr_pvt.insert_row(
                p_api_version,
                p_init_msg_list,
                x_return_status,
                x_msg_count,
                x_msg_data,
                p_lsrv_tbl,
                x_lsrv_tbl);
Line: 941

 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
 BEGIN
    okc_lsr_pvt.update_row(
                p_api_version,
                p_init_msg_list,
                x_return_status,
                x_msg_count,
                x_msg_data,
                p_lsrv_rec,
                x_lsrv_rec);
Line: 958

 END update_line_style_roles;
Line: 960

 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
 BEGIN
    okc_lsr_pvt.update_row(
                p_api_version,
                p_init_msg_list,
                x_return_status,
                x_msg_count,
                x_msg_data,
                p_lsrv_tbl,
                x_lsrv_tbl);
Line: 977

 END update_line_style_roles;
Line: 979

 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
 BEGIN
    okc_lsr_pvt.delete_row(
                p_api_version,
                p_init_msg_list,
                x_return_status,
                x_msg_count,
                x_msg_data,
                p_lsrv_rec);
Line: 994

 END delete_line_style_roles;
Line: 996

 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
 BEGIN
    okc_lsr_pvt.delete_row(
                p_api_version,
                p_init_msg_list,
                x_return_status,
                x_msg_count,
                x_msg_data,
                p_lsrv_tbl);
Line: 1011

 END delete_line_style_roles;
Line: 1090

    okc_lrg_pvt.insert_row(
                p_api_version,
                p_init_msg_list,
                x_return_status,
                x_msg_count,
                x_msg_data,
                p_lrgv_rec,
                x_lrgv_rec);
Line: 1109

    okc_lrg_pvt.insert_row(
                p_api_version,
                p_init_msg_list,
                x_return_status,
                x_msg_count,
                x_msg_data,
                p_lrgv_tbl,
                x_lrgv_tbl);
Line: 1119

 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
 BEGIN
    okc_lrg_pvt.update_row(
                p_api_version,
                p_init_msg_list,
                x_return_status,
                x_msg_count,
                x_msg_data,
                p_lrgv_rec,
                x_lrgv_rec);
Line: 1136

 END update_lse_rule_groups;
Line: 1138

 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
 BEGIN
    okc_lrg_pvt.update_row(
                p_api_version,
                p_init_msg_list,
                x_return_status,
                x_msg_count,
                x_msg_data,
                p_lrgv_tbl,
                x_lrgv_tbl);
Line: 1155

 END update_lse_rule_groups;
Line: 1157

 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
 BEGIN
    okc_lrg_pvt.delete_row(
                p_api_version,
                p_init_msg_list,
                x_return_status,
                x_msg_count,
                x_msg_data,
                p_lrgv_rec);
Line: 1172

 END delete_lse_rule_groups;
Line: 1174

 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
 BEGIN
    okc_lrg_pvt.delete_row(
                p_api_version,
                p_init_msg_list,
                x_return_status,
                x_msg_count,
                x_msg_data,
                p_lrgv_tbl);
Line: 1189

 END delete_lse_rule_groups;
Line: 1268

    okc_sra_pvt.insert_row(
                p_api_version,
                p_init_msg_list,
                x_return_status,
                x_msg_count,
                x_msg_data,
                p_srav_rec,
                x_srav_rec);
Line: 1287

    okc_sra_pvt.insert_row(
                p_api_version,
                p_init_msg_list,
                x_return_status,
                x_msg_count,
                x_msg_data,
                p_srav_tbl,
                x_srav_tbl);
Line: 1297

 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
 BEGIN
    okc_sra_pvt.update_row(
                p_api_version,
                p_init_msg_list,
                x_return_status,
                x_msg_count,
                x_msg_data,
                p_srav_rec,
                x_srav_rec);
Line: 1314

 END update_subclass_resps;
Line: 1316

 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
 BEGIN
    okc_sra_pvt.update_row(
                p_api_version,
                p_init_msg_list,
                x_return_status,
                x_msg_count,
                x_msg_data,
                p_srav_tbl,
                x_srav_tbl);
Line: 1333

 END update_subclass_resps;
Line: 1335

 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
 BEGIN
    okc_sra_pvt.delete_row(
                p_api_version,
                p_init_msg_list,
                x_return_status,
                x_msg_count,
                x_msg_data,
                p_srav_rec);
Line: 1350

 END delete_subclass_resps;
Line: 1352

 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
 BEGIN
    okc_sra_pvt.delete_row(
                p_api_version,
                p_init_msg_list,
                x_return_status,
                x_msg_count,
                x_msg_data,
                p_srav_tbl);
Line: 1367

 END delete_subclass_resps;
Line: 1477

	 SELECT
	 cls_code,
	 meaning ,
         description,
	 start_date,
         end_date ,
	 create_opp_yn ,
	 access_level
FROM okc_subclasses_v
WHERE code=b_scs_code;
Line: 1491

 SELECT
  id,
  rle_code  ,
  scs_code  ,
  start_date ,
  end_date ,
  access_level
FROM okc_subclass_roles_v
WHERE scs_code=b_scs_code;
Line: 1503

SELECT
  id,
  rgd_code,
  scs_code,
  start_date,
  end_date,
  access_level
FROM okc_subclass_rg_defs_v
WHERE scs_code=b_scs_code;
Line: 1516

SELECT
  srd_id,
  sre_id,
  subject_object_flag,
  optional_yn,
  attribute_category,
  attribute1,
  attribute2,
  attribute3,
  attribute4,
  attribute5,
  attribute6,
  attribute7,
  attribute8,
  attribute9,
  attribute10,
  attribute11,
  attribute12,
  attribute13,
  attribute14,
  attribute15,
  access_level
FROM okc_rg_role_defs_v
WHERE srd_id IN
	  ( SELECT id FROM okc_subclass_rg_defs_v WHERE scs_code=b_scs_code)
AND sre_id IN
    (SELECT id FROM  okc_subclass_roles_v WHERE scs_code=b_scs_code);
Line: 1548

SELECT
 lse_id,
 scs_code,
 start_date,
 end_date,
 access_level
FROM okc_subclass_top_line_v
WHERE scs_code=b_scs_code;
Line: 1561

SELECT
   lse_id,
   sre_id,
   access_level
FROM OKC_LINE_STYLE_ROLES_v
WHERE sre_id IN
    (SELECT id FROM  okc_subclass_roles_v WHERE scs_code=b_scs_code);
Line: 1573

SELECT
     lse_id,
     srd_id,
     access_level
FROM OKC_LSE_RULE_GROUPS_v
WHERE srd_id IN
   ( SELECT id FROM okc_subclass_rg_defs_v WHERE scs_code=b_scs_code);
Line: 1585

SELECT
 resp_id,
 scs_code,
 access_level,
 start_date,
 end_date
FROM OKC_subclass_resps_v
WHERE scs_code=b_scs_code;
Line: 1598

SELECT
 sts_code,
 opn_code,
 ste_code,
 scs_code,
 allowed_yn ,
 attribute_category ,
 attribute1,
 attribute2,
 attribute3,
 attribute4,
 attribute5,
 attribute6,
 attribute7,
 attribute8,
 attribute9,
 attribute10,
 attribute11,
 attribute12,
 attribute13,
 attribute14,
 attribute15
 FROM okc_assents_v
 WHERE scs_code=b_scs_code;
Line: 1742

sre_relationship_tbl.delete;
Line: 1743

srd_relationship_tbl.delete;
Line: 1797

    l_srev_tbl.delete;
Line: 1798

    lx_srev_tbl.delete;
Line: 1862

    l_srdv_tbl.delete;
Line: 1863

    lx_srdv_tbl.delete;
Line: 1929

    l_rrdv_tbl.delete;
Line: 1930

    lx_rrdv_tbl.delete;
Line: 2009

    l_stlv_tbl.delete;
Line: 2010

    lx_stlv_tbl.delete;
Line: 2068

    l_lsrv_tbl.delete;
Line: 2069

    lx_lsrv_tbl.delete;
Line: 2127

    l_lrgv_tbl.delete;
Line: 2128

    lx_lrgv_tbl.delete;
Line: 2188

    l_srav_tbl.delete;
Line: 2189

    lx_srav_tbl.delete;
Line: 2248

    l_astv_tbl.delete;
Line: 2249

    lx_astv_tbl.delete;