APPS.OKL_UBB_WF_PVT SQL Statements

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

Line: 5

  G_WF_EVT_UBB_UPDATED CONSTANT VARCHAR2(55) := 'oracle.apps.okl.la.lease_contract.usage_billing_updated';

Line: 90

  PROCEDURE raise_update_event (p_api_version    IN  NUMBER,
                         p_init_msg_list  IN  VARCHAR2 DEFAULT OKL_API.G_FALSE,
                         x_return_status  OUT NOCOPY VARCHAR2,
                         x_msg_count      OUT NOCOPY NUMBER,
                         x_msg_data       OUT NOCOPY VARCHAR2,
                         p_chr_id         IN NUMBER,
                         p_ubb_id         IN NUMBER)
  IS
    l_api_name                        CONSTANT VARCHAR2(30)  := 'raise_udpate_event';

Line: 129

								 p_event_name     => G_WF_EVT_UBB_UPDATED,
								 p_parameters     => l_parameter_list);

Line: 163

  END raise_update_event;

Line: 165

  PROCEDURE raise_delete_event (p_api_version    IN  NUMBER,
                         p_init_msg_list  IN  VARCHAR2 DEFAULT OKL_API.G_FALSE,
                         x_return_status  OUT NOCOPY VARCHAR2,
                         x_msg_count      OUT NOCOPY NUMBER,
                         x_msg_data       OUT NOCOPY VARCHAR2,
                         p_chr_id         IN NUMBER,
                         p_ubb_id         IN NUMBER)
  IS
    l_api_name                        CONSTANT VARCHAR2(30)  := 'raise_delete_event';

Line: 238

  END raise_delete_event;

Line: 318

  PROCEDURE raise_delete_asset_event (p_api_version    IN  NUMBER,
                         p_init_msg_list  IN  VARCHAR2 DEFAULT OKL_API.G_FALSE,
                         x_return_status  OUT NOCOPY VARCHAR2,
                         x_msg_count      OUT NOCOPY NUMBER,
                         x_msg_data       OUT NOCOPY VARCHAR2,
                         p_chr_id         IN NUMBER,
                         p_ubb_id         IN NUMBER,
                         p_cle_id         IN NUMBER)
  IS
    l_api_name                        CONSTANT VARCHAR2(30)  := 'raise_delete_asset_event';

Line: 393

  END raise_delete_asset_event;