APPS.CZ_CONTRACTS_API_GRP SQL Statements

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

Line: 65

PROCEDURE delete_model(p_api_version          IN  NUMBER
                      ,p_model_id             IN  NUMBER
                      ,p_orig_sys_ref         IN  VARCHAR2
                      ,x_return_status        OUT NOCOPY  VARCHAR2
                      ,x_msg_count            OUT NOCOPY  NUMBER
                      ,x_msg_data             OUT NOCOPY  VARCHAR2)
IS

 l_api_version  CONSTANT NUMBER := 1.0;

Line: 74

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

Line: 85

    SELECT 1 into l_dummy_nbr
    FROM cz_devl_projects
    WHERE devl_project_id = p_model_id
    AND orig_sys_ref = p_orig_sys_ref
    AND deleted_flag = '0';

Line: 97

  cz_developer_utils_pvt.delete_model(p_model_id
                                     ,x_return_status
                                     ,x_msg_count
                                     ,x_msg_data);

Line: 115

END delete_model;

Line: 223

l_lang_tbl.DELETE;

Line: 224

l_usg_tbl.DELETE;

Line: 225

l_appl_tbl.DELETE;

Line: 269

PROCEDURE DELETE_PUBLICATION(p_api_version     IN NUMBER,
                             publicationId   IN NUMBER,
                             x_return_status OUT NOCOPY VARCHAR2,
                             x_msg_count     OUT NOCOPY NUMBER,
                             x_msg_data      OUT NOCOPY VARCHAR2
                            )
IS

BEGIN
   cz_pb_mgr.delete_publication(publicationId,x_return_status,x_msg_count,x_msg_data);

Line: 282

   FND_MESSAGE.SET_NAME('CZ', 'CZ_DELETE_PUB_ERR');

Line: 287

END DELETE_PUBLICATION;

Line: 289

PROCEDURE delete_ui_def(p_api_version              IN   NUMBER,
                        p_ui_def_id                IN   NUMBER,
                        x_return_status            OUT  NOCOPY   VARCHAR2,
                        x_msg_count                OUT  NOCOPY   NUMBER,
                        x_msg_data                 OUT  NOCOPY   VARCHAR2
                        ) IS
 l_api_name      CONSTANT VARCHAR2(30) := 'delete_ui_def';

Line: 304

 cz_developer_utils_pvt.delete_ui_def(p_ui_def_id,
                                      x_return_status,
                                      x_msg_count,
                                      x_msg_data);

Line: 319

END delete_ui_def;

Line: 346

   FOR i IN (SELECT message FROM cz_db_logs
             WHERE run_id = x_run_id)
   LOOP
      FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME,l_api_name,i.message);

Line: 397

   FOR i IN (SELECT message FROM cz_db_logs
             WHERE run_id = x_run_id)
   LOOP
      FND_MSG_PUB.ADD_EXC_MSG(G_PKG_NAME,l_api_name,i.message);

Line: 435

 FOR i IN(SELECT ui_def_id FROM CZ_UI_DEFS
           WHERE devl_project_id=p_devl_project_id AND
                 ui_style='7' AND
                 deleted_flag='0')
 LOOP
    cz_modeloperations_pub.refresh_jrad_ui(p_api_version   => 1.0,
                                           p_ui_def_id     => i.ui_def_id,
                                           x_return_status => x_return_status,
                                           x_msg_count     => x_msg_count,
                                           x_msg_data      => x_msg_data);