DBA Data[Home] [Help]

APPS.OKS_TEMPLATE_SET_PUB SQL Statements

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

Line: 367

  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_tmsv_rec                     IN tmsv_rec_type,
    x_tmsv_rec                     OUT NOCOPY tmsv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 377

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_insert_row';
Line: 405

    OKS_TEMPLATE_SET_PVT.insert_row(p_api_version        => l_api_version,
                                      p_init_msg_list      => p_init_msg_list,
                                      x_return_status      => x_return_status,
                                      x_msg_count          => x_msg_count,
                                      x_msg_data           => x_msg_data,
                                      p_tmsv_rec           => p_tmsv_rec,
                                      x_tmsv_rec           => x_tmsv_rec);
Line: 467

  END insert_row;
Line: 471

  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_tmsv_tbl                     IN tmsv_tbl_type,
    x_tmsv_tbl                     OUT NOCOPY tmsv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 482

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_error_tbl_insert_row';
Line: 511

    OKS_TEMPLATE_SET_PVT.insert_row(p_api_version        => l_api_version,
                                      p_init_msg_list      => p_init_msg_list,
                                      x_return_status      => x_return_status,
                                      x_msg_count          => x_msg_count,
                                      x_msg_data           => x_msg_data,
                                      p_tmsv_tbl           => p_tmsv_tbl,
                                      x_tmsv_tbl           => x_tmsv_tbl,
                                      px_error_tbl         => px_error_tbl);
Line: 573

  END insert_row;
Line: 578

  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_tmsv_tbl                     IN tmsv_tbl_type,
    x_tmsv_tbl                     OUT NOCOPY tmsv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 588

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
Line: 617

    OKS_TEMPLATE_SET_PVT.insert_row(p_api_version        => l_api_version,
                                      p_init_msg_list      => p_init_msg_list,
                                      x_return_status      => x_return_status,
                                      x_msg_count          => x_msg_count,
                                      x_msg_data           => x_msg_data,
                                      p_tmsv_tbl           => p_tmsv_tbl,
                                      x_tmsv_tbl           => x_tmsv_tbl);
Line: 679

  END insert_row;
Line: 998

  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_tmsv_rec                     IN tmsv_rec_type,
    x_tmsv_rec                     OUT NOCOPY tmsv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1008

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_update_row';
Line: 1036

    OKS_TEMPLATE_SET_PVT.update_row(p_api_version        => l_api_version,
                                      p_init_msg_list      => p_init_msg_list,
                                      x_return_status      => x_return_status,
                                      x_msg_count          => x_msg_count,
                                      x_msg_data           => x_msg_data,
                                      p_tmsv_rec           => p_tmsv_rec,
                                      x_tmsv_rec           =>  x_tmsv_rec);
Line: 1099

  END update_row;
Line: 1103

  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_tmsv_tbl                     IN tmsv_tbl_type,
    x_tmsv_tbl                     OUT NOCOPY tmsv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1114

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_error_tbl_update_row';
Line: 1143

    OKS_TEMPLATE_SET_PVT.update_row(p_api_version        => l_api_version,
                                      p_init_msg_list      => p_init_msg_list,
                                      x_return_status      => x_return_status,
                                      x_msg_count          => x_msg_count,
                                      x_msg_data           => x_msg_data,
                                      p_tmsv_tbl           => p_tmsv_tbl,
                                      x_tmsv_tbl           => x_tmsv_tbl,
                                      px_error_tbl         => px_error_tbl);
Line: 1206

  END update_row;
Line: 1211

  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_tmsv_tbl                     IN tmsv_tbl_type,
    x_tmsv_tbl                     OUT NOCOPY tmsv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1221

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
Line: 1250

    OKS_TEMPLATE_SET_PVT.update_row(p_api_version        => l_api_version,
                                      p_init_msg_list      => p_init_msg_list,
                                      x_return_status      => x_return_status,
                                      x_msg_count          => x_msg_count,
                                      x_msg_data           => x_msg_data,
                                      p_tmsv_tbl           => p_tmsv_tbl,
                                      x_tmsv_tbl           => x_tmsv_tbl);
Line: 1312

  END update_row;
Line: 1320

  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_tmsv_rec                     IN tmsv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1329

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_delete_row';
Line: 1357

    OKS_TEMPLATE_SET_PVT.delete_row(p_api_version        => l_api_version,
                                      p_init_msg_list      => p_init_msg_list,
                                      x_return_status      => x_return_status,
                                      x_msg_count          => x_msg_count,
                                      x_msg_data           => x_msg_data,
                                      p_tmsv_rec            => p_tmsv_rec);
Line: 1418

  END delete_row;
Line: 1422

  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_tmsv_tbl                     IN tmsv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1432

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_error_tbl_delete_row';
Line: 1461

    OKS_TEMPLATE_SET_PVT.delete_row(p_api_version        => l_api_version,
                                      p_init_msg_list      => p_init_msg_list,
                                      x_return_status      => x_return_status,
                                      x_msg_count          => x_msg_count,
                                      x_msg_data           => x_msg_data,
                                      p_tmsv_tbl           => p_tmsv_tbl,
                                      px_error_tbl         => px_error_tbl);
Line: 1523

  END delete_row;
Line: 1528

  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_tmsv_tbl                     IN tmsv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1537

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
Line: 1566

    OKS_TEMPLATE_SET_PVT.delete_row(p_api_version        => l_api_version,
                                      p_init_msg_list      => p_init_msg_list,
                                      x_return_status      => x_return_status,
                                      x_msg_count          => x_msg_count,
                                      x_msg_data           => x_msg_data,
                                      p_tmsv_tbl           => p_tmsv_tbl);
Line: 1628

  END delete_row;
Line: 1642

 x_contract_update_status OUT NOCOPY VARCHAR2,
 x_return_status          OUT NOCOPY VARCHAR2,
 x_msg_data	          OUT NOCOPY VARCHAR2,
 x_msg_count	          OUT NOCOPY NUMBER
) AS

l_api_name                 CONSTANT VARCHAR2(30) := 'get_template_set_dtls';
Line: 1658

SELECT DECODE(renewal_type_used,NULL,'N','R')
  FROM oks_k_headers_b
 WHERE chr_id = p_contract_id;
Line: 1666

SELECT r.report_id,
       r.message_template_id,
       r.sts_code,
       r.attachment_name
 FROM oks_report_templates r
WHERE r.template_set_id = p_template_set_id
  AND r.template_set_type= p_document_type
  AND  ( DECODE(r.process_code,'B','B','X') = 'B' OR
            r.process_code  = p_process_code)
  AND  ( DECODE(r.applies_to,'B','B','X') = 'B' OR
            r.applies_to  = p_applies_to)
  AND sysdate BETWEEN r.START_DATE AND NVL(r.end_date,SYSDATE+1)
  AND NVL(r.report_period,'X') = NVL(p_report_period, NVL(r.report_period,'X'))
  AND NVL(r.report_duration,-99) = NVL(p_report_duration, NVL(r.report_duration,-99)) ;
Line: 1682

SELECT wf_item_key
  FROM oks_k_headers_b
 WHERE chr_id = p_contract_id;
Line: 1687

SELECT template_name
  FROM xdo_templates_vl
 WHERE template_id=p_attachment_template_id;
Line: 1828

                                     x_contract_update_status,
                                     x_attachment_name ;
Line: 1849

             '300: x_contract_update_status  : '||x_contract_update_status);