DBA Data[Home] [Help]

APPS.ZX_GLOBAL_STRUCTURES_PKG SQL Statements

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

Line: 16

    ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl.DELETE;
Line: 21

    ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl.DELETE;
Line: 32

    ZX_GLOBAL_STRUCTURES_PKG.trx_line_app_regime_tbl.APPLICATION_ID.delete;
Line: 33

    ZX_GLOBAL_STRUCTURES_PKG.trx_line_app_regime_tbl.ENTITY_CODE.delete;
Line: 34

    ZX_GLOBAL_STRUCTURES_PKG.trx_line_app_regime_tbl.EVENT_CLASS_CODE.delete;
Line: 35

    ZX_GLOBAL_STRUCTURES_PKG.trx_line_app_regime_tbl.TRX_ID.delete;
Line: 36

    ZX_GLOBAL_STRUCTURES_PKG.trx_line_app_regime_tbl.TRX_LINE_ID.delete;
Line: 37

    ZX_GLOBAL_STRUCTURES_PKG.trx_line_app_regime_tbl.TRX_LEVEL_TYPE.delete;
Line: 38

    ZX_GLOBAL_STRUCTURES_PKG.trx_line_app_regime_tbl.TAX_REGIME_CODE.delete;
Line: 39

    ZX_GLOBAL_STRUCTURES_PKG.trx_line_app_regime_tbl.TAX_REGIME_ID.delete;
Line: 40

    ZX_GLOBAL_STRUCTURES_PKG.trx_line_app_regime_tbl.TAX_PROVIDER_ID.delete;
Line: 41

    ZX_GLOBAL_STRUCTURES_PKG.trx_line_app_regime_tbl.ALLOW_TAX_CALCULATION_FLAG.delete;
Line: 50

    delete from ZX_TRX_HEADERS_GT;
Line: 63

    select
           APPLICATION_ID,
           ORG_ID,
           TAX_METHOD_CODE,
           DEF_OPTION_HIER_1_CODE,
           DEF_OPTION_HIER_2_CODE,
           DEF_OPTION_HIER_3_CODE,
           DEF_OPTION_HIER_4_CODE,
           DEF_OPTION_HIER_5_CODE,
           DEF_OPTION_HIER_6_CODE,
           DEF_OPTION_HIER_7_CODE,
           TAX_CLASSIFICATION_CODE,
           INCLUSIVE_TAX_USED_FLAG,
           TAX_USE_CUSTOMER_EXEMPT_FLAG,
           TAX_USE_PRODUCT_EXEMPT_FLAG,
           TAX_USE_LOC_EXC_RATE_FLAG,
           TAX_ALLOW_COMPOUND_FLAG,
           USE_TAX_CLASSIFICATION_FLAG,
           ALLOW_TAX_ROUNDING_OVRD_FLAG,
           HOME_COUNTRY_DEFAULT_FLAG,
           TAX_ROUNDING_RULE,
           TAX_PRECISION,
           TAX_MINIMUM_ACCOUNTABLE_UNIT
    from zx_product_options_all
    where
         application_id = c_application_id
     and org_id = c_org_id;
Line: 150

    SELECT tax_regime_id, regime_usage_id
    FROM   zx_regimes_usages
    WHERE  tax_regime_code = c_tax_regime_code
    AND    first_pty_org_id = c_first_pty_org_id;
Line: 199

    delete from ZX_TRANSACTION_LINES_GT;
Line: 202

  PROCEDURE delete_trx_line_dist_tbl IS
  BEGIN
        IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
          FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||'DELETE_TRX_LINE_DIST_TBL'||'.BEGIN','ZX_GLOBAL_STRUCTURES_PKG: delete_trx_line_dist_tbl()+');
