APPS.WSH_BULK_PROCESS_GRP SQL Statements

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

Line: 26

  PROCEDURE Create_update_delivery_details(
                  p_api_version_number IN   NUMBER,
                  p_init_msg_list          IN   VARCHAR2,
                  p_commit         IN   VARCHAR2,
                  p_action_prms      IN
                              WSH_BULK_TYPES_GRP.action_parameters_rectype,
                  p_line_rec  IN OUT NOCOPY OE_WSH_BULK_GRP.Line_rec_type,
                  x_Out_Rec               OUT NOCOPY
                                WSH_BULK_TYPES_GRP.Bulk_process_out_rec_type,
                  x_return_status          OUT  NOCOPY VARCHAR2,
                  x_msg_count              OUT  NOCOPY NUMBER,
                  x_msg_data               OUT  NOCOPY VARCHAR2
  )
  IS
    l_debug_on BOOLEAN;

Line: 43

               '.' || 'CREATE_UPDATE_DELIVERY_DETAILS';

Line: 44

    l_api_name     CONSTANT VARCHAR2(40):= 'CREATE_UPDATE_DELIVERY_DETAILS';

Line: 71

    SAVEPOINT S_CREATE_UPDATE_DETAILS_BULK;

Line: 275

                ROLLBACK TO S_CREATE_UPDATE_DETAILS_BULK;

Line: 366

      ROLLBACK TO S_CREATE_UPDATE_DETAILS_BULK;

Line: 438

                ROLLBACK TO S_CREATE_UPDATE_DETAILS_BULK;

Line: 462

      ROLLBACK TO S_CREATE_UPDATE_DETAILS_BULK;

Line: 464

      wsh_util_core.default_handler('WSH_BULK_PROCESS_GRP.CREATE_UPDATE_DELIVERY_DETAILS');

Line: 508

  END Create_update_delivery_details;