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,
           TAX_CURRENCY_CODE
    from zx_product_options_all
    where
         application_id = c_application_id
     and org_id = c_org_id;
Line: 153

    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,
           TAX_CURRENCY_CODE
      FROM zx_product_options_all
     WHERE application_id = c_application_id
       AND org_id = c_org_id
       AND (event_class_mapping_id IS NULL OR
            event_class_mapping_id = c_event_class_mapping_id
            )
     ORDER BY event_class_mapping_id NULLS LAST;
Line: 254

    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: 303

    delete from ZX_TRANSACTION_LINES_GT;
Line: 306

  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: 311

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.INTERNAL_ORGANIZATION_ID.DELETE      ;
Line: 312

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APPLICATION_ID.DELETE                ;
Line: 313

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ENTITY_CODE.DELETE                   ;
Line: 314

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.EVENT_CLASS_CODE.DELETE              ;
Line: 315

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.EVENT_TYPE_CODE.DELETE               ;
Line: 316

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_ID.DELETE                        ;
Line: 317

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_LEVEL_TYPE.DELETE                ;
Line: 318

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_LINE_ID.DELETE                   ;
Line: 319

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.LINE_LEVEL_ACTION.DELETE             ;
Line: 320

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.LINE_CLASS.DELETE                    ;
Line: 321

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_DATE.DELETE                      ;
Line: 322

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_DOC_REVISION.DELETE              ;
Line: 323

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.LEDGER_ID.DELETE                     ;
Line: 324

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_CURRENCY_CODE.DELETE             ;
Line: 325

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.CURRENCY_CONVERSION_DATE.DELETE      ;
Line: 326

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.CURRENCY_CONVERSION_RATE.DELETE      ;
Line: 327

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.CURRENCY_CONVERSION_TYPE.DELETE      ;
Line: 328

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.MINIMUM_ACCOUNTABLE_UNIT.DELETE      ;
Line: 329

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.PRECISION.DELETE                     ;
Line: 330

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_LINE_CURRENCY_CODE.DELETE        ;
Line: 331

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_LINE_CURRENCY_CONV_DATE.DELETE   ;
Line: 332

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_LINE_CURRENCY_CONV_RATE.DELETE   ;
Line: 333

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_LINE_CURRENCY_CONV_TYPE.DELETE   ;
Line: 334

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_LINE_MAU.DELETE                  ;
Line: 335

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_LINE_PRECISION.DELETE            ;
Line: 336

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_SHIPPING_DATE.DELETE             ;
Line: 337

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_RECEIPT_DATE.DELETE              ;
Line: 338

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.LEGAL_ENTITY_ID.DELETE               ;
Line: 339

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ROUNDING_SHIP_TO_PARTY_ID.DELETE     ;
Line: 340

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ROUNDING_SHIP_FROM_PARTY_ID.DELETE   ;
Line: 341

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ROUNDING_BILL_TO_PARTY_ID.DELETE     ;
Line: 342

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ROUNDING_BILL_FROM_PARTY_ID.DELETE   ;
Line: 343

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.RNDG_SHIP_TO_PARTY_SITE_ID.DELETE    ;
Line: 344

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.RNDG_SHIP_FROM_PARTY_SITE_ID.DELETE  ;
Line: 345

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.RNDG_BILL_TO_PARTY_SITE_ID.DELETE    ;
Line: 346

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.RNDG_BILL_FROM_PARTY_SITE_ID.DELETE  ;
Line: 347

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ESTABLISHMENT_ID.DELETE              ;
Line: 348

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_LINE_TYPE.DELETE                 ;
Line: 349

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_LINE_DATE.DELETE                 ;
Line: 350

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_BUSINESS_CATEGORY.DELETE         ;
Line: 351

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.LINE_INTENDED_USE.DELETE             ;
Line: 352

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.USER_DEFINED_FISC_CLASS.DELETE       ;
Line: 353

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.LINE_AMT.DELETE                      ;
Line: 354

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_LINE_QUANTITY.DELETE             ;
Line: 355

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.UNIT_PRICE.DELETE                    ;
Line: 356

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.EXEMPT_CERTIFICATE_NUMBER.DELETE     ;
Line: 357

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.EXEMPT_REASON.DELETE                 ;
Line: 358

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.CASH_DISCOUNT.DELETE                 ;
Line: 359

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.VOLUME_DISCOUNT.DELETE               ;
Line: 360

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRADING_DISCOUNT.DELETE              ;
Line: 361

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRANSFER_CHARGE.DELETE               ;
Line: 362

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRANSPORTATION_CHARGE.DELETE         ;
Line: 363

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.INSURANCE_CHARGE.DELETE              ;
Line: 364

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.OTHER_CHARGE.DELETE                  ;
Line: 365

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.PRODUCT_ID.DELETE                    ;
Line: 366

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.PRODUCT_FISC_CLASSIFICATION.DELETE   ;
Line: 367

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.PRODUCT_ORG_ID.DELETE                ;
Line: 368

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.UOM_CODE.DELETE                      ;
Line: 369

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.PRODUCT_TYPE.DELETE                  ;
Line: 370

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.PRODUCT_CODE.DELETE                  ;
Line: 371

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.PRODUCT_CATEGORY.DELETE              ;
Line: 372

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_SIC_CODE.DELETE                  ;
Line: 373

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.FOB_POINT.DELETE                     ;
Line: 374

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.SHIP_TO_PARTY_ID.DELETE              ;
Line: 375

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.SHIP_FROM_PARTY_ID.DELETE            ;
Line: 376

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.POA_PARTY_ID.DELETE                  ;
Line: 377

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.POO_PARTY_ID.DELETE                  ;
Line: 378

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.BILL_TO_PARTY_ID.DELETE              ;
Line: 379

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.BILL_FROM_PARTY_ID.DELETE            ;
Line: 380

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.MERCHANT_PARTY_ID.DELETE             ;
Line: 381

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.SHIP_TO_PARTY_SITE_ID.DELETE         ;
Line: 382

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.SHIP_FROM_PARTY_SITE_ID.DELETE       ;
Line: 383

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.POA_PARTY_SITE_ID.DELETE             ;
Line: 384

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.POO_PARTY_SITE_ID.DELETE             ;
Line: 385

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.BILL_TO_PARTY_SITE_ID.DELETE         ;
Line: 386

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.BILL_FROM_PARTY_SITE_ID.DELETE       ;
Line: 387

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.SHIP_TO_LOCATION_ID.DELETE           ;
Line: 388

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.SHIP_FROM_LOCATION_ID.DELETE         ;
Line: 389

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.POA_LOCATION_ID.DELETE               ;
Line: 390

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.POO_LOCATION_ID.DELETE               ;
Line: 391

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.BILL_TO_LOCATION_ID.DELETE           ;
Line: 392

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.BILL_FROM_LOCATION_ID.DELETE         ;
Line: 393

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ACCOUNT_CCID.DELETE                  ;
Line: 394

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ACCOUNT_STRING.DELETE                ;
Line: 395

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.MERCHANT_PARTY_COUNTRY.DELETE        ;
Line: 396

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.RECEIVABLES_TRX_TYPE_ID.DELETE       ;
Line: 397

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.REF_DOC_APPLICATION_ID.DELETE        ;
Line: 398

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.REF_DOC_ENTITY_CODE.DELETE           ;
Line: 399

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.REF_DOC_EVENT_CLASS_CODE.DELETE      ;
Line: 400

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.REF_DOC_TRX_ID.DELETE                ;
Line: 401

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.REF_DOC_HDR_TRX_USER_KEY1.DELETE     ;
Line: 402

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.REF_DOC_HDR_TRX_USER_KEY2.DELETE     ;
Line: 403

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.REF_DOC_HDR_TRX_USER_KEY3.DELETE     ;
Line: 404

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.REF_DOC_HDR_TRX_USER_KEY4.DELETE     ;
Line: 405

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.REF_DOC_HDR_TRX_USER_KEY5.DELETE     ;
Line: 406

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.REF_DOC_HDR_TRX_USER_KEY6.DELETE     ;
Line: 407

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.REF_DOC_LINE_ID.DELETE               ;
Line: 408

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.REF_DOC_LIN_TRX_USER_KEY1.DELETE     ;
Line: 409

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.REF_DOC_LIN_TRX_USER_KEY2.DELETE     ;
Line: 410

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.REF_DOC_LIN_TRX_USER_KEY3.DELETE     ;
Line: 411

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.REF_DOC_LIN_TRX_USER_KEY4.DELETE     ;
Line: 412

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.REF_DOC_LIN_TRX_USER_KEY5.DELETE     ;
Line: 413

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.REF_DOC_LIN_TRX_USER_KEY6.DELETE     ;
Line: 414

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.REF_DOC_LINE_QUANTITY.DELETE         ;
Line: 415

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.RELATED_DOC_APPLICATION_ID.DELETE    ;
Line: 416

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.RELATED_DOC_ENTITY_CODE.DELETE       ;
Line: 417

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.RELATED_DOC_EVENT_CLASS_CODE.DELETE  ;
Line: 418

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.RELATED_DOC_TRX_ID.DELETE            ;
Line: 419

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.REL_DOC_HDR_TRX_USER_KEY1.DELETE     ;
Line: 420

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.REL_DOC_HDR_TRX_USER_KEY2.DELETE     ;
Line: 421

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.REL_DOC_HDR_TRX_USER_KEY3.DELETE     ;
Line: 422

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.REL_DOC_HDR_TRX_USER_KEY4.DELETE     ;
Line: 423

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.REL_DOC_HDR_TRX_USER_KEY5.DELETE     ;
Line: 424

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.REL_DOC_HDR_TRX_USER_KEY6.DELETE     ;
Line: 425

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.RELATED_DOC_NUMBER.DELETE            ;
Line: 426

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.RELATED_DOC_DATE.DELETE              ;
Line: 427

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APPLIED_FROM_APPLICATION_ID.DELETE   ;
Line: 428

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APPLIED_FROM_ENTITY_CODE.DELETE      ;
Line: 429

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APPLIED_FROM_EVENT_CLASS_CODE.DELETE ;
Line: 430

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APPLIED_FROM_TRX_ID.DELETE           ;
Line: 431

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APP_FROM_HDR_TRX_USER_KEY1.DELETE    ;
Line: 432

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APP_FROM_HDR_TRX_USER_KEY2.DELETE    ;
Line: 433

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APP_FROM_HDR_TRX_USER_KEY3.DELETE    ;
Line: 434

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APP_FROM_HDR_TRX_USER_KEY4.DELETE    ;
Line: 435

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APP_FROM_HDR_TRX_USER_KEY5.DELETE    ;
Line: 436

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APP_FROM_HDR_TRX_USER_KEY6.DELETE    ;
Line: 437

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APPLIED_FROM_LINE_ID.DELETE          ;
Line: 438

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APPLIED_FROM_TRX_NUMBER.DELETE       ;
Line: 439

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APP_FROM_LIN_TRX_USER_KEY1.DELETE    ;
Line: 440

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APP_FROM_LIN_TRX_USER_KEY2.DELETE    ;
Line: 441

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APP_FROM_LIN_TRX_USER_KEY3.DELETE    ;
Line: 442

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APP_FROM_LIN_TRX_USER_KEY4.DELETE    ;
Line: 443

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APP_FROM_LIN_TRX_USER_KEY5.DELETE    ;
Line: 444

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APP_FROM_LIN_TRX_USER_KEY6.DELETE    ;
Line: 445

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ADJUSTED_DOC_APPLICATION_ID.DELETE   ;
Line: 446

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ADJUSTED_DOC_ENTITY_CODE.DELETE      ;
Line: 447

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ADJUSTED_DOC_EVENT_CLASS_CODE.DELETE ;
Line: 448

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ADJUSTED_DOC_TRX_ID.DELETE           ;
Line: 449

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ADJ_DOC_HDR_TRX_USER_KEY1.DELETE     ;
Line: 450

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ADJ_DOC_HDR_TRX_USER_KEY2.DELETE     ;
Line: 451

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ADJ_DOC_HDR_TRX_USER_KEY3.DELETE     ;
Line: 452

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ADJ_DOC_HDR_TRX_USER_KEY4.DELETE     ;
Line: 453

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ADJ_DOC_HDR_TRX_USER_KEY5.DELETE     ;
Line: 454

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ADJ_DOC_HDR_TRX_USER_KEY6.DELETE     ;
Line: 455

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ADJUSTED_DOC_LINE_ID.DELETE          ;
Line: 456

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ADJ_DOC_LIN_TRX_USER_KEY1.DELETE     ;
Line: 457

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ADJ_DOC_LIN_TRX_USER_KEY2.DELETE     ;
Line: 458

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ADJ_DOC_LIN_TRX_USER_KEY3.DELETE     ;
Line: 459

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ADJ_DOC_LIN_TRX_USER_KEY4.DELETE     ;
Line: 460

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ADJ_DOC_LIN_TRX_USER_KEY5.DELETE     ;
Line: 461

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ADJ_DOC_LIN_TRX_USER_KEY6.DELETE     ;
Line: 462

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ADJUSTED_DOC_NUMBER.DELETE           ;
Line: 463

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ADJUSTED_DOC_DATE.DELETE             ;
Line: 464

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APPLIED_TO_APPLICATION_ID.DELETE     ;
Line: 465

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APPLIED_TO_ENTITY_CODE.DELETE        ;
Line: 466

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APPLIED_TO_EVENT_CLASS_CODE.DELETE   ;
Line: 467

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APPLIED_TO_TRX_ID.DELETE             ;
Line: 468

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APP_TO_HDR_TRX_USER_KEY1.DELETE      ;
Line: 469

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APP_TO_HDR_TRX_USER_KEY2.DELETE      ;
Line: 470

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APP_TO_HDR_TRX_USER_KEY3.DELETE      ;
Line: 471

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APP_TO_HDR_TRX_USER_KEY4.DELETE      ;
Line: 472

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APP_TO_HDR_TRX_USER_KEY5.DELETE      ;
Line: 473

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APP_TO_HDR_TRX_USER_KEY6.DELETE      ;
Line: 474

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APPLIED_TO_TRX_LINE_ID.DELETE        ;
Line: 475

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APP_TO_LIN_TRX_USER_KEY1.DELETE      ;
Line: 476

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APP_TO_LIN_TRX_USER_KEY2.DELETE      ;
Line: 477

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APP_TO_LIN_TRX_USER_KEY3.DELETE      ;
Line: 478

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APP_TO_LIN_TRX_USER_KEY4.DELETE      ;
Line: 479

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APP_TO_LIN_TRX_USER_KEY5.DELETE      ;
Line: 480

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APP_TO_LIN_TRX_USER_KEY6.DELETE      ;
Line: 481

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_ID_LEVEL2.DELETE                 ;
Line: 482

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_ID_LEVEL3.DELETE                 ;
Line: 483

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_ID_LEVEL4.DELETE                 ;
Line: 484

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_ID_LEVEL5.DELETE                 ;
Line: 485

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_ID_LEVEL6.DELETE                 ;
Line: 486

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.HDR_TRX_USER_KEY1.DELETE             ;
Line: 487

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.HDR_TRX_USER_KEY2.DELETE             ;
Line: 488

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.HDR_TRX_USER_KEY3.DELETE             ;
Line: 489

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.HDR_TRX_USER_KEY4.DELETE             ;
Line: 490

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.HDR_TRX_USER_KEY5.DELETE             ;
Line: 491

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.HDR_TRX_USER_KEY6.DELETE             ;
Line: 492

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.LINE_TRX_USER_KEY1.DELETE            ;
Line: 493

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.LINE_TRX_USER_KEY2.DELETE            ;
Line: 494

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.LINE_TRX_USER_KEY3.DELETE            ;
Line: 495

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.LINE_TRX_USER_KEY4.DELETE            ;
Line: 496

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.LINE_TRX_USER_KEY5.DELETE            ;
Line: 497

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.LINE_TRX_USER_KEY6.DELETE            ;
Line: 498

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_NUMBER.DELETE                    ;
Line: 499

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_DESCRIPTION.DELETE               ;
Line: 500

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_LINE_NUMBER.DELETE               ;
Line: 501

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_LINE_DESCRIPTION.DELETE          ;
Line: 502

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.PRODUCT_DESCRIPTION.DELETE           ;
Line: 503

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_WAYBILL_NUMBER.DELETE            ;
Line: 504

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_COMMUNICATED_DATE.DELETE         ;
Line: 505

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_LINE_GL_DATE.DELETE              ;
Line: 506

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.BATCH_SOURCE_ID.DELETE               ;
Line: 507

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.BATCH_SOURCE_NAME.DELETE             ;
Line: 508

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DOC_SEQ_ID.DELETE                    ;
Line: 509

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DOC_SEQ_NAME.DELETE                  ;
Line: 510

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DOC_SEQ_VALUE.DELETE                 ;
Line: 511

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_DUE_DATE.DELETE                  ;
Line: 512

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_TYPE_DESCRIPTION.DELETE          ;
Line: 513

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.MERCHANT_PARTY_NAME.DELETE           ;
Line: 514

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.MERCHANT_PARTY_DOCUMENT_NUMBER.DELETE;
Line: 515

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.MERCHANT_PARTY_REFERENCE.DELETE      ;
Line: 516

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.MERCHANT_PARTY_TAXPAYER_ID.DELETE    ;
Line: 517

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.MERCHANT_PARTY_TAX_REG_NUMBER.DELETE ;
Line: 518

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.PAYING_PARTY_ID.DELETE               ;
Line: 519

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.OWN_HQ_PARTY_ID.DELETE               ;
Line: 520

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRADING_HQ_PARTY_ID.DELETE           ;
Line: 521

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.POI_PARTY_ID.DELETE                  ;
Line: 522

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.POD_PARTY_ID.DELETE                  ;
Line: 523

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TITLE_TRANSFER_PARTY_ID.DELETE       ;
Line: 524

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.PAYING_PARTY_SITE_ID.DELETE          ;
Line: 525

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.OWN_HQ_PARTY_SITE_ID.DELETE          ;
Line: 526

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRADING_HQ_PARTY_SITE_ID.DELETE      ;
Line: 527

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.POI_PARTY_SITE_ID.DELETE             ;
Line: 528

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.POD_PARTY_SITE_ID.DELETE             ;
Line: 529

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TITLE_TRANSFER_PARTY_SITE_ID.DELETE  ;
Line: 530

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.PAYING_LOCATION_ID.DELETE            ;
Line: 531

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.OWN_HQ_LOCATION_ID.DELETE            ;
Line: 532

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRADING_HQ_LOCATION_ID.DELETE        ;
Line: 533

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.POC_LOCATION_ID.DELETE               ;
Line: 534

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.POI_LOCATION_ID.DELETE               ;
Line: 535

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.POD_LOCATION_ID.DELETE               ;
Line: 536

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TITLE_TRANSFER_LOCATION_ID.DELETE    ;
Line: 537

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ASSESSABLE_VALUE.DELETE              ;
Line: 538

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ASSET_FLAG.DELETE                    ;
Line: 539

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ASSET_NUMBER.DELETE                  ;
Line: 540

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ASSET_ACCUM_DEPRECIATION.DELETE      ;
Line: 541

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ASSET_TYPE.DELETE                    ;
Line: 542

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ASSET_COST.DELETE                    ;
Line: 543

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.NUMERIC1.DELETE                      ;
Line: 544

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.NUMERIC2.DELETE                      ;
Line: 545

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.NUMERIC3.DELETE                      ;
Line: 546

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.NUMERIC4.DELETE                      ;
Line: 547

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.NUMERIC5.DELETE                      ;
Line: 548

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.NUMERIC6.DELETE                      ;
Line: 549

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.NUMERIC7.DELETE                      ;
Line: 550

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.NUMERIC8.DELETE                      ;
Line: 551

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.NUMERIC9.DELETE                      ;
Line: 552

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.NUMERIC10.DELETE                     ;
Line: 553

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.CHAR1.DELETE                         ;
Line: 554

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.CHAR2.DELETE                         ;
Line: 555

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.CHAR3.DELETE                         ;
Line: 556

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.CHAR4.DELETE                         ;
Line: 557

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.CHAR5.DELETE                         ;
Line: 558

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.CHAR6.DELETE                         ;
Line: 559

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.CHAR7.DELETE                         ;
Line: 560

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.CHAR8.DELETE                         ;
Line: 561

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.CHAR9.DELETE                         ;
Line: 562

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.CHAR10.DELETE                        ;
Line: 563

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DATE1.DELETE                         ;
Line: 564

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DATE2.DELETE                         ;
Line: 565

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DATE3.DELETE                         ;
Line: 566

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DATE4.DELETE                         ;
Line: 567

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DATE5.DELETE                         ;
Line: 568

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DATE6.DELETE                         ;
Line: 569

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DATE7.DELETE                         ;
Line: 570

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DATE8.DELETE                         ;
Line: 571

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DATE9.DELETE                         ;
Line: 572

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DATE10.DELETE                        ;
Line: 573

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.FIRST_PTY_ORG_ID.DELETE              ;
Line: 574

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TAX_EVENT_CLASS_CODE.DELETE          ;
Line: 575

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TAX_EVENT_TYPE_CODE.DELETE           ;
Line: 576

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DOC_EVENT_STATUS.DELETE              ;
Line: 577

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.RDNG_SHIP_TO_PTY_TX_PROF_ID.DELETE   ;
Line: 578

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.RDNG_SHIP_FROM_PTY_TX_PROF_ID.DELETE ;
Line: 579

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.RDNG_BILL_TO_PTY_TX_PROF_ID.DELETE   ;
Line: 580

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.RDNG_BILL_FROM_PTY_TX_PROF_ID.DELETE ;
Line: 581

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.RDNG_SHIP_TO_PTY_TX_P_ST_ID.DELETE   ;
Line: 582

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.RDNG_SHIP_FROM_PTY_TX_P_ST_ID.DELETE ;
Line: 583

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.RDNG_BILL_TO_PTY_TX_P_ST_ID.DELETE   ;
Line: 584

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.RDNG_BILL_FROM_PTY_TX_P_ST_ID.DELETE ;
Line: 585

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.SHIP_TO_PARTY_TAX_PROF_ID.DELETE     ;
Line: 586

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.SHIP_FROM_PARTY_TAX_PROF_ID.DELETE   ;
Line: 587

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.POA_PARTY_TAX_PROF_ID.DELETE         ;
Line: 588

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.POO_PARTY_TAX_PROF_ID.DELETE         ;
Line: 589

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.PAYING_PARTY_TAX_PROF_ID.DELETE      ;
Line: 590

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.OWN_HQ_PARTY_TAX_PROF_ID.DELETE      ;
Line: 591

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRADING_HQ_PARTY_TAX_PROF_ID.DELETE  ;
Line: 592

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.POI_PARTY_TAX_PROF_ID.DELETE         ;
Line: 593

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.POD_PARTY_TAX_PROF_ID.DELETE         ;
Line: 594

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.BILL_TO_PARTY_TAX_PROF_ID.DELETE     ;
Line: 595

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.BILL_FROM_PARTY_TAX_PROF_ID.DELETE   ;
Line: 596

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TITLE_TRANS_PARTY_TAX_PROF_ID.DELETE ;
Line: 597

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.SHIP_TO_SITE_TAX_PROF_ID.DELETE      ;
Line: 598

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.SHIP_FROM_SITE_TAX_PROF_ID.DELETE    ;
Line: 599

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.POA_SITE_TAX_PROF_ID.DELETE          ;
Line: 600

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.POO_SITE_TAX_PROF_ID.DELETE          ;
Line: 601

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.PAYING_SITE_TAX_PROF_ID.DELETE       ;
Line: 602

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.OWN_HQ_SITE_TAX_PROF_ID.DELETE       ;
Line: 603

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRADING_HQ_SITE_TAX_PROF_ID.DELETE   ;
Line: 604

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.POI_SITE_TAX_PROF_ID.DELETE          ;
Line: 605

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.POD_SITE_TAX_PROF_ID.DELETE          ;
Line: 606

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.BILL_TO_SITE_TAX_PROF_ID.DELETE      ;
Line: 607

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.BILL_FROM_SITE_TAX_PROF_ID.DELETE    ;
Line: 608

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TITLE_TRANS_SITE_TAX_PROF_ID.DELETE  ;
Line: 609

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.MERCHANT_PARTY_TAX_PROF_ID.DELETE    ;
Line: 610

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.HQ_ESTB_PARTY_TAX_PROF_ID.DELETE     ;
Line: 611

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DOCUMENT_SUB_TYPE.DELETE             ;
Line: 612

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.SUPPLIER_TAX_INVOICE_NUMBER.DELETE   ;
Line: 613

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.SUPPLIER_TAX_INVOICE_DATE.DELETE     ;
Line: 614

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.SUPPLIER_EXCHANGE_RATE.DELETE        ;
Line: 615

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TAX_INVOICE_DATE.DELETE              ;
Line: 616

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TAX_INVOICE_NUMBER.DELETE            ;
Line: 617

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.LINE_AMT_INCLUDES_TAX_FLAG.DELETE    ;
Line: 618

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.QUOTE_FLAG.DELETE                    ;
Line: 619

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DEFAULT_TAXATION_COUNTRY.DELETE      ;
Line: 620

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.HISTORICAL_FLAG.DELETE               ;
Line: 621

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.INTERNAL_ORG_LOCATION_ID.DELETE      ;
Line: 622

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.CTRL_HDR_TX_APPL_FLAG.DELETE         ;
Line: 623

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.CTRL_TOTAL_HDR_TX_AMT.DELETE         ;
Line: 624

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.CTRL_TOTAL_LINE_TX_AMT.DELETE        ;
Line: 625

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DIST_LEVEL_ACTION.DELETE             ;
Line: 626

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APPLIED_FROM_TAX_DIST_ID.DELETE      ;
Line: 627

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ADJUSTED_DOC_TAX_DIST_ID.DELETE      ;
Line: 628

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TASK_ID.DELETE                       ;
Line: 629

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.AWARD_ID.DELETE                      ;
Line: 630

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.PROJECT_ID.DELETE                    ;
Line: 631

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.EXPENDITURE_TYPE.DELETE              ;
Line: 632

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.EXPENDITURE_ORGANIZATION_ID.DELETE   ;
Line: 633

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.EXPENDITURE_ITEM_DATE.DELETE         ;
Line: 634

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_LINE_DIST_AMT.DELETE             ;
Line: 635

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_LINE_DIST_QUANTITY.DELETE        ;
Line: 636

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.REF_DOC_CURR_CONV_RATE.DELETE        ;
Line: 637

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ITEM_DIST_NUMBER.DELETE              ;
Line: 638

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.REF_DOC_DIST_ID.DELETE               ;
Line: 639

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_LINE_DIST_TAX_AMT.DELETE         ;
Line: 640

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_LINE_DIST_ID.DELETE              ;
Line: 641

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DIST_TRX_USER_KEY1.DELETE            ;
Line: 642

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DIST_TRX_USER_KEY2.DELETE            ;
Line: 643

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DIST_TRX_USER_KEY3.DELETE            ;
Line: 644

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DIST_TRX_USER_KEY4.DELETE            ;
Line: 645

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DIST_TRX_USER_KEY5.DELETE            ;
Line: 646

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DIST_TRX_USER_KEY6.DELETE            ;
Line: 647

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APPLIED_FROM_DIST_ID.DELETE          ;
Line: 648

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APP_FROM_DST_TRX_USER_KEY1.DELETE    ;
Line: 649

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APP_FROM_DST_TRX_USER_KEY2.DELETE    ;
Line: 650

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APP_FROM_DST_TRX_USER_KEY3.DELETE    ;
Line: 651

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APP_FROM_DST_TRX_USER_KEY4.DELETE    ;
Line: 652

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APP_FROM_DST_TRX_USER_KEY5.DELETE    ;
Line: 653

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APP_FROM_DST_TRX_USER_KEY6.DELETE    ;
Line: 654

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ADJUSTED_DOC_DIST_ID.DELETE          ;
Line: 655

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ADJ_DOC_DST_TRX_USER_KEY1.DELETE     ;
Line: 656

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ADJ_DOC_DST_TRX_USER_KEY2.DELETE     ;
Line: 657

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ADJ_DOC_DST_TRX_USER_KEY3.DELETE     ;
Line: 658

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ADJ_DOC_DST_TRX_USER_KEY4.DELETE     ;
Line: 659

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ADJ_DOC_DST_TRX_USER_KEY5.DELETE     ;
Line: 660

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ADJ_DOC_DST_TRX_USER_KEY6.DELETE     ;
Line: 661

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.INPUT_TAX_CLASSIFICATION_CODE.DELETE ;
Line: 662

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.OUTPUT_TAX_CLASSIFICATION_CODE.DELETE;
Line: 663

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.PORT_OF_ENTRY_CODE.DELETE            ;
Line: 664

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TAX_REPORTING_FLAG.DELETE            ;
Line: 665

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TAX_AMT_INCLUDED_FLAG.DELETE         ;
Line: 666

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.COMPOUNDING_TAX_FLAG.DELETE          ;
Line: 667

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.PROVNL_TAX_DETERMINATION_DATE.DELETE ;
Line: 668

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.SHIP_THIRD_PTY_ACCT_SITE_ID.DELETE   ;
Line: 669

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.BILL_THIRD_PTY_ACCT_SITE_ID.DELETE   ;
Line: 670

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.SHIP_TO_CUST_ACCT_SITE_USE_ID.DELETE ;
Line: 671

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.BILL_TO_CUST_ACCT_SITE_USE_ID.DELETE ;
Line: 672

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.SHIP_THIRD_PTY_ACCT_ID.DELETE        ;
Line: 673

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.BILL_THIRD_PTY_ACCT_ID.DELETE        ;
Line: 674

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.SOURCE_APPLICATION_ID.DELETE         ;
Line: 675

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.SOURCE_ENTITY_CODE.DELETE            ;
Line: 676

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.SOURCE_EVENT_CLASS_CODE.DELETE       ;
Line: 677

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.SOURCE_TRX_ID.DELETE                 ;
Line: 678

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.SOURCE_LINE_ID.DELETE                ;
Line: 679

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.SOURCE_TRX_LEVEL_TYPE.DELETE         ;
Line: 680

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.INSERT_UPDATE_FLAG.DELETE            ;
Line: 681

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APPLIED_TO_TRX_NUMBER.DELETE         ;
Line: 682

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.START_EXPENSE_DATE.DELETE            ;
Line: 683

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_BATCH_ID.DELETE                  ;
Line: 684

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.RECORD_TYPE_CODE.DELETE              ;
Line: 685

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.REF_DOC_TRX_LEVEL_TYPE.DELETE        ;
Line: 686

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APPLIED_FROM_TRX_LEVEL_TYPE.DELETE   ;
Line: 687

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APPLIED_TO_TRX_LEVEL_TYPE.DELETE     ;
Line: 688

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ADJUSTED_DOC_TRX_LEVEL_TYPE.DELETE   ;
Line: 689

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE1.DELETE         ;
Line: 690

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE2.DELETE         ;
Line: 691

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE3.DELETE         ;
Line: 692

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE4.DELETE         ;
Line: 693

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE5.DELETE         ;
Line: 694

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE6.DELETE         ;
Line: 695

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE7.DELETE         ;
Line: 696

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE8.DELETE         ;
Line: 697

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE9.DELETE         ;
Line: 698

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.DEFAULTING_ATTRIBUTE10.DELETE        ;
Line: 699

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TAX_PROCESSING_COMPLETED_FLAG.DELETE ;
Line: 700

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.APPLICATION_DOC_STATUS.DELETE        ;
Line: 701

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.OVERRIDING_RECOVERY_RATE.DELETE      ;
Line: 702

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TAX_CALCULATION_DONE_FLAG.DELETE     ;
Line: 703

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.SOURCE_TAX_LINE_ID.DELETE            ;
Line: 704

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.REVERSED_APPLN_ID.DELETE             ;
Line: 705

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.REVERSED_ENTITY_CODE.DELETE          ;
Line: 706

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.REVERSED_EVNT_CLS_CODE.DELETE        ;
Line: 707

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.REVERSED_TRX_ID.DELETE               ;
Line: 708

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.REVERSED_TRX_LEVEL_TYPE.DELETE       ;
Line: 709

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.REVERSED_TRX_LINE_ID.DELETE          ;
Line: 710

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.EXEMPTION_CONTROL_FLAG.DELETE        ;
Line: 711

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.EXEMPT_REASON_CODE.DELETE            ;
Line: 712

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.INTERFACE_ENTITY_CODE.DELETE         ;
Line: 713

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.INTERFACE_LINE_ID.DELETE             ;
Line: 714

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.HISTORICAL_TAX_CODE_ID.DELETE        ;
Line: 715

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.USER_UPD_DET_FACTORS_FLAG.DELETE     ;
Line: 716

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ICX_SESSION_ID.DELETE                ;
Line: 717

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.HDR_SHIP_THIRD_PTY_ACCT_ST_ID.DELETE ;
Line: 718

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.HDR_BILL_THIRD_PTY_ACCT_ST_ID.DELETE ;
Line: 719

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.HDR_BILL_TO_CST_ACCT_ST_USE_ID.DELETE;
Line: 720

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.HDR_SHIP_TO_CST_ACCT_ST_USE_ID.DELETE;
Line: 721

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.HDR_SHIP_THIRD_PTY_ACCT_ID.DELETE    ;
Line: 722

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.HDR_BILL_THIRD_PTY_ACCT_ID.DELETE    ;
Line: 723

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.HDR_RECEIVABLES_TRX_TYPE_ID.DELETE   ;
Line: 724

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.GLOBAL_ATTRIBUTE1.DELETE             ;
Line: 725

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.GLOBAL_ATTRIBUTE_CATEGORY.DELETE     ;
Line: 726

        ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TOTAL_INC_TAX_AMT.DELETE     ;
Line: 728

          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: 730

 END delete_trx_line_dist_tbl;
Line: 1106

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