Line: 207

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.INTERNAL_ORGANIZATION_ID.DELETE      ;
Line: 208

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APPLICATION_ID.DELETE                ;
Line: 209

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ENTITY_CODE.DELETE                   ;
Line: 210

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.EVENT_CLASS_CODE.DELETE              ;
Line: 211

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.EVENT_TYPE_CODE.DELETE               ;
Line: 212

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_ID.DELETE                        ;
Line: 213

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_LEVEL_TYPE.DELETE                ;
Line: 214

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_LINE_ID.DELETE                   ;
Line: 215

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.LINE_LEVEL_ACTION.DELETE             ;
Line: 216

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.LINE_CLASS.DELETE                    ;
Line: 217

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_DATE.DELETE                      ;
Line: 218

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_DOC_REVISION.DELETE              ;
Line: 219

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.LEDGER_ID.DELETE                     ;
Line: 220

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_CURRENCY_CODE.DELETE             ;
Line: 221

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.CURRENCY_CONVERSION_DATE.DELETE      ;
Line: 222

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.CURRENCY_CONVERSION_RATE.DELETE      ;
Line: 223

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.CURRENCY_CONVERSION_TYPE.DELETE      ;
Line: 224

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.MINIMUM_ACCOUNTABLE_UNIT.DELETE      ;
Line: 225

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.PRECISION.DELETE                     ;
Line: 226

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_LINE_CURRENCY_CODE.DELETE        ;
Line: 227

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_LINE_CURRENCY_CONV_DATE.DELETE   ;
Line: 228

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_LINE_CURRENCY_CONV_RATE.DELETE   ;
Line: 229

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_LINE_CURRENCY_CONV_TYPE.DELETE   ;
Line: 230

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_LINE_MAU.DELETE                  ;
Line: 231

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_LINE_PRECISION.DELETE            ;
Line: 232

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_SHIPPING_DATE.DELETE             ;
Line: 233

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_RECEIPT_DATE.DELETE              ;
Line: 234

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.LEGAL_ENTITY_ID.DELETE               ;
Line: 235

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ROUNDING_SHIP_TO_PARTY_ID.DELETE     ;
Line: 236

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ROUNDING_SHIP_FROM_PARTY_ID.DELETE   ;
Line: 237

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ROUNDING_BILL_TO_PARTY_ID.DELETE     ;
Line: 238

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ROUNDING_BILL_FROM_PARTY_ID.DELETE   ;
Line: 239

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.RNDG_SHIP_TO_PARTY_SITE_ID.DELETE    ;
Line: 240

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.RNDG_SHIP_FROM_PARTY_SITE_ID.DELETE  ;
Line: 241

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.RNDG_BILL_TO_PARTY_SITE_ID.DELETE    ;
Line: 242

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.RNDG_BILL_FROM_PARTY_SITE_ID.DELETE  ;
Line: 243

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ESTABLISHMENT_ID.DELETE              ;
Line: 244

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_LINE_TYPE.DELETE                 ;
Line: 245

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_LINE_DATE.DELETE                 ;
Line: 246

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_BUSINESS_CATEGORY.DELETE         ;
Line: 247

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.LINE_INTENDED_USE.DELETE             ;
Line: 248

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.USER_DEFINED_FISC_CLASS.DELETE       ;
Line: 249

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.LINE_AMT.DELETE                      ;
Line: 250

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_LINE_QUANTITY.DELETE             ;
Line: 251

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.UNIT_PRICE.DELETE                    ;
Line: 252

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.EXEMPT_CERTIFICATE_NUMBER.DELETE     ;
Line: 253

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.EXEMPT_REASON.DELETE                 ;
Line: 254

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.CASH_DISCOUNT.DELETE                 ;
Line: 255

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.VOLUME_DISCOUNT.DELETE               ;
Line: 256

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRADING_DISCOUNT.DELETE              ;
Line: 257

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRANSFER_CHARGE.DELETE               ;
Line: 258

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRANSPORTATION_CHARGE.DELETE         ;
Line: 259

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.INSURANCE_CHARGE.DELETE              ;
Line: 260

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.OTHER_CHARGE.DELETE                  ;
Line: 261

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.PRODUCT_ID.DELETE                    ;
Line: 262

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.PRODUCT_FISC_CLASSIFICATION.DELETE   ;
Line: 263

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.PRODUCT_ORG_ID.DELETE                ;
Line: 264

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.UOM_CODE.DELETE                      ;
Line: 265

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.PRODUCT_TYPE.DELETE                  ;
Line: 266

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.PRODUCT_CODE.DELETE                  ;
Line: 267

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.PRODUCT_CATEGORY.DELETE              ;
Line: 268

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_SIC_CODE.DELETE                  ;
Line: 269

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.FOB_POINT.DELETE                     ;
Line: 270

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.SHIP_TO_PARTY_ID.DELETE              ;
Line: 271

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.SHIP_FROM_PARTY_ID.DELETE            ;
Line: 272

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.POA_PARTY_ID.DELETE                  ;
Line: 273

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.POO_PARTY_ID.DELETE                  ;
Line: 274

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.BILL_TO_PARTY_ID.DELETE              ;
Line: 275

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.BILL_FROM_PARTY_ID.DELETE            ;
Line: 276

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.MERCHANT_PARTY_ID.DELETE             ;
Line: 277

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.SHIP_TO_PARTY_SITE_ID.DELETE         ;
Line: 278

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.SHIP_FROM_PARTY_SITE_ID.DELETE       ;
Line: 279

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.POA_PARTY_SITE_ID.DELETE             ;
Line: 280

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.POO_PARTY_SITE_ID.DELETE             ;
Line: 281

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.BILL_TO_PARTY_SITE_ID.DELETE         ;
Line: 282

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.BILL_FROM_PARTY_SITE_ID.DELETE       ;
Line: 283

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.SHIP_TO_LOCATION_ID.DELETE           ;
Line: 284

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.SHIP_FROM_LOCATION_ID.DELETE         ;
Line: 285

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.POA_LOCATION_ID.DELETE               ;
Line: 286

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.POO_LOCATION_ID.DELETE               ;
Line: 287

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.BILL_TO_LOCATION_ID.DELETE           ;
Line: 288

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.BILL_FROM_LOCATION_ID.DELETE         ;
Line: 289

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ACCOUNT_CCID.DELETE                  ;
Line: 290

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ACCOUNT_STRING.DELETE                ;
Line: 291

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.MERCHANT_PARTY_COUNTRY.DELETE        ;
Line: 292

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.RECEIVABLES_TRX_TYPE_ID.DELETE       ;
Line: 293

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.REF_DOC_APPLICATION_ID.DELETE        ;
Line: 294

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.REF_DOC_ENTITY_CODE.DELETE           ;
Line: 295

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.REF_DOC_EVENT_CLASS_CODE.DELETE      ;
Line: 296

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.REF_DOC_TRX_ID.DELETE                ;
Line: 297

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.REF_DOC_HDR_TRX_USER_KEY1.DELETE     ;
Line: 298

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.REF_DOC_HDR_TRX_USER_KEY2.DELETE     ;
Line: 299

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.REF_DOC_HDR_TRX_USER_KEY3.DELETE     ;
Line: 300

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.REF_DOC_HDR_TRX_USER_KEY4.DELETE     ;
Line: 301

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.REF_DOC_HDR_TRX_USER_KEY5.DELETE     ;
Line: 302

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.REF_DOC_HDR_TRX_USER_KEY6.DELETE     ;
Line: 303

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.REF_DOC_LINE_ID.DELETE               ;
Line: 304

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.REF_DOC_LIN_TRX_USER_KEY1.DELETE     ;
Line: 305

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.REF_DOC_LIN_TRX_USER_KEY2.DELETE     ;
Line: 306

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.REF_DOC_LIN_TRX_USER_KEY3.DELETE     ;
Line: 307

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.REF_DOC_LIN_TRX_USER_KEY4.DELETE     ;
Line: 308

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.REF_DOC_LIN_TRX_USER_KEY5.DELETE     ;
Line: 309

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.REF_DOC_LIN_TRX_USER_KEY6.DELETE     ;
Line: 310

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.REF_DOC_LINE_QUANTITY.DELETE         ;
Line: 311

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.RELATED_DOC_APPLICATION_ID.DELETE    ;
Line: 312

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.RELATED_DOC_ENTITY_CODE.DELETE       ;
Line: 313

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.RELATED_DOC_EVENT_CLASS_CODE.DELETE  ;
Line: 314

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.RELATED_DOC_TRX_ID.DELETE            ;
Line: 315

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.REL_DOC_HDR_TRX_USER_KEY1.DELETE     ;
Line: 316

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.REL_DOC_HDR_TRX_USER_KEY2.DELETE     ;
Line: 317

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.REL_DOC_HDR_TRX_USER_KEY3.DELETE     ;
Line: 318

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.REL_DOC_HDR_TRX_USER_KEY4.DELETE     ;
Line: 319

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.REL_DOC_HDR_TRX_USER_KEY5.DELETE     ;
Line: 320

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.REL_DOC_HDR_TRX_USER_KEY6.DELETE     ;
Line: 321

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.RELATED_DOC_NUMBER.DELETE            ;
Line: 322

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.RELATED_DOC_DATE.DELETE              ;
Line: 323

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APPLIED_FROM_APPLICATION_ID.DELETE   ;
Line: 324

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APPLIED_FROM_ENTITY_CODE.DELETE      ;
Line: 325

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APPLIED_FROM_EVENT_CLASS_CODE.DELETE ;
Line: 326

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APPLIED_FROM_TRX_ID.DELETE           ;
Line: 327

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APP_FROM_HDR_TRX_USER_KEY1.DELETE    ;
Line: 328

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APP_FROM_HDR_TRX_USER_KEY2.DELETE    ;
Line: 329

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APP_FROM_HDR_TRX_USER_KEY3.DELETE    ;
Line: 330

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APP_FROM_HDR_TRX_USER_KEY4.DELETE    ;
Line: 331

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APP_FROM_HDR_TRX_USER_KEY5.DELETE    ;
Line: 332

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APP_FROM_HDR_TRX_USER_KEY6.DELETE    ;
Line: 333

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APPLIED_FROM_LINE_ID.DELETE          ;
Line: 334

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APPLIED_FROM_TRX_NUMBER.DELETE       ;
Line: 335

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APP_FROM_LIN_TRX_USER_KEY1.DELETE    ;
Line: 336

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APP_FROM_LIN_TRX_USER_KEY2.DELETE    ;
Line: 337

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APP_FROM_LIN_TRX_USER_KEY3.DELETE    ;
Line: 338

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APP_FROM_LIN_TRX_USER_KEY4.DELETE    ;
Line: 339

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APP_FROM_LIN_TRX_USER_KEY5.DELETE    ;
Line: 340

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APP_FROM_LIN_TRX_USER_KEY6.DELETE    ;
Line: 341

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ADJUSTED_DOC_APPLICATION_ID.DELETE   ;
Line: 342

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ADJUSTED_DOC_ENTITY_CODE.DELETE      ;
Line: 343

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ADJUSTED_DOC_EVENT_CLASS_CODE.DELETE ;
Line: 344

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ADJUSTED_DOC_TRX_ID.DELETE           ;
Line: 345

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ADJ_DOC_HDR_TRX_USER_KEY1.DELETE     ;
Line: 346

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ADJ_DOC_HDR_TRX_USER_KEY2.DELETE     ;
Line: 347

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ADJ_DOC_HDR_TRX_USER_KEY3.DELETE     ;
Line: 348

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ADJ_DOC_HDR_TRX_USER_KEY4.DELETE     ;
Line: 349

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ADJ_DOC_HDR_TRX_USER_KEY5.DELETE     ;
Line: 350

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ADJ_DOC_HDR_TRX_USER_KEY6.DELETE     ;
Line: 351

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ADJUSTED_DOC_LINE_ID.DELETE          ;
Line: 352

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ADJ_DOC_LIN_TRX_USER_KEY1.DELETE     ;
Line: 353

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ADJ_DOC_LIN_TRX_USER_KEY2.DELETE     ;
Line: 354

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ADJ_DOC_LIN_TRX_USER_KEY3.DELETE     ;
Line: 355

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ADJ_DOC_LIN_TRX_USER_KEY4.DELETE     ;
Line: 356

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ADJ_DOC_LIN_TRX_USER_KEY5.DELETE     ;
Line: 357

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ADJ_DOC_LIN_TRX_USER_KEY6.DELETE     ;
Line: 358

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ADJUSTED_DOC_NUMBER.DELETE           ;
Line: 359

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ADJUSTED_DOC_DATE.DELETE             ;
Line: 360

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APPLIED_TO_APPLICATION_ID.DELETE     ;
Line: 361

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APPLIED_TO_ENTITY_CODE.DELETE        ;
Line: 362

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APPLIED_TO_EVENT_CLASS_CODE.DELETE   ;
Line: 363

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APPLIED_TO_TRX_ID.DELETE             ;
Line: 364

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APP_TO_HDR_TRX_USER_KEY1.DELETE      ;
Line: 365

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APP_TO_HDR_TRX_USER_KEY2.DELETE      ;
Line: 366

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APP_TO_HDR_TRX_USER_KEY3.DELETE      ;
Line: 367

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APP_TO_HDR_TRX_USER_KEY4.DELETE      ;
Line: 368

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APP_TO_HDR_TRX_USER_KEY5.DELETE      ;
Line: 369

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APP_TO_HDR_TRX_USER_KEY6.DELETE      ;
Line: 370

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APPLIED_TO_TRX_LINE_ID.DELETE        ;
Line: 371

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APP_TO_LIN_TRX_USER_KEY1.DELETE      ;
Line: 372

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APP_TO_LIN_TRX_USER_KEY2.DELETE      ;
Line: 373

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APP_TO_LIN_TRX_USER_KEY3.DELETE      ;
Line: 374

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APP_TO_LIN_TRX_USER_KEY4.DELETE      ;
Line: 375

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APP_TO_LIN_TRX_USER_KEY5.DELETE      ;
Line: 376

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APP_TO_LIN_TRX_USER_KEY6.DELETE      ;
Line: 377

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_ID_LEVEL2.DELETE                 ;
Line: 378

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_ID_LEVEL3.DELETE                 ;
Line: 379

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_ID_LEVEL4.DELETE                 ;
Line: 380

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_ID_LEVEL5.DELETE                 ;
Line: 381

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_ID_LEVEL6.DELETE                 ;
Line: 382

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.HDR_TRX_USER_KEY1.DELETE             ;
Line: 383

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.HDR_TRX_USER_KEY2.DELETE             ;
Line: 384

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.HDR_TRX_USER_KEY3.DELETE             ;
Line: 385

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.HDR_TRX_USER_KEY4.DELETE             ;
Line: 386

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.HDR_TRX_USER_KEY5.DELETE             ;
Line: 387

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.HDR_TRX_USER_KEY6.DELETE             ;
Line: 388

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.LINE_TRX_USER_KEY1.DELETE            ;
Line: 389

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.LINE_TRX_USER_KEY2.DELETE            ;
Line: 390

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.LINE_TRX_USER_KEY3.DELETE            ;
Line: 391

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.LINE_TRX_USER_KEY4.DELETE            ;
Line: 392

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.LINE_TRX_USER_KEY5.DELETE            ;
Line: 393

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.LINE_TRX_USER_KEY6.DELETE            ;
Line: 394

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_NUMBER.DELETE                    ;
Line: 395

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_DESCRIPTION.DELETE               ;
Line: 396

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_LINE_NUMBER.DELETE               ;
Line: 397

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_LINE_DESCRIPTION.DELETE          ;
Line: 398

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.PRODUCT_DESCRIPTION.DELETE           ;
Line: 399

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_WAYBILL_NUMBER.DELETE            ;
Line: 400

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_COMMUNICATED_DATE.DELETE         ;
Line: 401

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_LINE_GL_DATE.DELETE              ;
Line: 402

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.BATCH_SOURCE_ID.DELETE               ;
Line: 403

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.BATCH_SOURCE_NAME.DELETE             ;
Line: 404

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DOC_SEQ_ID.DELETE                    ;
Line: 405

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DOC_SEQ_NAME.DELETE                  ;
Line: 406

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DOC_SEQ_VALUE.DELETE                 ;
Line: 407

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_DUE_DATE.DELETE                  ;
Line: 408

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_TYPE_DESCRIPTION.DELETE          ;
Line: 409

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.MERCHANT_PARTY_NAME.DELETE           ;
Line: 410

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.MERCHANT_PARTY_DOCUMENT_NUMBER.DELETE;
Line: 411

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.MERCHANT_PARTY_REFERENCE.DELETE      ;
Line: 412

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.MERCHANT_PARTY_TAXPAYER_ID.DELETE    ;
Line: 413

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.MERCHANT_PARTY_TAX_REG_NUMBER.DELETE ;
Line: 414

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.PAYING_PARTY_ID.DELETE               ;
Line: 415

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.OWN_HQ_PARTY_ID.DELETE               ;
Line: 416

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRADING_HQ_PARTY_ID.DELETE           ;
Line: 417

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.POI_PARTY_ID.DELETE                  ;
Line: 418

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.POD_PARTY_ID.DELETE                  ;
Line: 419

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TITLE_TRANSFER_PARTY_ID.DELETE       ;
Line: 420

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.PAYING_PARTY_SITE_ID.DELETE          ;
Line: 421

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.OWN_HQ_PARTY_SITE_ID.DELETE          ;
Line: 422

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRADING_HQ_PARTY_SITE_ID.DELETE      ;
Line: 423

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.POI_PARTY_SITE_ID.DELETE             ;
Line: 424

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.POD_PARTY_SITE_ID.DELETE             ;
Line: 425

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TITLE_TRANSFER_PARTY_SITE_ID.DELETE  ;
Line: 426

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.PAYING_LOCATION_ID.DELETE            ;
Line: 427

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.OWN_HQ_LOCATION_ID.DELETE            ;
Line: 428

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRADING_HQ_LOCATION_ID.DELETE        ;
Line: 429

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.POC_LOCATION_ID.DELETE               ;
Line: 430

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.POI_LOCATION_ID.DELETE               ;
Line: 431

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.POD_LOCATION_ID.DELETE               ;
Line: 432

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TITLE_TRANSFER_LOCATION_ID.DELETE    ;
Line: 433

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ASSESSABLE_VALUE.DELETE              ;
Line: 434

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ASSET_FLAG.DELETE                    ;
Line: 435

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ASSET_NUMBER.DELETE                  ;
Line: 436

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ASSET_ACCUM_DEPRECIATION.DELETE      ;
Line: 437

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ASSET_TYPE.DELETE                    ;
Line: 438

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ASSET_COST.DELETE                    ;
Line: 439

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.NUMERIC1.DELETE                      ;
Line: 440

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.NUMERIC2.DELETE                      ;
Line: 441

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.NUMERIC3.DELETE                      ;
Line: 442

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.NUMERIC4.DELETE                      ;
Line: 443

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.NUMERIC5.DELETE                      ;
Line: 444

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.NUMERIC6.DELETE                      ;
Line: 445

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.NUMERIC7.DELETE                      ;
Line: 446

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.NUMERIC8.DELETE                      ;
Line: 447

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.NUMERIC9.DELETE                      ;
Line: 448

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.NUMERIC10.DELETE                     ;
Line: 449

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.CHAR1.DELETE                         ;
Line: 450

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.CHAR2.DELETE                         ;
Line: 451

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.CHAR3.DELETE                         ;
Line: 452

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.CHAR4.DELETE                         ;
Line: 453

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.CHAR5.DELETE                         ;
Line: 454

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.CHAR6.DELETE                         ;
Line: 455

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.CHAR7.DELETE                         ;
Line: 456

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.CHAR8.DELETE                         ;
Line: 457

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.CHAR9.DELETE                         ;
Line: 458

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.CHAR10.DELETE                        ;
Line: 459

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DATE1.DELETE                         ;
Line: 460

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DATE2.DELETE                         ;
Line: 461

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DATE3.DELETE                         ;
Line: 462

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DATE4.DELETE                         ;
Line: 463

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DATE5.DELETE                         ;
Line: 464

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DATE6.DELETE                         ;
Line: 465

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DATE7.DELETE                         ;
Line: 466

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DATE8.DELETE                         ;
Line: 467

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DATE9.DELETE                         ;
Line: 468

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DATE10.DELETE                        ;
Line: 469

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.FIRST_PTY_ORG_ID.DELETE              ;
Line: 470

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TAX_EVENT_CLASS_CODE.DELETE          ;
Line: 471

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TAX_EVENT_TYPE_CODE.DELETE           ;
Line: 472

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DOC_EVENT_STATUS.DELETE              ;
Line: 473

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.RDNG_SHIP_TO_PTY_TX_PROF_ID.DELETE   ;
Line: 474

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.RDNG_SHIP_FROM_PTY_TX_PROF_ID.DELETE ;
Line: 475

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.RDNG_BILL_TO_PTY_TX_PROF_ID.DELETE   ;
Line: 476

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.RDNG_BILL_FROM_PTY_TX_PROF_ID.DELETE ;
Line: 477

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.RDNG_SHIP_TO_PTY_TX_P_ST_ID.DELETE   ;
Line: 478

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.RDNG_SHIP_FROM_PTY_TX_P_ST_ID.DELETE ;
Line: 479

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.RDNG_BILL_TO_PTY_TX_P_ST_ID.DELETE   ;
Line: 480

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.RDNG_BILL_FROM_PTY_TX_P_ST_ID.DELETE ;
Line: 481

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.SHIP_TO_PARTY_TAX_PROF_ID.DELETE     ;
Line: 482

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.SHIP_FROM_PARTY_TAX_PROF_ID.DELETE   ;
Line: 483

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.POA_PARTY_TAX_PROF_ID.DELETE         ;
Line: 484

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.POO_PARTY_TAX_PROF_ID.DELETE         ;
Line: 485

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.PAYING_PARTY_TAX_PROF_ID.DELETE      ;
Line: 486

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.OWN_HQ_PARTY_TAX_PROF_ID.DELETE      ;
Line: 487

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRADING_HQ_PARTY_TAX_PROF_ID.DELETE  ;
Line: 488

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.POI_PARTY_TAX_PROF_ID.DELETE         ;
Line: 489

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.POD_PARTY_TAX_PROF_ID.DELETE         ;
Line: 490

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.BILL_TO_PARTY_TAX_PROF_ID.DELETE     ;
Line: 491

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.BILL_FROM_PARTY_TAX_PROF_ID.DELETE   ;
Line: 492

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TITLE_TRANS_PARTY_TAX_PROF_ID.DELETE ;
Line: 493

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.SHIP_TO_SITE_TAX_PROF_ID.DELETE      ;
Line: 494

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.SHIP_FROM_SITE_TAX_PROF_ID.DELETE    ;
Line: 495

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.POA_SITE_TAX_PROF_ID.DELETE          ;
Line: 496

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.POO_SITE_TAX_PROF_ID.DELETE          ;
Line: 497

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.PAYING_SITE_TAX_PROF_ID.DELETE       ;
Line: 498

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.OWN_HQ_SITE_TAX_PROF_ID.DELETE       ;
Line: 499

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRADING_HQ_SITE_TAX_PROF_ID.DELETE   ;
Line: 500

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.POI_SITE_TAX_PROF_ID.DELETE          ;
Line: 501

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.POD_SITE_TAX_PROF_ID.DELETE          ;
Line: 502

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.BILL_TO_SITE_TAX_PROF_ID.DELETE      ;
Line: 503

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.BILL_FROM_SITE_TAX_PROF_ID.DELETE    ;
Line: 504

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TITLE_TRANS_SITE_TAX_PROF_ID.DELETE  ;
Line: 505

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.MERCHANT_PARTY_TAX_PROF_ID.DELETE    ;
Line: 506

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.HQ_ESTB_PARTY_TAX_PROF_ID.DELETE     ;
Line: 507

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DOCUMENT_SUB_TYPE.DELETE             ;
Line: 508

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.SUPPLIER_TAX_INVOICE_NUMBER.DELETE   ;
Line: 509

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.SUPPLIER_TAX_INVOICE_DATE.DELETE     ;
Line: 510

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.SUPPLIER_EXCHANGE_RATE.DELETE        ;
Line: 511

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TAX_INVOICE_DATE.DELETE              ;
Line: 512

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TAX_INVOICE_NUMBER.DELETE            ;
Line: 513

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.LINE_AMT_INCLUDES_TAX_FLAG.DELETE    ;
Line: 514

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.QUOTE_FLAG.DELETE                    ;
Line: 515

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DEFAULT_TAXATION_COUNTRY.DELETE      ;
Line: 516

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.HISTORICAL_FLAG.DELETE               ;
Line: 517

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.INTERNAL_ORG_LOCATION_ID.DELETE      ;
Line: 518

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.CTRL_HDR_TX_APPL_FLAG.DELETE         ;
Line: 519

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.CTRL_TOTAL_HDR_TX_AMT.DELETE         ;
Line: 520

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.CTRL_TOTAL_LINE_TX_AMT.DELETE        ;
Line: 521

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DIST_LEVEL_ACTION.DELETE             ;
Line: 522

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APPLIED_FROM_TAX_DIST_ID.DELETE      ;
Line: 523

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ADJUSTED_DOC_TAX_DIST_ID.DELETE      ;
Line: 524

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TASK_ID.DELETE                       ;
Line: 525

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.AWARD_ID.DELETE                      ;
Line: 526

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.PROJECT_ID.DELETE                    ;
Line: 527

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.EXPENDITURE_TYPE.DELETE              ;
Line: 528

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.EXPENDITURE_ORGANIZATION_ID.DELETE   ;
Line: 529

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.EXPENDITURE_ITEM_DATE.DELETE         ;
Line: 530

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_LINE_DIST_AMT.DELETE             ;
Line: 531

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_LINE_DIST_QUANTITY.DELETE        ;
Line: 532

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.REF_DOC_CURR_CONV_RATE.DELETE        ;
Line: 533

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ITEM_DIST_NUMBER.DELETE              ;
Line: 534

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.REF_DOC_DIST_ID.DELETE               ;
Line: 535

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_LINE_DIST_TAX_AMT.DELETE         ;
Line: 536

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_LINE_DIST_ID.DELETE              ;
Line: 537

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DIST_TRX_USER_KEY1.DELETE            ;
Line: 538

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DIST_TRX_USER_KEY2.DELETE            ;
Line: 539

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DIST_TRX_USER_KEY3.DELETE            ;
Line: 540

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DIST_TRX_USER_KEY4.DELETE            ;
Line: 541

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DIST_TRX_USER_KEY5.DELETE            ;
Line: 542

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DIST_TRX_USER_KEY6.DELETE            ;
Line: 543

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APPLIED_FROM_DIST_ID.DELETE          ;
Line: 544

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APP_FROM_DST_TRX_USER_KEY1.DELETE    ;
Line: 545

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APP_FROM_DST_TRX_USER_KEY2.DELETE    ;
Line: 546

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APP_FROM_DST_TRX_USER_KEY3.DELETE    ;
Line: 547

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APP_FROM_DST_TRX_USER_KEY4.DELETE    ;
Line: 548

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APP_FROM_DST_TRX_USER_KEY5.DELETE    ;
Line: 549

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APP_FROM_DST_TRX_USER_KEY6.DELETE    ;
Line: 550

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ADJUSTED_DOC_DIST_ID.DELETE          ;
Line: 551

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ADJ_DOC_DST_TRX_USER_KEY1.DELETE     ;
Line: 552

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ADJ_DOC_DST_TRX_USER_KEY2.DELETE     ;
Line: 553

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ADJ_DOC_DST_TRX_USER_KEY3.DELETE     ;
Line: 554

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ADJ_DOC_DST_TRX_USER_KEY4.DELETE     ;
Line: 555

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ADJ_DOC_DST_TRX_USER_KEY5.DELETE     ;
Line: 556

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ADJ_DOC_DST_TRX_USER_KEY6.DELETE     ;
Line: 557

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.INPUT_TAX_CLASSIFICATION_CODE.DELETE ;
Line: 558

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.OUTPUT_TAX_CLASSIFICATION_CODE.DELETE;
Line: 559

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.PORT_OF_ENTRY_CODE.DELETE            ;
Line: 560

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TAX_REPORTING_FLAG.DELETE            ;
Line: 561

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TAX_AMT_INCLUDED_FLAG.DELETE         ;
Line: 562

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.COMPOUNDING_TAX_FLAG.DELETE          ;
Line: 563

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.PROVNL_TAX_DETERMINATION_DATE.DELETE ;
Line: 564

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.SHIP_THIRD_PTY_ACCT_SITE_ID.DELETE   ;
Line: 565

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.BILL_THIRD_PTY_ACCT_SITE_ID.DELETE   ;
Line: 566

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.SHIP_TO_CUST_ACCT_SITE_USE_ID.DELETE ;
Line: 567

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.BILL_TO_CUST_ACCT_SITE_USE_ID.DELETE ;
Line: 568

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.SHIP_THIRD_PTY_ACCT_ID.DELETE        ;
Line: 569

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.BILL_THIRD_PTY_ACCT_ID.DELETE        ;
Line: 570

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.SOURCE_APPLICATION_ID.DELETE         ;
Line: 571

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.SOURCE_ENTITY_CODE.DELETE            ;
Line: 572

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.SOURCE_EVENT_CLASS_CODE.DELETE       ;
Line: 573

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.SOURCE_TRX_ID.DELETE                 ;
Line: 574

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.SOURCE_LINE_ID.DELETE                ;
Line: 575

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.SOURCE_TRX_LEVEL_TYPE.DELETE         ;
Line: 576

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.INSERT_UPDATE_FLAG.DELETE            ;
Line: 577

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APPLIED_TO_TRX_NUMBER.DELETE         ;
Line: 578

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.START_EXPENSE_DATE.DELETE            ;
Line: 579

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_BATCH_ID.DELETE                  ;
Line: 580

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.RECORD_TYPE_CODE.DELETE              ;
Line: 581

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.REF_DOC_TRX_LEVEL_TYPE.DELETE        ;
Line: 582

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APPLIED_FROM_TRX_LEVEL_TYPE.DELETE   ;
Line: 583

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APPLIED_TO_TRX_LEVEL_TYPE.DELETE     ;
Line: 584

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ADJUSTED_DOC_TRX_LEVEL_TYPE.DELETE   ;
Line: 585

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE1.DELETE         ;
Line: 586

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE2.DELETE         ;
Line: 587

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE3.DELETE         ;
Line: 588

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE4.DELETE         ;
Line: 589

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE5.DELETE         ;
Line: 590

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE6.DELETE         ;
Line: 591

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE7.DELETE         ;
Line: 592

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE8.DELETE         ;
Line: 593

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE9.DELETE         ;
Line: 594

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE10.DELETE        ;
Line: 595

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TAX_PROCESSING_COMPLETED_FLAG.DELETE ;
Line: 596

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APPLICATION_DOC_STATUS.DELETE        ;
Line: 597

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.OVERRIDING_RECOVERY_RATE.DELETE      ;
Line: 598

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TAX_CALCULATION_DONE_FLAG.DELETE     ;
Line: 599

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.SOURCE_TAX_LINE_ID.DELETE            ;
Line: 600

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.REVERSED_APPLN_ID.DELETE             ;
Line: 601

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.REVERSED_ENTITY_CODE.DELETE          ;
Line: 602

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.REVERSED_EVNT_CLS_CODE.DELETE        ;
Line: 603

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.REVERSED_TRX_ID.DELETE               ;
Line: 604

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.REVERSED_TRX_LEVEL_TYPE.DELETE       ;
Line: 605

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.REVERSED_TRX_LINE_ID.DELETE          ;
Line: 606

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.EXEMPTION_CONTROL_FLAG.DELETE        ;
Line: 607

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.EXEMPT_REASON_CODE.DELETE            ;
Line: 608

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.INTERFACE_ENTITY_CODE.DELETE         ;
Line: 609

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.INTERFACE_LINE_ID.DELETE             ;
Line: 610

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.HISTORICAL_TAX_CODE_ID.DELETE        ;
Line: 611

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.USER_UPD_DET_FACTORS_FLAG.DELETE     ;
Line: 612

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ICX_SESSION_ID.DELETE                ;
Line: 613

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.HDR_SHIP_THIRD_PTY_ACCT_ST_ID.DELETE ;
Line: 614

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.HDR_BILL_THIRD_PTY_ACCT_ST_ID.DELETE ;
Line: 615

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.HDR_BILL_TO_CST_ACCT_ST_USE_ID.DELETE;
Line: 616

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.HDR_SHIP_TO_CST_ACCT_ST_USE_ID.DELETE;
Line: 617

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.HDR_SHIP_THIRD_PTY_ACCT_ID.DELETE    ;
Line: 618

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.HDR_BILL_THIRD_PTY_ACCT_ID.DELETE    ;
Line: 619

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.HDR_RECEIVABLES_TRX_TYPE_ID.DELETE   ;
Line: 620

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.GLOBAL_ATTRIBUTE1.DELETE             ;
Line: 621

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.GLOBAL_ATTRIBUTE_CATEGORY.DELETE     ;
Line: 622

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TOTAL_INC_TAX_AMT.DELETE     ;
Line: 624

          FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||'DELETE_TRX_LINE_DIST_TBL'||'.END','ZX_GLOBAL_STRUCTURES_PKG: delete_trx_line_dist_tbl()-');
Line: 626

 END delete_trx_line_dist_tbl;
Line: 1002

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.INSERT_UPDATE_FLAG(l_trx_line_index)            := null;