APPS.OKC_REP_CONTRACT_IMP_PUB SQL Statements

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

Line: 87

  Procedure delete_contract(p_api_version       IN NUMBER,
                            p_contract_id       IN  NUMBER,
                            p_commit            IN VARCHAR2 := fnd_api.g_false,
                            x_msg_data          OUT NOCOPY  VARCHAR2,
                            x_msg_count         OUT NOCOPY  NUMBER,
                            x_return_status OUT NOCOPY VARCHAR2
  )
  IS

  l_api_name VARCHAR2(50);

Line: 100

   l_api_name := 'delete_contract';

Line: 112

    OKC_REP_CONTRACT_IMP_PVT.delete_contract( p_api_version           => p_api_version,
                                              p_contract_id           => p_contract_id,
                                              p_commit                => p_commit,
                                              x_msg_data              => x_msg_data,
                                              x_msg_count             => x_msg_count,
                                              x_return_status         => x_return_status);

Line: 125

  END delete_contract;

Line: 177

Deletes the Contract for the given document type.
*/

Procedure delete_contract(p_api_version            IN NUMBER,
                          p_document_rec           IN OKC_IMP_RECORD_TYPES.document_rec_type,
                          p_contract_type          IN VARCHAR2 DEFAULT NULL,
                          p_contract_id            IN NUMBER DEFAULT NULL,
                          p_commit                 IN VARCHAR2 := fnd_api.g_false,
                          x_msg_data               OUT NOCOPY  VARCHAR2,
                          x_msg_count              OUT NOCOPY  NUMBER,
                          x_return_status          OUT NOCOPY VARCHAR2
)
  IS

  l_api_name VARCHAR2(50);

Line: 195

   l_api_name := 'delete_contract';

Line: 207

    OKC_REP_CONTRACT_IMP_PVT.delete_contract( p_api_version           => p_api_version,
                                              p_document_rec          => p_document_rec,
                                              p_contract_type         => p_contract_type,
                                              p_contract_id           => p_contract_id,
                                              p_commit                => p_commit,
                                              x_msg_data              => x_msg_data,
                                              x_msg_count             => x_msg_count,
                                              x_return_status         => x_return_status);

Line: 222

  END delete_contract;

Line: 226

Updates to the contract should be done from UI.
*/

Procedure create_new_contract_version(p_api_version            IN NUMBER,
                                      p_contract_id            IN NUMBER,
                                      p_commit                 IN VARCHAR2 := fnd_api.g_false,
                                      x_msg_data               OUT NOCOPY  VARCHAR2,
                                      x_msg_count              OUT NOCOPY  NUMBER,
                                      x_return_status          OUT NOCOPY VARCHAR2
)
  IS

  l_api_name       VARCHAR2(50);

Line: 260

     SELECT okc_rep_import_run_id_s.NEXTVAL INTO l_run_id FROM dual;

Line: 287

Updates to the contract should be done from UI.

The relation of parent document which is obtained in p_document_rec is stored in the okc_rep_contract_usages table
*/

Procedure create_new_contract_version(p_api_version            IN NUMBER,
                                      p_document_rec           IN OKC_IMP_RECORD_TYPES.document_rec_type,
                                      p_contract_type          IN VARCHAR2 DEFAULT NULL,
                                      p_contract_id          IN NUMBER DEFAULT NULL,
                                      p_commit                 IN VARCHAR2 := fnd_api.g_false,
                                      x_msg_data               OUT NOCOPY  VARCHAR2,
                                      x_msg_count              OUT NOCOPY  NUMBER,
                                      x_return_status          OUT NOCOPY VARCHAR2
)
  IS

  l_api_name VARCHAR2(50);

Line: 326

    SELECT okc_rep_import_run_id_s.NEXTVAL INTO l_run_id FROM dual;

Line: 575

Procedure delete_cancel_contract(p_api_version            IN NUMBER,
                                p_commit                 IN VARCHAR2 := fnd_api.g_false,
                                p_document_rec           IN OKC_IMP_RECORD_TYPES.document_rec_type,
                                p_contract_type          IN VARCHAR2 DEFAULT NULL,
                                p_contract_id            IN NUMBER DEFAULT NULL,
                                x_msg_data               OUT NOCOPY  VARCHAR2,
                                x_msg_count              OUT NOCOPY  NUMBER,
                                x_return_status          OUT NOCOPY VARCHAR2)
IS

  l_api_name VARCHAR2(50);

Line: 590

   l_api_name := 'delete_cancel_contract';

Line: 613

    OKC_REP_CONTRACT_IMP_PVT.delete_cancel_contract(p_api_version      => p_api_version,
                        p_document_rec     => p_document_rec ,
                        p_contract_type    => p_contract_type,
                        p_contract_id      => p_contract_id,
                        p_commit           => p_commit,
                        x_msg_data         => x_msg_data,
                        x_msg_count        => x_msg_count,
                        x_return_status    => x_return_status);

Line: 626

END delete_cancel_contract;