APPS.AST_WEBSWITCH_VUHK SQL Statements

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

Line: 81

  PROCEDURE Update_WebSwitch_Pre(
                      p_api_version              IN NUMBER,
                      p_init_msg_list            IN VARCHAR2 DEFAULT FND_API.G_FALSE,
                      p_commit                   IN VARCHAR2 DEFAULT FND_API.G_FALSE,
                      p_validation_level         IN NUMBER DEFAULT
                                                    FND_API.G_VALID_LEVEL_FULL,
                      x_return_status            OUT VARCHAR2,
                      x_msg_count                OUT NUMBER,
                      x_msg_data                 OUT VARCHAR2,
                      p_cgi_switch_rec           IN ast_WebSwitch_PVT.cgi_switch_rec_type,
                      p_switch_data_rec          IN ast_WebSwitch_PVT.switch_data_rec_type
                      )
  AS

  BEGIN
    /* Vertical to add the customization PROCEDUREs here - for post processing */
    null;

Line: 101

  PROCEDURE Update_WebSwitch_Post(
                      p_api_version              IN NUMBER,
                      p_init_msg_list            IN VARCHAR2 DEFAULT FND_API.G_FALSE,
                      p_commit                   IN VARCHAR2 DEFAULT FND_API.G_FALSE,
                      p_validation_level         IN NUMBER DEFAULT
                                                    FND_API.G_VALID_LEVEL_FULL,
                      x_return_status            OUT VARCHAR2,
                      x_msg_count                OUT NUMBER,
                      x_msg_data                 OUT VARCHAR2,
                      p_cgi_switch_rec           IN ast_WebSwitch_PVT.cgi_switch_rec_type,
                      p_switch_data_rec          IN ast_WebSwitch_PVT.switch_data_rec_type
                      )
  AS

  BEGIN
    /* Vertical to add the customization PROCEDUREs here - for post processing */
    null;

Line: 120

  PROCEDURE Delete_WebSwitch_Pre(
                      p_api_version              IN NUMBER,
                      p_init_msg_list            IN VARCHAR2 DEFAULT FND_API.G_FALSE,
                      p_commit                   IN VARCHAR2 DEFAULT FND_API.G_FALSE,
                      p_validation_level         IN NUMBER DEFAULT
                                                    FND_API.G_VALID_LEVEL_FULL,
                      x_return_status            OUT VARCHAR2,
                      x_msg_count                OUT NUMBER,
                      x_msg_data                 OUT VARCHAR2,
                      p_cgi_switch_rec           IN ast_WebSwitch_PVT.cgi_switch_rec_type,
                      p_switch_data_rec          IN ast_WebSwitch_PVT.switch_data_rec_type
                      )
  AS

  BEGIN
    /* Vertical to add the customization PROCEDUREs here - for post processing */
    null;

Line: 139

  PROCEDURE Delete_WebSwitch_Post(
                      p_api_version              IN NUMBER,
                      p_init_msg_list            IN VARCHAR2 DEFAULT FND_API.G_FALSE,
                      p_commit                   IN VARCHAR2 DEFAULT FND_API.G_FALSE,
                      p_validation_level         IN NUMBER DEFAULT
                                                    FND_API.G_VALID_LEVEL_FULL,
                      x_return_status            OUT VARCHAR2,
                      x_msg_count                OUT NUMBER,
                      x_msg_data                 OUT VARCHAR2,
                      p_cgi_switch_rec           IN ast_WebSwitch_PVT.cgi_switch_rec_type,
                      p_switch_data_rec          IN ast_WebSwitch_PVT.switch_data_rec_type
                      )
  AS

  BEGIN
    /* Vertical to add the customization PROCEDUREs here - for post processing */
    null;