DBA Data[Home] [Help]

APPS.GMD_EBI_RECIPE_PUB SQL Statements

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

Line: 24

    SELECT inventory_item_id FROM mtl_system_items_b WHERE
    inventory_item_id= p_item_id AND organization_id= p_org_id;
Line: 91

          SELECT  recipe_enabled_flag INTO l_temp FROM mtl_system_items_b WHERE inventory_item_id=p_formula_obj.formula_details(j).inventory_item_id
          AND organization_id=p_formula_obj.formula_details(j).owner_organization_id;
Line: 112

/*   update_org_ids                                                         */

/*                                                                          */

/* DESCRIPTION:                                                             */

/*   This procedure converts organization code to organization ids.         */

/* ======================================================================== */

PROCEDURE update_org_ids(
p_formula_obj IN gmd_ebi_formula_obj
,x_formula_obj OUT NOCOPY gmd_ebi_formula_obj
,x_msg_count OUT NOCOPY NUMBER
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_data OUT NOCOPY VARCHAR2
)
IS
  l_org_id NUMBER;
Line: 136

    SELECT organization_id INTO l_org_id  FROM mtl_parameters
    WHERE organization_code = l_formula_obj.formula_header.OWNER_ORGANIZATION_CODE;
Line: 157

PROCEDURE update_item_ids(
p_formula_obj IN gmd_ebi_formula_obj
,x_formula_obj OUT NOCOPY gmd_ebi_formula_obj
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_data OUT NOCOPY VARCHAR2
)
IS
  l_item_id NUMBER;
Line: 173

        SELECT inventory_item_id INTO l_item_id  FROM mtl_system_items_kfv
        WHERE concatenated_segments = l_formula_obj.formula_details(j).item_no
        AND organization_id = l_formula_obj.formula_details(j).owner_organization_id;
Line: 192

/*   update_org_ids                                                         */

/*                                                                          */

/* DESCRIPTION:                                                             */

/*   This procedure populates the output object with the entity ids and     */

/*   corresponding business component ids.                                  */

/* ======================================================================== */

PROCEDURE  populate_output(
  p_input IN gmd_ebi_formula_obj
  ,p_line_delete_tbl IN gmd_ebi_formula_line_del_tbl
  ,status_flag IN VARCHAR2
  ,x_output OUT NOCOPY gmd_ebi_formula_output_obj
  ,x_return_status  OUT NOCOPY      VARCHAR2
  ,x_msg_count      OUT NOCOPY      NUMBER
  ,x_msg_data       OUT NOCOPY      VARCHAR2
  )
IS
  l_out_obj gmd_ebi_formula_output_obj;
Line: 223

      SELECT Max(formula_id) INTO l_form_id FROM fm_form_mst_b WHERE formula_no = p_input.formula_header.formula_no;
Line: 228

      SELECT formulaline_id INTO l_form_line_id FROM fm_matl_dtl WHERE formula_id = l_form_id
      AND line_type=p_input.formula_details(j).line_type AND line_no = p_input.formula_details(j).line_no;
Line: 235

    l_out_obj := gmd_ebi_formula_output_obj(p_input.formula_header.business_component_id,l_form_id,l_out_line_sync_tbl,p_line_delete_tbl);
Line: 262

  SELECT organization_id INTO l_org_id
  FROM MTL_PARAMETERS
  WHERE organization_code=p_org_code;
Line: 281

/*   The procedure creates/updates routings and routing step dependencies   */

/* ======================================================================== */

PROCEDURE sync_routings(
    p_routing_obj IN gmd_ebi_mfg_routing_obj
    ,p_commit IN VARCHAR2
    ,x_return_status  OUT NOCOPY      VARCHAR2
    ,x_msg_count      OUT NOCOPY      NUMBER
    ,x_msg_data       OUT NOCOPY      VARCHAR2
    )
IS
  l_routings_insert               gmd_routings%ROWTYPE;
Line: 296

  l_routings_step_tbl_insert      GMD_ROUTINGS_PUB.gmd_routings_step_tab;
Line: 297

  l_routings_step_dep_tbl_insert  GMD_ROUTINGS_PUB.gmd_routings_step_dep_tab;
Line: 298

  l_routings_step_insert_ctr      NUMBER :=1;
Line: 299

  l_routings_step_dep_insert_ctr  NUMBER :=1;
Line: 303

  l_rout_tbl                      GMD_ROUTINGS_PUB.update_tbl_type;
Line: 304

  l_rout_rec                      GMD_ROUTINGS_PUB.update_table_rec_type;
Line: 307

    l_routings_insert.ROUTING_STATUS           := p_routing_obj.ROUTING_STATUS;
Line: 308

    l_routings_insert.ENFORCE_STEP_DEPENDENCY  := p_routing_obj.ENFORCE_STEP_DEPENDENCY;
Line: 309

    l_routings_insert.ROUTING_DESC             := p_routing_obj.ROUTING_DESC;
Line: 310

    l_routings_insert.FIXED_PROCESS_LOSS       := p_routing_obj.FIXED_PROCESS_LOSS ;
Line: 311

    l_routings_insert.FIXED_PROCESS_LOSS_UOM   := p_routing_obj.FIXED_PROCESS_LOSS_UOM;
Line: 312

    l_routings_insert.OWNER_ORGANIZATION_ID    := get_org_id(p_routing_obj.OWNER_ORGANIZATION_CODE);
Line: 313

    l_routings_insert.ROUTING_ID               := p_routing_obj.ROUTING_ID;
Line: 314

    l_routings_insert.ROUTING_NO              := p_routing_obj.ROUTING_NO;
Line: 315

    l_routings_insert.ROUTING_VERS            := p_routing_obj.ROUTING_VERS;
Line: 316

    l_routings_insert.ROUTING_CLASS           := p_routing_obj.ROUTING_CLASS ;
Line: 317

    l_routings_insert.ROUTING_QTY             := p_routing_obj.ROUTING_QTY;
Line: 318

    l_routings_insert.ITEM_UM                 := p_routing_obj.ITEM_UM ;
Line: 319

    l_routings_insert.ROUTING_UOM             := p_routing_obj.ROUTING_UOM ;
Line: 320

    l_routings_insert.CONTIGUOUS_IND          := p_routing_obj.CONTIGUOUS_IND;
Line: 321

    l_routings_insert.DELETE_MARK             := p_routing_obj.DELETE_MARK;
Line: 322

    l_routings_insert.TEXT_CODE               := p_routing_obj.TEXT_CODE;
Line: 323

    l_routings_insert.INACTIVE_IND            := p_routing_obj.INACTIVE_IND ;
Line: 324

    l_routings_insert.IN_USE                  := p_routing_obj.IN_USE;
Line: 325

    l_routings_insert.CREATION_DATE           := Nvl(p_routing_obj.CREATION_DATE,SYSDATE);
Line: 326

    l_routings_insert.CREATED_BY              := Nvl(p_routing_obj.CREATED_BY,FND_GLOBAL.USER_ID);
Line: 327

    l_routings_insert.LAST_UPDATE_LOGIN       := Nvl(p_routing_obj.LAST_UPDATE_LOGIN ,FND_GLOBAL.USER_ID);
Line: 328

    l_routings_insert.LAST_UPDATE_DATE        := Nvl(p_routing_obj.LAST_UPDATE_DATE,SYSDATE);
Line: 329

    l_routings_insert.LAST_UPDATED_BY         := Nvl(p_routing_obj.LAST_UPDATED_BY,FND_GLOBAL.USER_ID);
Line: 330

    l_routings_insert.ATTRIBUTE_CATEGORY      :=p_routing_obj.flex_obj.ATTRIBUTE_CATEGORY;
Line: 331

    l_routings_insert.ATTRIBUTE_CATEGORY:=p_routing_obj.flex_obj.ATTRIBUTE_CATEGORY;
Line: 332

    l_routings_insert.ATTRIBUTE1:=p_routing_obj.flex_obj.ATTRIBUTE1;
Line: 333

    l_routings_insert.ATTRIBUTE2:=p_routing_obj.flex_obj.ATTRIBUTE2;
Line: 334

    l_routings_insert.ATTRIBUTE3:=p_routing_obj.flex_obj.ATTRIBUTE3;
Line: 335

    l_routings_insert.ATTRIBUTE4:=p_routing_obj.flex_obj.ATTRIBUTE4;
Line: 336

    l_routings_insert.ATTRIBUTE5:=p_routing_obj.flex_obj.ATTRIBUTE5;
Line: 337

    l_routings_insert.ATTRIBUTE6:=p_routing_obj.flex_obj.ATTRIBUTE6;
Line: 338

    l_routings_insert.ATTRIBUTE7:=p_routing_obj.flex_obj.ATTRIBUTE7;
Line: 339

    l_routings_insert.ATTRIBUTE8:=p_routing_obj.flex_obj.ATTRIBUTE8;
Line: 340

    l_routings_insert.ATTRIBUTE9:=p_routing_obj.flex_obj.ATTRIBUTE9;
Line: 341

    l_routings_insert.ATTRIBUTE10:=p_routing_obj.flex_obj.ATTRIBUTE10;
Line: 342

    l_routings_insert.ATTRIBUTE11:=p_routing_obj.flex_obj.ATTRIBUTE11;
Line: 343

    l_routings_insert.ATTRIBUTE12:=p_routing_obj.flex_obj.ATTRIBUTE12;
Line: 344

    l_routings_insert.ATTRIBUTE13:=p_routing_obj.flex_obj.ATTRIBUTE13;
Line: 345

    l_routings_insert.ATTRIBUTE14:=p_routing_obj.flex_obj.ATTRIBUTE14;
Line: 346

    l_routings_insert.ATTRIBUTE15:=p_routing_obj.flex_obj.ATTRIBUTE15;
Line: 347

    l_routings_insert.ATTRIBUTE16:=p_routing_obj.flex_obj.ATTRIBUTE16;
Line: 348

    l_routings_insert.ATTRIBUTE17:=p_routing_obj.flex_obj.ATTRIBUTE17;
Line: 349

    l_routings_insert.ATTRIBUTE18:=p_routing_obj.flex_obj.ATTRIBUTE18;
Line: 350

    l_routings_insert.ATTRIBUTE19:=p_routing_obj.flex_obj.ATTRIBUTE19;
Line: 351

    l_routings_insert.ATTRIBUTE20:=p_routing_obj.flex_obj.ATTRIBUTE20;
Line: 352

    l_routings_insert.ATTRIBUTE21:=p_routing_obj.flex_obj.ATTRIBUTE21;
Line: 353

    l_routings_insert.ATTRIBUTE22:=p_routing_obj.flex_obj.ATTRIBUTE22;
Line: 354

    l_routings_insert.ATTRIBUTE23:=p_routing_obj.flex_obj.ATTRIBUTE23;
Line: 355

    l_routings_insert.ATTRIBUTE24:=p_routing_obj.flex_obj.ATTRIBUTE24;
Line: 356

    l_routings_insert.ATTRIBUTE25:=p_routing_obj.flex_obj.ATTRIBUTE25;
Line: 357

    l_routings_insert.ATTRIBUTE26:=p_routing_obj.flex_obj.ATTRIBUTE26;
Line: 358

    l_routings_insert.ATTRIBUTE27:=p_routing_obj.flex_obj.ATTRIBUTE27;
Line: 359

    l_routings_insert.ATTRIBUTE28:=p_routing_obj.flex_obj.ATTRIBUTE28;
Line: 360

    l_routings_insert.ATTRIBUTE29:=p_routing_obj.flex_obj.ATTRIBUTE29;
Line: 361

    l_routings_insert.ATTRIBUTE30:=p_routing_obj.flex_obj.ATTRIBUTE30;
Line: 362

    l_routings_insert.EFFECTIVE_START_DATE    := p_routing_obj.EFFECTIVE_START_DATE;
Line: 363

    l_routings_insert.EFFECTIVE_END_DATE      := p_routing_obj.EFFECTIVE_END_DATE;
Line: 364

    l_routings_insert.OWNER_ID                := Nvl(p_routing_obj.OWNER_ID,FND_GLOBAL.USER_ID);
Line: 365

    l_routings_insert.PROJECT_ID              := p_routing_obj.PROJECT_ID ;
Line: 366

    l_routings_insert.PROCESS_LOSS            := p_routing_obj.PROCESS_LOSS ;
Line: 378

      l_routings_step_rec.LAST_UPDATED_BY:=Nvl(p_routing_obj.gmd_ebi_routing_steps(j).LAST_UPDATED_BY,FND_GLOBAL.USER_ID);
Line: 380

      l_routings_step_rec.LAST_UPDATE_DATE:=Nvl(p_routing_obj.gmd_ebi_routing_steps(j).LAST_UPDATE_DATE,SYSDATE);
Line: 382

      l_routings_step_rec.LAST_UPDATE_LOGIN:=Nvl(p_routing_obj.gmd_ebi_routing_steps(j).LAST_UPDATE_LOGIN,FND_GLOBAL.USER_ID);
Line: 413

      l_routings_step_tbl_insert(l_routings_step_insert_ctr) := l_routings_step_rec;
Line: 414

      l_routings_step_insert_ctr := l_routings_step_insert_ctr + 1;
Line: 430

      l_routings_step_dep_rec.LAST_UPDATED_BY := Nvl(p_routing_obj.gmd_ebi_rtg_step_dependency(i).LAST_UPDATED_BY,FND_GLOBAL.USER_ID);
Line: 432

      l_routings_step_dep_rec.LAST_UPDATE_DATE := Nvl(p_routing_obj.gmd_ebi_rtg_step_dependency(i).LAST_UPDATE_DATE,SYSDATE);
Line: 434

      l_routings_step_dep_rec.LAST_UPDATE_LOGIN := Nvl(p_routing_obj.gmd_ebi_rtg_step_dependency(i).LAST_UPDATE_LOGIN,FND_GLOBAL.USER_ID);
Line: 436

      l_routings_step_dep_tbl_insert(l_routings_step_dep_insert_ctr) := l_routings_step_dep_rec;
Line: 437

      l_routings_step_dep_insert_ctr := l_routings_step_dep_insert_ctr + 1;
Line: 440

    GMD_ROUTINGS_PUB.insert_routing(
      p_api_version              => 1
      , p_init_msg_list          => TRUE
      , p_commit                 => FALSE
      , p_routings               => l_routings_insert
      , p_routings_step_tbl      => l_routings_step_tbl_insert
      , p_routings_step_dep_tbl  => l_routings_step_dep_tbl_insert
      , x_message_count          => l_msg_count
      , x_message_list           => l_msg
      , x_return_status          => l_ret_status
    );
Line: 456

    l_rout_rec.p_col_to_update := 'routing_status';
Line: 459

    l_rout_rec.p_col_to_update := 'enforce_step_dependency';
Line: 462

    l_rout_rec.p_col_to_update := 'routing_desc';
Line: 465

    l_rout_rec.p_col_to_update := 'fixed_process_loss';
Line: 468

    l_rout_rec.p_col_to_update := 'fixed_process_loss_uom';
Line: 471

    l_rout_rec.p_col_to_update := 'owner_organization_id';
Line: 474

    l_rout_rec.p_col_to_update := 'routing_id';
Line: 477

    l_rout_rec.p_col_to_update := 'routing_no';
Line: 480

    l_rout_rec.p_col_to_update := 'routing_vers';
Line: 483

    l_rout_rec.p_col_to_update := 'routing_class';
Line: 486

    l_rout_rec.p_col_to_update := 'routing_qty';
Line: 489

    l_rout_rec.p_col_to_update := 'item_um';
Line: 492

    l_rout_rec.p_col_to_update := 'routing_uom';
Line: 495

    l_rout_rec.p_col_to_update := 'contiguous_ind';
Line: 498

    l_rout_rec.p_col_to_update := 'delete_mark';
Line: 499

    l_rout_rec.p_value := p_routing_obj.delete_mark;
Line: 501

    l_rout_rec.p_col_to_update := 'text_code';
Line: 504

    l_rout_rec.p_col_to_update := 'inactive_ind';
Line: 507

    l_rout_rec.p_col_to_update := 'in_use';
Line: 510

    l_rout_rec.p_col_to_update := 'creation_date';
Line: 513

    l_rout_rec.p_col_to_update := 'created_by';
Line: 516

    l_rout_rec.p_col_to_update := 'last_update_login';
Line: 517

    l_rout_rec.p_value := p_routing_obj.last_update_login;
Line: 519

    l_rout_rec.p_col_to_update := 'last_update_date';
Line: 520

    l_rout_rec.p_value := p_routing_obj.last_update_date;
Line: 522

    l_rout_rec.p_col_to_update := 'last_updated_by';
Line: 523

    l_rout_rec.p_value := p_routing_obj.last_updated_by;
Line: 525

    l_rout_rec.p_col_to_update := 'effective_start_date';
Line: 528

    l_rout_rec.p_col_to_update := 'effective_end_date';
Line: 531

    l_rout_rec.p_col_to_update := 'owner_id';
Line: 534

    l_rout_rec.p_col_to_update := 'project_id';
Line: 537

    l_rout_rec.p_col_to_update := 'process_loss';
Line: 540

    l_rout_rec.p_col_to_update := 'attribute_category';
Line: 543

    l_rout_rec.p_col_to_update := 'attribute1';
Line: 546

    l_rout_rec.p_col_to_update := 'attribute2';
Line: 549

    l_rout_rec.p_col_to_update := 'attribute3';
Line: 552

    l_rout_rec.p_col_to_update := 'attribute4';
Line: 555

    l_rout_rec.p_col_to_update := 'attribute5';
Line: 558

    l_rout_rec.p_col_to_update := 'attribute6';
Line: 561

    l_rout_rec.p_col_to_update := 'attribute7';
Line: 564

    l_rout_rec.p_col_to_update := 'attribute8';
Line: 567

    l_rout_rec.p_col_to_update := 'attribute9';
Line: 570

    l_rout_rec.p_col_to_update := 'attribute10';
Line: 573

    l_rout_rec.p_col_to_update := 'attribute11';
Line: 576

    l_rout_rec.p_col_to_update := 'attribute12';
Line: 579

    l_rout_rec.p_col_to_update := 'attribute13';
Line: 582

    l_rout_rec.p_col_to_update := 'attribute14';
Line: 585

    l_rout_rec.p_col_to_update := 'attribute15';
Line: 588

    l_rout_rec.p_col_to_update := 'attribute16';
Line: 591

    l_rout_rec.p_col_to_update := 'attribute17';
Line: 594

    l_rout_rec.p_col_to_update := 'attribute18';
Line: 597

    l_rout_rec.p_col_to_update := 'attribute19';
Line: 600

    l_rout_rec.p_col_to_update := 'attribute20';
Line: 603

    l_rout_rec.p_col_to_update := 'attribute21';
Line: 606

    l_rout_rec.p_col_to_update := 'attribute22';
Line: 609

    l_rout_rec.p_col_to_update := 'attribute23';
Line: 612

    l_rout_rec.p_col_to_update := 'attribute24';
Line: 615

    l_rout_rec.p_col_to_update := 'attribute25';
Line: 618

    l_rout_rec.p_col_to_update := 'attribute26';
Line: 621

    l_rout_rec.p_col_to_update := 'attribute27';
Line: 624

    l_rout_rec.p_col_to_update := 'attribute28';
Line: 627

    l_rout_rec.p_col_to_update := 'attribute29';
Line: 630

    l_rout_rec.p_col_to_update := 'attribute30';
Line: 634

    GMD_ROUTINGS_PUB.update_routing
    ( p_api_version  =>  1
    , p_init_msg_list => TRUE
    , p_commit		=> FALSE
    , p_routing_id	=> p_routing_obj.ROUTING_ID
    , p_routing_no	=> p_routing_obj.ROUTING_NO
    , p_routing_vers	=> p_routing_obj.ROUTING_VERS
    , p_update_table	=> l_rout_tbl
    , x_message_count => l_msg_count
    , x_message_list 	=> l_msg
    , x_return_status	=> l_ret_status
    );
Line: 663

        l_routings_step_rec.LAST_UPDATED_BY:=Nvl(p_routing_obj.gmd_ebi_routing_steps(j).LAST_UPDATED_BY,FND_GLOBAL.USER_ID);
Line: 665

        l_routings_step_rec.LAST_UPDATE_DATE:=NVL(p_routing_obj.gmd_ebi_routing_steps(j).LAST_UPDATE_DATE,SYSDATE);
Line: 667

        l_routings_step_rec.LAST_UPDATE_LOGIN:=Nvl(p_routing_obj.gmd_ebi_routing_steps(j).LAST_UPDATE_LOGIN,FND_GLOBAL.USER_ID);
Line: 698

        IF  l_routings_step_dep_tbl_insert.Count > 1 THEN
          l_routings_step_dep_tbl_insert.DELETE;
Line: 701

        l_routings_step_dep_insert_ctr := 1;
Line: 719

            l_routings_step_dep_rec.LAST_UPDATED_BY := Nvl(p_routing_obj.gmd_ebi_rtg_step_dependency(i).LAST_UPDATED_BY,FND_GLOBAL.USER_ID);
Line: 721

            l_routings_step_dep_rec.LAST_UPDATE_DATE := Nvl(p_routing_obj.gmd_ebi_rtg_step_dependency(i).LAST_UPDATE_DATE,SYSDATE);
Line: 723

            l_routings_step_dep_rec.LAST_UPDATE_LOGIN := Nvl(p_routing_obj.gmd_ebi_rtg_step_dependency(i).LAST_UPDATE_LOGIN,FND_GLOBAL.USER_ID);
Line: 725

            l_routings_step_dep_tbl_insert(l_routings_step_dep_insert_ctr) := l_routings_step_dep_rec;
Line: 726

            l_routings_step_dep_insert_ctr := l_routings_step_dep_insert_ctr + 1;
Line: 729

        GMD_ROUTING_STEPS_PUB.insert_routing_steps
          (
          p_api_version => 1
          , p_init_msg_list => FALSE
          , p_commit		    => FALSE
          , p_routing_id    => p_routing_obj.ROUTING_ID
          , p_routing_no    => p_routing_obj.ROUTING_NO
          , p_routing_vers  => p_routing_obj.ROUTING_VERS
          , p_routing_step_rec => l_routings_step_rec
          , p_routings_step_dep_tbl => l_routings_step_dep_tbl_insert
          , x_message_count  => l_msg_count
          , x_message_list   => l_msg
          , x_return_status  => l_ret_status
          );
Line: 748

          l_rout_tbl.DELETE;
Line: 750

        l_rout_rec.p_col_to_update := 'x_coordinate';
Line: 753

        l_rout_rec.p_col_to_update := 'y_coordinate';
Line: 756

        l_rout_rec.p_col_to_update := 'minimum_transfer_qty';
Line: 759

        l_rout_rec.p_col_to_update := 'routing_id';
Line: 762

        l_rout_rec.p_col_to_update := 'routingstep_no';
Line: 765

        l_rout_rec.p_col_to_update := 'routingstep_id';
Line: 768

        l_rout_rec.p_col_to_update := 'oprn_id';
Line: 771

        l_rout_rec.p_col_to_update := 'step_qty';
Line: 774

        l_rout_rec.p_col_to_update := 'steprelease_type';
Line: 777

        l_rout_rec.p_col_to_update := 'text_code';
Line: 780

        l_rout_rec.p_col_to_update := 'last_updated_by';
Line: 781

        l_rout_rec.p_value := p_routing_obj.gmd_ebi_routing_steps(j).last_updated_by;
Line: 783

        l_rout_rec.p_col_to_update := 'created_by';
Line: 786

        l_rout_rec.p_col_to_update := 'last_update_date';
Line: 787

        l_rout_rec.p_value := p_routing_obj.gmd_ebi_routing_steps(j).last_update_date;
Line: 789

        l_rout_rec.p_col_to_update := 'creation_date';
Line: 792

        l_rout_rec.p_col_to_update := 'last_update_login';
Line: 793

        l_rout_rec.p_value := p_routing_obj.gmd_ebi_routing_steps(j).last_update_login;
Line: 795

        l_rout_rec.p_col_to_update := 'attribute_category';
Line: 798

        l_rout_rec.p_col_to_update := 'attribute1';
Line: 801

        l_rout_rec.p_col_to_update := 'attribute2';
Line: 804

        l_rout_rec.p_col_to_update := 'attribute3';
Line: 807

        l_rout_rec.p_col_to_update := 'attribute4';
Line: 810

        l_rout_rec.p_col_to_update := 'attribute5';
Line: 813

        l_rout_rec.p_col_to_update := 'attribute6';
Line: 816

        l_rout_rec.p_col_to_update := 'attribute7';
Line: 819

        l_rout_rec.p_col_to_update := 'attribute8';
Line: 822

        l_rout_rec.p_col_to_update := 'attribute9';
Line: 825

        l_rout_rec.p_col_to_update := 'attribute10';
Line: 828

        l_rout_rec.p_col_to_update := 'attribute11';
Line: 831

        l_rout_rec.p_col_to_update := 'attribute12';
Line: 834

        l_rout_rec.p_col_to_update := 'attribute13';
Line: 837

        l_rout_rec.p_col_to_update := 'attribute14';
Line: 840

        l_rout_rec.p_col_to_update := 'attribute15';
Line: 843

        l_rout_rec.p_col_to_update := 'attribute16';
Line: 846

        l_rout_rec.p_col_to_update := 'attribute17';
Line: 849

        l_rout_rec.p_col_to_update := 'attribute18';
Line: 852

        l_rout_rec.p_col_to_update := 'attribute19';
Line: 855

        l_rout_rec.p_col_to_update := 'attribute20';
Line: 858

        l_rout_rec.p_col_to_update := 'attribute21';
Line: 861

        l_rout_rec.p_col_to_update := 'attribute22';
Line: 864

        l_rout_rec.p_col_to_update := 'attribute23';
Line: 867

        l_rout_rec.p_col_to_update := 'attribute24';
Line: 870

        l_rout_rec.p_col_to_update := 'attribute25';
Line: 873

        l_rout_rec.p_col_to_update := 'attribute26';
Line: 876

        l_rout_rec.p_col_to_update := 'attribute27';
Line: 879

        l_rout_rec.p_col_to_update := 'attribute28';
Line: 882

        l_rout_rec.p_col_to_update := 'attribute29';
Line: 885

        l_rout_rec.p_col_to_update := 'attribute30';
Line: 888

        GMD_ROUTING_STEPS_PUB.update_routing_steps
        ( p_api_version => 1
        , p_init_msg_list => FALSE
        , p_commit	=> FALSE
        , p_routingstep_id => p_routing_obj.gmd_ebi_routing_steps(j).routingstep_id
        , p_routingstep_no => p_routing_obj.gmd_ebi_routing_steps(j).routingstep_no
        , p_routing_id 	=>  p_routing_obj.gmd_ebi_routing_steps(j).routing_id
        , p_routing_no =>   p_routing_obj.ROUTING_NO
        , p_routing_vers => p_routing_obj.ROUTING_vers
        , p_update_table => l_rout_tbl
        , x_message_count => l_msg_count
        , x_message_list => l_msg
        , x_return_status => l_ret_status
        );
Line: 905

        IF l_routings_step_dep_tbl_insert.Count > 1 THEN
          l_routings_step_dep_tbl_insert.DELETE;
Line: 908

        l_routings_step_dep_insert_ctr := 1;
Line: 931

            l_routings_step_dep_rec.LAST_UPDATED_BY :=Nvl( p_routing_obj.gmd_ebi_rtg_step_dependency(i).LAST_UPDATED_BY,FND_GLOBAL.USER_ID);
Line: 933

            l_routings_step_dep_rec.LAST_UPDATE_DATE := Nvl(p_routing_obj.gmd_ebi_rtg_step_dependency(i).LAST_UPDATE_DATE,SYSDATE);
Line: 935

            l_routings_step_dep_rec.LAST_UPDATE_LOGIN := Nvl(p_routing_obj.gmd_ebi_rtg_step_dependency(i).LAST_UPDATE_LOGIN,FND_GLOBAL.USER_ID);
Line: 937

            l_routings_step_dep_tbl_insert(l_routings_step_dep_insert_ctr) := l_routings_step_dep_rec;
Line: 938

            l_routings_step_dep_insert_ctr := l_routings_step_dep_insert_ctr + 1;
Line: 941

              l_rout_tbl.DELETE;
Line: 943

            l_rout_rec.p_col_to_update := 'ROUTINGSTEP_NO_UOM';
Line: 946

            l_rout_rec.p_col_to_update := 'CHARGEABLE_IND';
Line: 949

            l_rout_rec.p_col_to_update := 'ROUTINGSTEP_NO';
Line: 952

            l_rout_rec.p_col_to_update := 'DEP_ROUTINGSTEP_NO';
Line: 955

            l_rout_rec.p_col_to_update := 'ROUTING_ID';
Line: 958

            l_rout_rec.p_col_to_update := 'DEP_TYPE';
Line: 961

            l_rout_rec.p_col_to_update := 'REWORK_CODE';
Line: 964

            l_rout_rec.p_col_to_update := 'STANDARD_DELAY';
Line: 967

            l_rout_rec.p_col_to_update := 'MINIMUM_DELAY';
Line: 970

            l_rout_rec.p_col_to_update := 'MAX_DELAY';
Line: 973

            l_rout_rec.p_col_to_update := 'TRANSFER_QTY';
Line: 976

            l_rout_rec.p_col_to_update := 'ITEM_UM';
Line: 979

            l_rout_rec.p_col_to_update := 'TEXT_CODE';
Line: 982

            l_rout_rec.p_col_to_update := 'LAST_UPDATED_BY';
Line: 983

            l_rout_rec.p_value := p_routing_obj.gmd_ebi_rtg_step_dependency(i).LAST_UPDATED_BY;
Line: 985

            l_rout_rec.p_col_to_update := 'CREATED_BY';
Line: 988

            l_rout_rec.p_col_to_update := 'LAST_UPDATE_DATE';
Line: 989

            l_rout_rec.p_value := p_routing_obj.gmd_ebi_rtg_step_dependency(i).LAST_UPDATE_DATE;
Line: 991

            l_rout_rec.p_col_to_update := 'CREATION_DATE';
Line: 994

            l_rout_rec.p_col_to_update := 'LAST_UPDATE_LOGIN';
Line: 995

            l_rout_rec.p_value := p_routing_obj.gmd_ebi_rtg_step_dependency(i).LAST_UPDATE_LOGIN;
Line: 997

            l_rout_rec.p_col_to_update := 'TRANSFER_PCT';
Line: 1001

            GMD_ROUTING_STEPS_PUB.update_step_dependencies
              ( p_api_version     =>1
                , p_init_msg_list =>FALSE
                , p_commit		    => FALSE
                , p_dep_routingstep_no => p_routing_obj.gmd_ebi_rtg_step_dependency(i).DEP_ROUTINGSTEP_NO
                , p_routingstep_id => p_routing_obj.gmd_ebi_routing_steps(j).routingstep_id
                , p_routingstep_no => p_routing_obj.gmd_ebi_routing_steps(j).routingstep_no
                , p_routing_id 	=>  p_routing_obj.gmd_ebi_routing_steps(j).routing_id
                , p_routing_no =>   p_routing_obj.ROUTING_NO
                , p_routing_vers => p_routing_obj.ROUTING_vers
                , p_update_table =>l_rout_tbl
                , x_message_count =>l_msg_count
                , x_message_list 	=> l_msg
                , x_return_status	=> l_ret_status
              );
Line: 1021

        IF l_routings_step_dep_tbl_insert.Count > 1 THEN
          GMD_ROUTING_STEPS_PUB.insert_step_dependencies
          ( p_api_version => 1
          , p_init_msg_list => FALSE
          , p_commit	=> FALSE
          , p_routing_id 	=>  p_routing_obj.gmd_ebi_routing_steps(j).routing_id
          , p_routing_no =>   p_routing_obj.ROUTING_NO
          , p_routing_vers => p_routing_obj.ROUTING_vers
          , p_routingstep_id => p_routing_obj.gmd_ebi_routing_steps(j).routingstep_id
          , p_routingstep_no => p_routing_obj.gmd_ebi_routing_steps(j).routingstep_no
          , p_routings_step_dep_tbl => l_routings_step_dep_tbl_insert
          , x_message_count => l_msg_count
          , x_message_list => l_msg
          , x_return_status => l_ret_status
          );
Line: 1065

/*   The procedure creates/updates the attachment that denotes routing      */

/*   information.							    */

/* ======================================================================== */

PROCEDURE  add_attachment(
  p_recipe_obj      IN gmd_ebi_recipe_obj
  ,x_return_status  OUT NOCOPY      VARCHAR2
  ,x_msg_count      OUT NOCOPY      NUMBER
  ,x_msg_data       OUT NOCOPY      VARCHAR2
 )
 IS
 l_text LONG;
Line: 1110

  SELECT category_id INTO l_category_id FROM FND_DOCUMENT_CATEGORIES_tl  WHERE user_name='Formula Header Info';
Line: 1149

                  SELECT DISTINCT concatenated_segments,description INTO l_item_no,l_item_desc FROM mtl_system_items_kfv WHERE inventory_item_id = p_recipe_obj.formula_obj.formula_details(k).INVENTORY_ITEM_ID AND organization_id = l_org_id;
Line: 1157

                  SELECT DISTINCT concatenated_segments,description INTO l_item_no,l_item_desc FROM mtl_system_items_kfv WHERE inventory_item_id = p_recipe_obj.formula_obj.formula_details(k).INVENTORY_ITEM_ID AND organization_id = l_org_id;
Line: 1165

                  SELECT DISTINCT concatenated_segments,description INTO l_item_no,l_item_desc FROM mtl_system_items_kfv WHERE inventory_item_id = p_recipe_obj.formula_obj.formula_details(k).INVENTORY_ITEM_ID AND organization_id = l_org_id;
Line: 1182

     SELECT Max(formula_id) INTO l_formula_id FROM fm_form_mst_b WHERE formula_no=p_recipe_obj.formula_obj.formula_header.FORMULA_no;
Line: 1194

    FND_Documents_PKG.Insert_Row(X_Rowid => l_row_id1,
                                 X_document_id => l_document_id,
                                 X_creation_date => sysdate,
                                 X_created_by => FND_GLOBAL.USER_ID,
                                 X_last_update_date => sysdate,
                                 X_last_updated_by => FND_GLOBAL.USER_ID,
                                 X_datatype_id => l_datatype_id,
                                 X_category_id => l_category_id,
                                 X_security_type => l_security_tp,
                                 X_publish_flag => l_publish_flag,
                                 X_usage_type => l_usage_type,
                                 X_language => userenv('LANG'),
                                 X_description => l_description,
                                 X_file_name => null,
                                 X_media_id => l_media_id);
Line: 1209

     INSERT  INTO  fnd_documents_long_text(Media_id,long_text)  VALUES ( l_media_id,l_text);
Line: 1210

     SELECT  fnd_attached_documents_s.NEXTVAL
     INTO   l_att_doc_id
     FROM  dual;
Line: 1213

     FND_Attached_Documents_PKG.Insert_Row(X_Rowid => l_row_id2,
                                          X_attached_document_id => l_att_doc_id,
                                          X_document_id => l_document_id,
                                          X_creation_date => sysdate,
                                          X_created_by => FND_GLOBAL.USER_ID,
                                          X_last_update_date => sysdate,
                                          X_last_updated_by => FND_GLOBAL.USER_ID,
                                          X_seq_num => '10',
                                          X_entity_name => l_entity_name,
                                          X_column1 => NULL,
                                          X_pk1_value => l_formula_id,
                                          X_pk2_value => NULL,
                                          X_pk3_value => NULL,
                                          X_pk4_value => NULL,
                                          X_pk5_value => NULL,
                                          X_automatically_added_flag => l_aut_add_flag,
                                          X_datatype_id => l_datatype_id,
                                          X_category_id => l_category_id,
                                          X_security_type => l_security_tp,
                                          X_publish_flag => l_publish_flag,
                                          X_usage_type => l_usage_type,
                                          X_language => UserEnv('LANG'),
                                          X_description => l_description,
                                          X_file_name => null,
                                          X_media_id => l_media_id,
                                          X_doc_attribute_Category => NULL,
                                          X_doc_attribute1 => NULL,
                                          X_doc_attribute2 => NULL,
                                          X_doc_attribute3 => NULL,
                                          X_doc_attribute4 => NULL,
                                          X_doc_attribute5 => NULL,
                                          X_doc_attribute6 => NULL,
                                          X_doc_attribute7 => NULL,
                                          X_doc_attribute8 => NULL,
                                          X_doc_attribute9 => NULL,
                                          X_doc_attribute10 => NULL,
                                          X_doc_attribute11 => NULL,
                                          X_doc_attribute12 => NULL,
                                          X_doc_attribute13 => NULL,
                                          X_doc_attribute14 => NULL,
                                          X_doc_attribute15 => NULL);
Line: 1256

    SELECT * INTO l_attached_doc
    FROM FND_ATTACHED_DOCUMENTS
    WHERE ENTITY_NAME ='FM_FORM_MST_B' AND PK1_VALUE = l_formula_id;
Line: 1260

    SELECT * INTO l_doc
    FROM fnd_documents
    WHERE document_id = l_attached_doc.document_id;
Line: 1264

    SELECT DISTINCT row_id INTO l_row_id1 FROM FND_ATTACHED_DOCS_FORM_VL
    WHERE attached_document_id = l_attached_doc.attached_document_id;
Line: 1268

    FND_Attached_Documents_PKG.Update_Row(X_Rowid => l_row_id1
                                          ,X_attached_document_id  => l_attached_doc.attached_document_id
                                          ,X_document_id  =>l_attached_doc.document_id
                                          ,X_last_update_date => sysdate
                                         ,X_last_updated_by => FND_GLOBAL.USER_ID
                                         ,X_last_update_login => FND_GLOBAL.USER_ID
                                         ,X_seq_num =>  l_attached_doc.seq_num
                                         ,X_entity_name => l_attached_doc.entity_name
                                         ,X_column1 => l_attached_doc.column1
                                         ,X_pk1_value => l_attached_doc.pk1_value
                                         ,X_pk2_value => NULL
                                         ,X_pk3_value => NULL
                                         ,X_pk4_value => NULL
                                         ,X_pk5_value => NULL
                                         ,X_automatically_added_flag => l_attached_doc.automatically_added_flag
                                         ,X_request_id => l_attached_doc.request_id
                                         ,X_program_application_id => l_attached_doc.program_application_id
                                         ,X_program_id => l_attached_doc.program_id
                                         ,X_program_update_date => sysdate
                                         ,X_doc_attribute_Category => NULL
                                         ,X_doc_attribute1 => NULL
                                         ,X_doc_attribute2 => NULL
                                         ,X_doc_attribute3 => NULL
                                         ,X_doc_attribute4 => NULL
                                         ,X_doc_attribute5 => NULL
                                         ,X_doc_attribute6 => NULL
                                         ,X_doc_attribute7 => NULL
                                         ,X_doc_attribute8 => NULL
                                         ,X_doc_attribute9 => NULL
                                         ,X_doc_attribute10 => NULL
                                         ,X_doc_attribute11 => NULL
                                         ,X_doc_attribute12 => NULL
                                         ,X_doc_attribute13 => NULL
                                         ,X_doc_attribute14 => NULL
                                         ,X_doc_attribute15 => NULL
                                         ,X_datatype_id => l_doc.datatype_id
                                         ,X_category_id => l_doc.category_id
                                         ,X_security_type => l_doc.security_type
                                         ,X_publish_flag => l_doc.publish_flag
                                         ,X_usage_type => l_doc.usage_type
                                         ,X_language => userenv('LANG')
                                         ,X_image_type  =>null
                                         ,X_storage_type => null
                                         ,X_start_date_active => sysdate
                                         ,X_end_date_active  =>null
                                         ,X_description => l_description
                                         ,X_file_name   => null
                                         ,X_media_id    => l_doc.media_id
                                         ,X_url         => NULL
                                         ,X_title			  => 'ROUTING DETAILS'
                                         ,x_attribute_Category => NULL
                                         ,x_attribute1 => NULL
                                         ,x_attribute2 => NULL
                                         ,x_attribute3 => NULL
                                         ,x_attribute4 => NULL
                                         ,x_attribute5 => NULL
                                         ,x_attribute6 => NULL
                                         ,x_attribute7 => NULL
                                         ,x_attribute8 => NULL
                                         ,x_attribute9 => NULL
                                         ,x_attribute10 => NULL
                                         ,x_attribute11 => NULL
                                         ,x_attribute12 => NULL
                                         ,x_attribute13 => NULL
                                         ,x_attribute14 => NULL
                                         ,x_attribute15 => NULL
                                          );
Line: 1335

    UPDATE fnd_documents_long_text
    SET long_text = l_text
    WHERE media_id = l_doc.media_id;
Line: 1363

/*   Delete_FormulaDetail                                                   */

/*                                                                          */

/* DESCRIPTION:                                                             */

/*   The procedure deletes the formula details that have been removed       */

/*   from the formula.                                                      */

/* ======================================================================== */

PROCEDURE  Delete_FormulaDetail(
   p_formula_detail_tbl IN              GMD_FORMULA_DETAIL_PUB.formula_update_dtl_tbl_type
   ,x_line_delete_tbl   OUT NOCOPY      gmd_ebi_formula_line_del_tbl
   ,x_return_status     OUT NOCOPY      VARCHAR2
   ,x_msg_count         OUT NOCOPY      NUMBER
   ,x_msg_data          OUT NOCOPY      VARCHAR2
   )
IS

  l_line_delete_tbl gmd_ebi_formula_line_del_tbl := gmd_ebi_formula_line_del_tbl();
Line: 1385

  l_line_delete_obj gmd_ebi_formula_line_del_obj;
Line: 1386

  l_delete_ctr      NUMBER :=1;
Line: 1390

  l_formula_delete_detail_rec  GMD_FORMULA_COMMON_PUB.formula_update_rec_type;
Line: 1391

  l_formula_delete_detail_tbl  GMD_FORMULA_DETAIL_PUB.formula_update_dtl_tbl_type;
Line: 1397

  SELECT formula_id,formulaline_id FROM fm_matl_dtl WHERE formula_id = p_formula_detail_tbl(1).formula_id;
Line: 1408

       l_formula_delete_detail_rec.formula_id := formula_line.formula_id;
Line: 1409

       l_formula_delete_detail_rec.formulaline_id := formula_line.formulaline_id;
Line: 1410

       l_formula_delete_detail_rec.record_type := 'D';
Line: 1411

       l_formula_delete_detail_tbl(l_delete_ctr) := l_formula_delete_detail_rec;
Line: 1412

       l_line_delete_obj :=  gmd_ebi_formula_line_del_obj(formula_line.formulaline_id);
Line: 1413

       l_line_delete_tbl.extend();
Line: 1414

       l_line_delete_tbl(l_delete_ctr):= l_line_delete_obj;
Line: 1415

       l_delete_ctr := l_delete_ctr + 1;
Line: 1418

  IF l_formula_delete_detail_tbl.Count > 0 THEN
    GMD_FORMULA_DETAIL_PUB.Delete_FormulaDetail(p_api_version           => 1.1
                                      ,p_init_msg_list         => FND_API.G_FALSE
                                      ,p_commit                => FND_API.G_FALSE
                                      ,p_called_from_forms     => 'NO'
                                      ,x_return_status         => l_ret_status
                                      ,x_msg_count             => l_msg_count
                                      ,x_msg_data              => l_msg_data
                                      ,p_formula_detail_tbl    => l_formula_delete_detail_tbl);
Line: 1432

  x_line_delete_tbl  := l_line_delete_tbl;
Line: 1440

      x_msg_data := SQLERRM||' AT DELETE FORMULA LINES';
Line: 1448

/*   is_updateable                                                          */

/*                                                                          */

/* DESCRIPTION:                                                             */

/*   This function returns 'Y' or 'N' based on whether formula is           */

/*   version controlled or not.                                             */

/* ======================================================================== */

FUNCTION is_updateable(p_orgn_id IN NUMBER)
RETURN VARCHAR2
IS
 l_vers_cntrl VARCHAR2(1);
Line: 1493

,x_line_delete_tbl OUT NOCOPY      gmd_ebi_formula_line_del_tbl
,x_return_status  OUT NOCOPY      VARCHAR2
,x_msg_count      OUT NOCOPY      NUMBER
,x_msg_data       OUT NOCOPY      VARCHAR2
)
IS
  l_formula_insert_header_rec  GMD_FORMULA_COMMON_PUB.formula_insert_rec_type;
Line: 1500

  l_formula_insert_header_tbl  GMD_FORMULA_PUB.formula_insert_hdr_tbl_type;
Line: 1501

  l_formula_update_header_rec  GMD_FORMULA_COMMON_PUB.formula_update_rec_type;
Line: 1502

  l_formula_update_header_tbl  GMD_FORMULA_PUB.formula_update_hdr_tbl_type;
Line: 1503

  l_formula_insert_detail_rec  GMD_FORMULA_COMMON_PUB.formula_insert_rec_type;
Line: 1504

  l_formula_insert_detail_tbl  GMD_FORMULA_DETAIL_PUB.formula_insert_dtl_tbl_type;
Line: 1505

  l_formula_update_detail_rec  GMD_FORMULA_COMMON_PUB.formula_update_rec_type;
Line: 1506

  l_formula_update_detail_tbl  GMD_FORMULA_DETAIL_PUB.formula_update_dtl_tbl_type;
Line: 1507

  l_insert_detailctr           NUMBER := 1;
Line: 1508

  l_insert_headerctr           NUMBER := 1;
Line: 1509

  l_update_detailctr           NUMBER := 1;
Line: 1516

  l_update_header_flag         NUMBER;
Line: 1519

  l_line_delete_tbl gmd_ebi_formula_line_del_tbl;
Line: 1528

       SELECT user_id INTO l_formula_owner_id FROM fnd_user WHERE user_name = l_formula_owner_name;
Line: 1537

             SELECT Max(formula_vers)+1 INTO l_form_version FROM fm_form_mst_b WHERE formula_no = p_formula_obj.formula_header.formula_no;
Line: 1541

             l_formula_insert_header_rec.formula_id              := p_formula_obj.formula_header.formula_id;
Line: 1542

             l_formula_insert_header_rec.formula_no              := p_formula_obj.formula_header.formula_no;
Line: 1543

             l_formula_insert_header_rec.formula_vers            := l_form_version;
Line: 1544

             l_formula_insert_header_rec.formula_type            := l_form_type;
Line: 1545

	     l_formula_insert_header_rec.master_formula_id       := p_formula_obj.formula_header.master_formula_id;
Line: 1546

             l_formula_insert_header_rec.scale_type_hdr          := p_formula_obj.formula_header.scale_type_hdr;
Line: 1547

             l_formula_insert_header_rec.formula_desc1           := p_formula_obj.formula_header.formula_desc1;
Line: 1548

             l_formula_insert_header_rec.formula_desc2           := p_formula_obj.formula_header.formula_desc2;
Line: 1549

             l_formula_insert_header_rec.formula_class           := p_formula_obj.formula_header.formula_class;
Line: 1550

             l_formula_insert_header_rec.fmcontrol_class         := p_formula_obj.formula_header.fmcontrol_class;
Line: 1551

             l_formula_insert_header_rec.inactive_ind            := Nvl(p_formula_obj.formula_header.inactive_ind,0);
Line: 1552

             l_formula_insert_header_rec.owner_organization_id   := p_formula_obj.formula_header.owner_organization_id;
Line: 1553

             l_formula_insert_header_rec.total_input_qty         := p_formula_obj.formula_header.total_input_qty ;
Line: 1554

             l_formula_insert_header_rec.total_output_qty        := p_formula_obj.formula_header.total_output_qty  ;
Line: 1555

             l_formula_insert_header_rec.yield_uom               := p_formula_obj.formula_header.yield_uom;
Line: 1556

             l_formula_insert_header_rec.formula_status          := p_formula_obj.formula_header.formula_status ;
Line: 1557

             l_formula_insert_header_rec.owner_id                := l_formula_owner_id;
Line: 1558

             l_formula_insert_header_rec.attribute1              := p_formula_obj.formula_header.attribute1;
Line: 1559

             l_formula_insert_header_rec.attribute2              := p_formula_obj.formula_header.attribute2;
Line: 1560

             l_formula_insert_header_rec.attribute3              := p_formula_obj.formula_header.attribute3;
Line: 1561

             l_formula_insert_header_rec.attribute4              := p_formula_obj.formula_header.attribute4;
Line: 1562

             l_formula_insert_header_rec.attribute5              := p_formula_obj.formula_header.attribute5;
Line: 1563

             l_formula_insert_header_rec.attribute6              := p_formula_obj.formula_header.attribute6;
Line: 1564

             l_formula_insert_header_rec.attribute7              := p_formula_obj.formula_header.attribute7;
Line: 1565

             l_formula_insert_header_rec.attribute8              := p_formula_obj.formula_header.attribute8;
Line: 1566

             l_formula_insert_header_rec.attribute9              := p_formula_obj.formula_header.attribute9;
Line: 1567

             l_formula_insert_header_rec.attribute10             := p_formula_obj.formula_header.attribute10;
Line: 1568

             l_formula_insert_header_rec.attribute11             := p_formula_obj.formula_header.attribute11;
Line: 1569

             l_formula_insert_header_rec.attribute12             := p_formula_obj.formula_header.attribute12;
Line: 1570

             l_formula_insert_header_rec.attribute13             := p_formula_obj.formula_header.attribute13;
Line: 1571

             l_formula_insert_header_rec.attribute14             := p_formula_obj.formula_header.attribute14;
Line: 1572

             l_formula_insert_header_rec.attribute15             := p_formula_obj.formula_header.attribute15;
Line: 1573

             l_formula_insert_header_rec.attribute16             := p_formula_obj.formula_header.attribute16;
Line: 1574

             l_formula_insert_header_rec.attribute17             := p_formula_obj.formula_header.attribute17;
Line: 1575

             l_formula_insert_header_rec.attribute18             := p_formula_obj.formula_header.attribute18;
Line: 1576

             l_formula_insert_header_rec.attribute19             := p_formula_obj.formula_header.attribute19;
Line: 1577

             l_formula_insert_header_rec.attribute20             := p_formula_obj.formula_header.attribute20;
Line: 1578

             l_formula_insert_header_rec.attribute21             := p_formula_obj.formula_header.attribute21;
Line: 1579

             l_formula_insert_header_rec.attribute22             := p_formula_obj.formula_header.attribute22;
Line: 1580

             l_formula_insert_header_rec.attribute23             := p_formula_obj.formula_header.attribute23;
Line: 1581

             l_formula_insert_header_rec.attribute24             := p_formula_obj.formula_header.attribute24;
Line: 1582

             l_formula_insert_header_rec.attribute25             := p_formula_obj.formula_header.attribute25;
Line: 1583

             l_formula_insert_header_rec.attribute26             := p_formula_obj.formula_header.attribute26;
Line: 1584

             l_formula_insert_header_rec.attribute27             := p_formula_obj.formula_header.attribute27;
Line: 1585

             l_formula_insert_header_rec.attribute28             := p_formula_obj.formula_header.attribute28;
Line: 1586

             l_formula_insert_header_rec.attribute29             := p_formula_obj.formula_header.attribute29;
Line: 1587

             l_formula_insert_header_rec.attribute30             := p_formula_obj.formula_header.attribute30;
Line: 1588

             l_formula_insert_header_rec.attribute_category      := p_formula_obj.formula_header.attribute_category;
Line: 1589

             l_formula_insert_header_rec.text_code_hdr           := p_formula_obj.formula_header.text_code_hdr;
Line: 1590

             l_formula_insert_header_rec.delete_mark             := NVL(p_formula_obj.formula_header.delete_mark,0);
Line: 1591

             l_formula_insert_header_rec.created_by              := FND_GLOBAL.USER_ID;
Line: 1592

             l_formula_insert_header_rec.creation_date           := NVL(p_formula_obj.formula_header.creation_date, SYSDATE);
Line: 1593

             l_formula_insert_header_rec.last_update_date        := NVL(p_formula_obj.formula_header.last_update_date, SYSDATE);
Line: 1594

             l_formula_insert_header_rec.last_update_login       := NVL(p_formula_obj.formula_header.last_update_login, FND_GLOBAL.USER_ID);
Line: 1595

             l_formula_insert_header_rec.last_updated_by         := FND_GLOBAL.USER_ID;
Line: 1596

             l_formula_insert_header_rec.formulaline_id          := p_formula_obj.formula_details(j).formulaline_id;
Line: 1597

             l_formula_insert_header_rec.line_type               := p_formula_obj.formula_details(j).line_type;
Line: 1598

             l_formula_insert_header_rec.line_no                 := p_formula_obj.formula_details(j).line_no;
Line: 1599

             l_formula_insert_header_rec.inventory_item_id       := p_formula_obj.formula_details(j).inventory_item_id;
Line: 1600

             l_formula_insert_header_rec.revision	               := p_formula_obj.formula_details(j).revision;
Line: 1601

             l_formula_insert_header_rec.qty                     := p_formula_obj.formula_details(j).qty;
Line: 1602

             l_formula_insert_header_rec.detail_uom              := p_formula_obj.formula_details(j).detail_uom;
Line: 1603

             l_formula_insert_header_rec.release_type            := p_formula_obj.formula_details(j).release_type;
Line: 1604

             l_formula_insert_header_rec.scrap_factor            := p_formula_obj.formula_details(j).scrap_factor;
Line: 1605

             l_formula_insert_header_rec.scale_type_dtl          := p_formula_obj.formula_details(j).scale_type_dtl;
Line: 1606

             l_formula_insert_header_rec.cost_alloc              := p_formula_obj.formula_details(j).cost_alloc;
Line: 1607

             l_formula_insert_header_rec.phantom_type            := p_formula_obj.formula_details(j).phantom_type;
Line: 1608

             l_formula_insert_header_rec.buffer_ind              := p_formula_obj.formula_details(j).buffer_ind;
Line: 1609

             l_formula_insert_header_rec.tpformula_id            := p_formula_obj.formula_details(j).tpformula_id;
Line: 1610

             l_formula_insert_header_rec.iaformula_id            := p_formula_obj.formula_details(j).iaformula_id;
Line: 1611

             l_formula_insert_header_rec.scale_multiple          := p_formula_obj.formula_details(j).scale_multiple;
Line: 1612

             l_formula_insert_header_rec.contribute_yield_ind    := p_formula_obj.formula_details(j).contribute_yield_ind;
Line: 1613

             l_formula_insert_header_rec.scale_uom               := p_formula_obj.formula_details(j).scale_uom;
Line: 1614

             l_formula_insert_header_rec.contribute_step_qty_ind := p_formula_obj.formula_details(j).contribute_step_qty_ind;
Line: 1615

             l_formula_insert_header_rec.scale_rounding_variance := p_formula_obj.formula_details(j).scale_rounding_variance;
Line: 1616

             l_formula_insert_header_rec.rounding_direction      := p_formula_obj.formula_details(j).rounding_direction;
Line: 1617

             l_formula_insert_header_rec.by_product_type         := p_formula_obj.formula_details(j).by_product_type;
Line: 1618

             l_formula_insert_header_rec.ingredient_end_date     := p_formula_obj.formula_details(j).ingredient_end_date;
Line: 1619

             l_formula_insert_header_rec.text_code_dtl           := p_formula_obj.formula_details(j).text_code_dtl;
Line: 1620

             l_formula_insert_header_rec.dtl_attribute_category  := p_formula_obj.formula_details(j).dtl_attribute_category;
Line: 1621

             l_formula_insert_header_rec.dtl_attribute1          := p_formula_obj.formula_details(j).dtl_attribute1;
Line: 1622

             l_formula_insert_header_rec.dtl_attribute2          := p_formula_obj.formula_details(j).dtl_attribute2;
Line: 1623

             l_formula_insert_header_rec.dtl_attribute3          := p_formula_obj.formula_details(j).dtl_attribute3;
Line: 1624

             l_formula_insert_header_rec.dtl_attribute4          := p_formula_obj.formula_details(j).dtl_attribute4;
Line: 1625

             l_formula_insert_header_rec.dtl_attribute5          := p_formula_obj.formula_details(j).dtl_attribute5;
Line: 1626

             l_formula_insert_header_rec.dtl_attribute6          := p_formula_obj.formula_details(j).dtl_attribute6;
Line: 1627

             l_formula_insert_header_rec.dtl_attribute7          := p_formula_obj.formula_details(j).dtl_attribute7;
Line: 1628

             l_formula_insert_header_rec.dtl_attribute8          := p_formula_obj.formula_details(j).dtl_attribute8;
Line: 1629

             l_formula_insert_header_rec.dtl_attribute9          := p_formula_obj.formula_details(j).dtl_attribute9;
Line: 1630

             l_formula_insert_header_rec.dtl_attribute10         := p_formula_obj.formula_details(j).dtl_attribute10;
Line: 1631

             l_formula_insert_header_rec.dtl_attribute11         := p_formula_obj.formula_details(j).dtl_attribute11;
Line: 1632

             l_formula_insert_header_rec.dtl_attribute12         := p_formula_obj.formula_details(j).dtl_attribute12;
Line: 1633

             l_formula_insert_header_rec.dtl_attribute13         := p_formula_obj.formula_details(j).dtl_attribute13;
Line: 1634

             l_formula_insert_header_rec.dtl_attribute14         := p_formula_obj.formula_details(j).dtl_attribute14;
Line: 1635

             l_formula_insert_header_rec.dtl_attribute15         := p_formula_obj.formula_details(j).dtl_attribute15;
Line: 1636

             l_formula_insert_header_rec.dtl_attribute16         := p_formula_obj.formula_details(j).dtl_attribute16;
Line: 1637

             l_formula_insert_header_rec.dtl_attribute17         := p_formula_obj.formula_details(j).dtl_attribute17;
Line: 1638

             l_formula_insert_header_rec.dtl_attribute18         := p_formula_obj.formula_details(j).dtl_attribute18;
Line: 1639

             l_formula_insert_header_rec.dtl_attribute19         := p_formula_obj.formula_details(j).dtl_attribute19;
Line: 1640

             l_formula_insert_header_rec.dtl_attribute20         := p_formula_obj.formula_details(j).dtl_attribute20;
Line: 1641

             l_formula_insert_header_rec.dtl_attribute21         := p_formula_obj.formula_details(j).dtl_attribute21;
Line: 1642

             l_formula_insert_header_rec.dtl_attribute22         := p_formula_obj.formula_details(j).dtl_attribute22;
Line: 1643

             l_formula_insert_header_rec.dtl_attribute23         := p_formula_obj.formula_details(j).dtl_attribute23;
Line: 1644

             l_formula_insert_header_rec.dtl_attribute24         := p_formula_obj.formula_details(j).dtl_attribute24;
Line: 1645

             l_formula_insert_header_rec.dtl_attribute25         := p_formula_obj.formula_details(j).dtl_attribute25;
Line: 1646

             l_formula_insert_header_rec.dtl_attribute26         := p_formula_obj.formula_details(j).dtl_attribute26;
Line: 1647

             l_formula_insert_header_rec.dtl_attribute27         := p_formula_obj.formula_details(j).dtl_attribute27;
Line: 1648

             l_formula_insert_header_rec.dtl_attribute28         := p_formula_obj.formula_details(j).dtl_attribute28;
Line: 1649

             l_formula_insert_header_rec.dtl_attribute29         := p_formula_obj.formula_details(j).dtl_attribute29;
Line: 1650

             l_formula_insert_header_rec.dtl_attribute30         := p_formula_obj.formula_details(j).dtl_attribute30;
Line: 1651

             l_formula_insert_header_tbl(l_insert_headerctr) := l_formula_insert_header_rec;
Line: 1652

             l_insert_headerctr := l_insert_headerctr + 1;
Line: 1654

          IF l_formula_update_header_tbl.Count = 0 THEN
             IF(is_updateable( p_formula_obj.formula_header.owner_organization_id)=FND_API.G_FALSE)THEN
                FND_MESSAGE.set_name('GMD','GMD_EBI_VERSION_ERROR');
Line: 1661

             l_formula_update_header_rec.formula_id        := p_formula_obj.formula_header.formula_id;
Line: 1662

             l_formula_update_header_rec.formula_no        := p_formula_obj.formula_header.formula_no;
Line: 1663

             l_formula_update_header_rec.formula_type      := l_form_type;
Line: 1664

	     l_formula_update_header_rec.scale_type_hdr    := p_formula_obj.formula_header.scale_type_hdr;
Line: 1665

             l_formula_update_header_rec.formula_desc1     := p_formula_obj.formula_header.formula_desc1;
Line: 1666

             l_formula_update_header_rec.formula_desc2     := p_formula_obj.formula_header.formula_desc2;
Line: 1667

             l_formula_update_header_rec.formula_class     := p_formula_obj.formula_header.formula_class;
Line: 1668

             l_formula_update_header_rec.fmcontrol_class   := p_formula_obj.formula_header.fmcontrol_class;
Line: 1669

             l_formula_update_header_rec.inactive_ind      := Nvl(p_formula_obj.formula_header.inactive_ind,0);
Line: 1670

             l_formula_update_header_rec.owner_organization_id := p_formula_obj.formula_header.owner_organization_id;
Line: 1671

             l_formula_update_header_rec.total_input_qty   := p_formula_obj.formula_header.total_input_qty ;
Line: 1672

             l_formula_update_header_rec.total_output_qty  := p_formula_obj.formula_header.total_output_qty  ;
Line: 1673

             l_formula_update_header_rec.yield_uom         := p_formula_obj.formula_header.yield_uom;
Line: 1675

               l_formula_update_header_rec.formula_status    := p_formula_obj.formula_header.formula_status;
Line: 1677

               l_formula_update_header_rec.formula_status    := NULL;
Line: 1679

             l_formula_update_header_rec.owner_id          := l_formula_owner_id;
Line: 1680

             l_formula_update_header_rec.attribute1        := p_formula_obj.formula_header.attribute1;
Line: 1681

             l_formula_update_header_rec.attribute2        := p_formula_obj.formula_header.attribute2;
Line: 1682

             l_formula_update_header_rec.attribute3        := p_formula_obj.formula_header.attribute3;
Line: 1683

             l_formula_update_header_rec.attribute4        := p_formula_obj.formula_header.attribute4;
Line: 1684

             l_formula_update_header_rec.attribute5        := p_formula_obj.formula_header.attribute5;
Line: 1685

             l_formula_update_header_rec.attribute6        := p_formula_obj.formula_header.attribute6;
Line: 1686

             l_formula_update_header_rec.attribute7        := p_formula_obj.formula_header.attribute7;
Line: 1687

             l_formula_update_header_rec.attribute8        := p_formula_obj.formula_header.attribute8;
Line: 1688

             l_formula_update_header_rec.attribute9        := p_formula_obj.formula_header.attribute9;
Line: 1689

             l_formula_update_header_rec.attribute10       := p_formula_obj.formula_header.attribute10;
Line: 1690

             l_formula_update_header_rec.attribute11       := p_formula_obj.formula_header.attribute11;
Line: 1691

             l_formula_update_header_rec.attribute12       := p_formula_obj.formula_header.attribute12;
Line: 1692

             l_formula_update_header_rec.attribute13       := p_formula_obj.formula_header.attribute13;
Line: 1693

             l_formula_update_header_rec.attribute14       := p_formula_obj.formula_header.attribute14;
Line: 1694

             l_formula_update_header_rec.attribute15       := p_formula_obj.formula_header.attribute15;
Line: 1695

             l_formula_update_header_rec.attribute16       := p_formula_obj.formula_header.attribute16;
Line: 1696

             l_formula_update_header_rec.attribute17       := p_formula_obj.formula_header.attribute17;
Line: 1697

             l_formula_update_header_rec.attribute18       := p_formula_obj.formula_header.attribute18;
Line: 1698

             l_formula_update_header_rec.attribute19       := p_formula_obj.formula_header.attribute19;
Line: 1699

             l_formula_update_header_rec.attribute20       := p_formula_obj.formula_header.attribute20;
Line: 1700

             l_formula_update_header_rec.attribute21       := p_formula_obj.formula_header.attribute21;
Line: 1701

             l_formula_update_header_rec.attribute22       := p_formula_obj.formula_header.attribute22;
Line: 1702

             l_formula_update_header_rec.attribute23       := p_formula_obj.formula_header.attribute23;
Line: 1703

             l_formula_update_header_rec.attribute24       := p_formula_obj.formula_header.attribute24;
Line: 1704

             l_formula_update_header_rec.attribute25       := p_formula_obj.formula_header.attribute25;
Line: 1705

             l_formula_update_header_rec.attribute26       := p_formula_obj.formula_header.attribute26;
Line: 1706

             l_formula_update_header_rec.attribute27       := p_formula_obj.formula_header.attribute27;
Line: 1707

             l_formula_update_header_rec.attribute28       := p_formula_obj.formula_header.attribute28;
Line: 1708

             l_formula_update_header_rec.attribute29       := p_formula_obj.formula_header.attribute29;
Line: 1709

             l_formula_update_header_rec.attribute30       := p_formula_obj.formula_header.attribute30;
Line: 1710

             l_formula_update_header_rec.attribute_category:= p_formula_obj.formula_header.attribute_category;
Line: 1711

             l_formula_update_header_rec.text_code_hdr     := p_formula_obj.formula_header.text_code_hdr;
Line: 1712

             l_formula_update_header_rec.delete_mark       := NVL(p_formula_obj.formula_header.delete_mark,0);
Line: 1713

             l_formula_update_header_rec.created_by        := FND_GLOBAL.USER_ID;
Line: 1714

             l_formula_update_header_rec.creation_date     := NVL(p_formula_obj.formula_header.creation_date, SYSDATE);
Line: 1715

             l_formula_update_header_rec.last_update_date  := NVL(p_formula_obj.formula_header.last_update_date, SYSDATE);
Line: 1716

             l_formula_update_header_rec.last_update_login := NVL(p_formula_obj.formula_header.last_update_login, FND_GLOBAL.USER_ID);
Line: 1717

             l_formula_update_header_rec.last_updated_by   := FND_GLOBAL.USER_ID;
Line: 1718

	     l_formula_update_header_tbl(1) := l_formula_update_header_rec;
Line: 1721

               l_formula_insert_detail_rec.formula_id              := p_formula_obj.formula_details(j).formula_id;
Line: 1722

               l_formula_insert_detail_rec.formulaline_id          := p_formula_obj.formula_details(j).formulaline_id;
Line: 1723

               l_formula_insert_detail_rec.line_type               := p_formula_obj.formula_details(j).line_type;
Line: 1724

               l_formula_insert_detail_rec.line_no                 := p_formula_obj.formula_details(j).line_no;
Line: 1725

               l_formula_insert_detail_rec.inventory_item_id       := p_formula_obj.formula_details(j).inventory_item_id;
Line: 1726

	       l_formula_insert_detail_rec.revision    	           := p_formula_obj.formula_details(j).revision;
Line: 1727

               l_formula_insert_detail_rec.qty                     := p_formula_obj.formula_details(j).qty;
Line: 1728

               l_formula_insert_detail_rec.detail_uom              := p_formula_obj.formula_details(j).detail_uom;
Line: 1729

               l_formula_insert_detail_rec.release_type            := p_formula_obj.formula_details(j).release_type;
Line: 1730

               l_formula_insert_detail_rec.scrap_factor            := p_formula_obj.formula_details(j).scrap_factor;
Line: 1731

               l_formula_insert_detail_rec.scale_type_dtl          := p_formula_obj.formula_details(j).scale_type_dtl;
Line: 1732

               l_formula_insert_detail_rec.cost_alloc              := p_formula_obj.formula_details(j).cost_alloc;
Line: 1733

               l_formula_insert_detail_rec.phantom_type            := p_formula_obj.formula_details(j).phantom_type;
Line: 1734

               l_formula_insert_detail_rec.buffer_ind              := p_formula_obj.formula_details(j).buffer_ind;
Line: 1735

               l_formula_insert_detail_rec.tpformula_id            := p_formula_obj.formula_details(j).tpformula_id;
Line: 1736

               l_formula_insert_detail_rec.iaformula_id            := p_formula_obj.formula_details(j).iaformula_id;
Line: 1737

               l_formula_insert_detail_rec.scale_multiple          := p_formula_obj.formula_details(j).scale_multiple;
Line: 1738

               l_formula_insert_detail_rec.contribute_yield_ind    := p_formula_obj.formula_details(j).contribute_yield_ind;
Line: 1739

               l_formula_insert_detail_rec.scale_uom               := p_formula_obj.formula_details(j).scale_uom;
Line: 1740

               l_formula_insert_detail_rec.contribute_step_qty_ind := p_formula_obj.formula_details(j).contribute_step_qty_ind;
Line: 1741

               l_formula_insert_detail_rec.scale_rounding_variance := p_formula_obj.formula_details(j).scale_rounding_variance;
Line: 1742

               l_formula_insert_detail_rec.rounding_direction      := p_formula_obj.formula_details(j).rounding_direction;
Line: 1743

               l_formula_insert_detail_rec.by_product_type         := p_formula_obj.formula_details(j).by_product_type;
Line: 1744

               l_formula_insert_detail_rec.ingredient_end_date     := p_formula_obj.formula_details(j).ingredient_end_date;
Line: 1745

               l_formula_insert_detail_rec.text_code_dtl           := p_formula_obj.formula_details(j).text_code_dtl;
Line: 1746

               l_formula_insert_detail_rec.dtl_attribute_category  := p_formula_obj.formula_details(j).dtl_attribute_category;
Line: 1747

               l_formula_insert_detail_rec.dtl_attribute1          := p_formula_obj.formula_details(j).dtl_attribute1;
Line: 1748

               l_formula_insert_detail_rec.dtl_attribute2          := p_formula_obj.formula_details(j).dtl_attribute2;
Line: 1749

               l_formula_insert_detail_rec.dtl_attribute3          := p_formula_obj.formula_details(j).dtl_attribute3;
Line: 1750

               l_formula_insert_detail_rec.dtl_attribute4          := p_formula_obj.formula_details(j).dtl_attribute4;
Line: 1751

               l_formula_insert_detail_rec.dtl_attribute5          := p_formula_obj.formula_details(j).dtl_attribute5;
Line: 1752

               l_formula_insert_detail_rec.dtl_attribute6          := p_formula_obj.formula_details(j).dtl_attribute6;
Line: 1753

               l_formula_insert_detail_rec.dtl_attribute7          := p_formula_obj.formula_details(j).dtl_attribute7;
Line: 1754

               l_formula_insert_detail_rec.dtl_attribute8          := p_formula_obj.formula_details(j).dtl_attribute8;
Line: 1755

               l_formula_insert_detail_rec.dtl_attribute9          := p_formula_obj.formula_details(j).dtl_attribute9;
Line: 1756

               l_formula_insert_detail_rec.dtl_attribute10         := p_formula_obj.formula_details(j).dtl_attribute10;
Line: 1757

               l_formula_insert_detail_rec.dtl_attribute11         := p_formula_obj.formula_details(j).dtl_attribute11;
Line: 1758

               l_formula_insert_detail_rec.dtl_attribute12         := p_formula_obj.formula_details(j).dtl_attribute12;
Line: 1759

               l_formula_insert_detail_rec.dtl_attribute13         := p_formula_obj.formula_details(j).dtl_attribute13;
Line: 1760

               l_formula_insert_detail_rec.dtl_attribute14         := p_formula_obj.formula_details(j).dtl_attribute14;
Line: 1761

               l_formula_insert_detail_rec.dtl_attribute15         := p_formula_obj.formula_details(j).dtl_attribute15;
Line: 1762

               l_formula_insert_detail_rec.dtl_attribute16         := p_formula_obj.formula_details(j).dtl_attribute16;
Line: 1763

               l_formula_insert_detail_rec.dtl_attribute17         := p_formula_obj.formula_details(j).dtl_attribute17;
Line: 1764

               l_formula_insert_detail_rec.dtl_attribute18         := p_formula_obj.formula_details(j).dtl_attribute18;
Line: 1765

               l_formula_insert_detail_rec.dtl_attribute19         := p_formula_obj.formula_details(j).dtl_attribute19;
Line: 1766

               l_formula_insert_detail_rec.dtl_attribute20         := p_formula_obj.formula_details(j).dtl_attribute20;
Line: 1767

               l_formula_insert_detail_rec.dtl_attribute21         := p_formula_obj.formula_details(j).dtl_attribute21;
Line: 1768

               l_formula_insert_detail_rec.dtl_attribute22         := p_formula_obj.formula_details(j).dtl_attribute22;
Line: 1769

               l_formula_insert_detail_rec.dtl_attribute23         := p_formula_obj.formula_details(j).dtl_attribute23;
Line: 1770

               l_formula_insert_detail_rec.dtl_attribute24         := p_formula_obj.formula_details(j).dtl_attribute24;
Line: 1771

               l_formula_insert_detail_rec.dtl_attribute25         := p_formula_obj.formula_details(j).dtl_attribute25;
Line: 1772

               l_formula_insert_detail_rec.dtl_attribute26         := p_formula_obj.formula_details(j).dtl_attribute26;
Line: 1773

               l_formula_insert_detail_rec.dtl_attribute27         := p_formula_obj.formula_details(j).dtl_attribute27;
Line: 1774

               l_formula_insert_detail_rec.dtl_attribute28         := p_formula_obj.formula_details(j).dtl_attribute28;
Line: 1775

               l_formula_insert_detail_rec.dtl_attribute29         := p_formula_obj.formula_details(j).dtl_attribute29;
Line: 1776

               l_formula_insert_detail_rec.dtl_attribute30         := p_formula_obj.formula_details(j).dtl_attribute30;
Line: 1778

	       l_formula_insert_detail_tbl(l_insert_detailctr) :=  l_formula_insert_detail_rec;
Line: 1779

               l_insert_detailctr := l_insert_detailctr + 1;
Line: 1781

               l_formula_update_detail_rec.formula_id              := p_formula_obj.formula_details(j).formula_id;
Line: 1782

	       l_formula_update_detail_rec.formulaline_id          := p_formula_obj.formula_details(j).formulaline_id;
Line: 1783

      	       l_formula_update_detail_rec.owner_organization_id   := p_formula_obj.formula_details(j).owner_organization_id;
Line: 1784

               l_formula_update_detail_rec.line_type               := p_formula_obj.formula_details(j).line_type;
Line: 1785

               l_formula_update_detail_rec.line_no                 := NULL;
Line: 1786

               l_formula_update_detail_rec.inventory_item_id       := p_formula_obj.formula_details(j).inventory_item_id;
Line: 1787

	       l_formula_update_detail_rec.revision	               := p_formula_obj.formula_details(j).revision;
Line: 1788

               l_formula_update_detail_rec.qty                     := p_formula_obj.formula_details(j).qty;
Line: 1789

               l_formula_update_detail_rec.detail_uom              := p_formula_obj.formula_details(j).detail_uom;
Line: 1790

               l_formula_update_detail_rec.release_type            := p_formula_obj.formula_details(j).release_type;
Line: 1791

               l_formula_update_detail_rec.scrap_factor            := p_formula_obj.formula_details(j).scrap_factor;
Line: 1792

               l_formula_update_detail_rec.scale_type_dtl          := p_formula_obj.formula_details(j).scale_type_dtl;
Line: 1793

               l_formula_update_detail_rec.cost_alloc              := p_formula_obj.formula_details(j).cost_alloc;
Line: 1794

               l_formula_update_detail_rec.phantom_type            := p_formula_obj.formula_details(j).phantom_type;
Line: 1795

               l_formula_update_detail_rec.buffer_ind              := p_formula_obj.formula_details(j).buffer_ind;
Line: 1796

               l_formula_update_detail_rec.tpformula_id            := p_formula_obj.formula_details(j).tpformula_id;
Line: 1797

               l_formula_update_detail_rec.iaformula_id            := p_formula_obj.formula_details(j).iaformula_id;
Line: 1798

               l_formula_update_detail_rec.scale_multiple          := p_formula_obj.formula_details(j).scale_multiple;
Line: 1799

               l_formula_update_detail_rec.contribute_yield_ind    := p_formula_obj.formula_details(j).contribute_yield_ind;
Line: 1800

               l_formula_update_detail_rec.scale_uom               := p_formula_obj.formula_details(j).scale_uom;
Line: 1801

               l_formula_update_detail_rec.contribute_step_qty_ind := p_formula_obj.formula_details(j).contribute_step_qty_ind;
Line: 1802

               l_formula_update_detail_rec.scale_rounding_variance := p_formula_obj.formula_details(j).scale_rounding_variance;
Line: 1803

               l_formula_update_detail_rec.rounding_direction      := p_formula_obj.formula_details(j).rounding_direction;
Line: 1804

               l_formula_update_detail_rec.by_product_type         := p_formula_obj.formula_details(j).by_product_type;
Line: 1805

               l_formula_update_detail_rec.ingredient_end_date     := p_formula_obj.formula_details(j).ingredient_end_date;
Line: 1806

               l_formula_update_detail_rec.text_code_dtl           := p_formula_obj.formula_details(j).text_code_dtl;
Line: 1807

               l_formula_update_detail_rec.attribute_category      := p_formula_obj.formula_details(j).dtl_attribute_category;
Line: 1808

               l_formula_update_detail_rec.attribute1              := p_formula_obj.formula_details(j).dtl_attribute1;
Line: 1809

               l_formula_update_detail_rec.attribute2              := p_formula_obj.formula_details(j).dtl_attribute2;
Line: 1810

               l_formula_update_detail_rec.attribute3              := p_formula_obj.formula_details(j).dtl_attribute3;
Line: 1811

               l_formula_update_detail_rec.attribute4              := p_formula_obj.formula_details(j).dtl_attribute4;
Line: 1812

               l_formula_update_detail_rec.attribute5              := p_formula_obj.formula_details(j).dtl_attribute5;
Line: 1813

               l_formula_update_detail_rec.attribute6              := p_formula_obj.formula_details(j).dtl_attribute6;
Line: 1814

               l_formula_update_detail_rec.attribute7              := p_formula_obj.formula_details(j).dtl_attribute7;
Line: 1815

               l_formula_update_detail_rec.attribute8              := p_formula_obj.formula_details(j).dtl_attribute8;
Line: 1816

               l_formula_update_detail_rec.attribute9              := p_formula_obj.formula_details(j).dtl_attribute9;
Line: 1817

               l_formula_update_detail_rec.attribute10             := p_formula_obj.formula_details(j).dtl_attribute10;
Line: 1818

               l_formula_update_detail_rec.attribute11             := p_formula_obj.formula_details(j).dtl_attribute11;
Line: 1819

               l_formula_update_detail_rec.attribute12             := p_formula_obj.formula_details(j).dtl_attribute12;
Line: 1820

               l_formula_update_detail_rec.attribute13             := p_formula_obj.formula_details(j).dtl_attribute13;
Line: 1821

               l_formula_update_detail_rec.attribute14             := p_formula_obj.formula_details(j).dtl_attribute14;
Line: 1822

               l_formula_update_detail_rec.attribute15             := p_formula_obj.formula_details(j).dtl_attribute15;
Line: 1823

               l_formula_update_detail_rec.attribute16             := p_formula_obj.formula_details(j).dtl_attribute16;
Line: 1824

               l_formula_update_detail_rec.attribute17             := p_formula_obj.formula_details(j).dtl_attribute17;
Line: 1825

               l_formula_update_detail_rec.attribute18             := p_formula_obj.formula_details(j).dtl_attribute18;
Line: 1826

               l_formula_update_detail_rec.attribute19             := p_formula_obj.formula_details(j).dtl_attribute19;
Line: 1827

               l_formula_update_detail_rec.attribute20             := p_formula_obj.formula_details(j).dtl_attribute20;
Line: 1828

               l_formula_update_detail_rec.attribute21             := p_formula_obj.formula_details(j).dtl_attribute21;
Line: 1829

               l_formula_update_detail_rec.attribute22             := p_formula_obj.formula_details(j).dtl_attribute22;
Line: 1830

               l_formula_update_detail_rec.attribute23             := p_formula_obj.formula_details(j).dtl_attribute23;
Line: 1831

               l_formula_update_detail_rec.attribute24             := p_formula_obj.formula_details(j).dtl_attribute24;
Line: 1832

               l_formula_update_detail_rec.attribute25             := p_formula_obj.formula_details(j).dtl_attribute25;
Line: 1833

               l_formula_update_detail_rec.attribute26             := p_formula_obj.formula_details(j).dtl_attribute26;
Line: 1834

               l_formula_update_detail_rec.attribute27             := p_formula_obj.formula_details(j).dtl_attribute27;
Line: 1835

               l_formula_update_detail_rec.attribute28             := p_formula_obj.formula_details(j).dtl_attribute28;
Line: 1836

               l_formula_update_detail_rec.attribute29             := p_formula_obj.formula_details(j).dtl_attribute29;
Line: 1837

               l_formula_update_detail_rec.attribute30             := p_formula_obj.formula_details(j).dtl_attribute30;
Line: 1838

               l_formula_update_detail_rec.created_by              := FND_GLOBAL.USER_ID;
Line: 1839

               l_formula_update_detail_rec.creation_date           := NVL(p_formula_obj.formula_details(j).creation_date, SYSDATE);
Line: 1840

               l_formula_update_detail_rec.last_update_date        := NVL(p_formula_obj.formula_details(j).last_update_date, SYSDATE);
Line: 1841

               l_formula_update_detail_rec.last_update_login       := NVL(p_formula_obj.formula_details(j).last_update_login, FND_GLOBAL.USER_ID);
Line: 1842

               l_formula_update_detail_rec.last_updated_by         := FND_GLOBAL.USER_ID;
Line: 1843

               l_formula_update_detail_tbl(l_update_detailctr)     := l_formula_update_detail_rec;
Line: 1844

	       l_update_detailctr                                  := l_update_detailctr + 1;
Line: 1848

IF ( l_formula_insert_header_tbl.COUNT > 0) THEN
  GMD_FORMULA_PUB.Insert_Formula
  (   p_api_version           => 1.0
     ,p_init_msg_list         => FND_API.G_FALSE
     ,p_commit                => FND_API.G_FALSE
     ,p_called_from_forms     => 'NO'
     ,x_return_status         => l_ret_status
     ,x_msg_count             => l_msg_count
     ,x_msg_data              => l_msg_data
     ,p_formula_header_tbl    => l_formula_insert_header_tbl
     ,p_allow_zero_ing_qty    => l_zero_ing_qty
  );
Line: 1867

IF ( l_formula_update_header_tbl.COUNT > 0) THEN
  GMD_FORMULA_PUB.Update_FormulaHeader
  (   p_api_version           => 2.0
     ,p_init_msg_list         => FND_API.G_FALSE
     ,p_commit                => FND_API.G_FALSE
     ,p_called_from_forms     => 'NO'
     ,x_return_status         => l_ret_status
     ,x_msg_count             => l_msg_count
     ,x_msg_data              => l_msg_data
    ,p_formula_header_tbl     => l_formula_update_header_tbl
  );
Line: 1886

IF ( l_formula_update_detail_tbl.COUNT > 0) THEN
  Delete_FormulaDetail(
   p_formula_detail_tbl => l_formula_update_detail_tbl
   ,x_line_delete_tbl   => l_line_delete_tbl
   ,x_return_status     => l_ret_status
   ,x_msg_count         => l_msg_count
   ,x_msg_data          => l_msg_data
  );
Line: 1898

  x_line_delete_tbl := l_line_delete_tbl;
Line: 1899

  GMD_FORMULA_DETAIL_PUB.Update_FormulaDetail
  (  p_api_version           => 2.0
     ,p_init_msg_list         => FND_API.G_FALSE
     ,p_commit                => FND_API.G_FALSE
     ,p_called_from_forms     => 'NO'
     ,x_return_status         => l_ret_status
     ,x_msg_count             => l_msg_count
     ,x_msg_data              => l_msg_data
     ,p_formula_detail_tbl    => l_formula_update_detail_tbl
  );
Line: 1915

IF ( l_formula_insert_detail_tbl.COUNT > 0) THEN

  GMD_FORMULA_DETAIL_PUB.Insert_FormulaDetail
  (   p_api_version           => 1.0
     ,p_init_msg_list         => FND_API.G_FALSE
     ,p_commit                => FND_API.G_FALSE
     ,p_called_from_forms     => 'NO'
     ,x_return_status         => l_ret_status
     ,x_msg_count             => l_msg_count
     ,x_msg_data              => l_msg_data
     ,p_formula_detail_tbl    =>l_formula_insert_detail_tbl
  );
Line: 1927

   SELECT Count(*)  INTO l_msg_count  FROM fm_matl_dtl WHERE formula_id=470;
Line: 1983

l_formula_obj_updated   gmd_ebi_formula_obj;
Line: 1990

l_line_delete_tbl gmd_ebi_formula_line_del_tbl;
Line: 1999

    update_org_ids(
      p_formula_obj => l_formula_obj_inp
      ,x_formula_obj => l_formula_obj
      ,x_msg_count  => l_msg_count
      ,x_return_status => l_ret_status
      ,x_msg_data => l_ret_msg
      );
Line: 2007

      update_item_ids(
        p_formula_obj => l_formula_obj
        ,x_formula_obj => l_formula_obj_updated
        ,x_return_status => l_ret_status
        ,x_msg_data => l_ret_msg
      );
Line: 2018

        p_formula_obj => l_formula_obj_updated
        ,x_return_status => l_ret_status
        ,x_msg_data => l_ret_msg
      );
Line: 2026

      IF l_formula_obj_updated.formula_details.Count < 2 THEN
        FND_MESSAGE.SET_NAME('GMD', 'FM_SAVE_FORMULA_ERR');
Line: 2028

        FND_MESSAGE.SET_TOKEN('FORMULA_NO', l_formula_obj_updated.formula_header.formula_no);
Line: 2029

        FND_MESSAGE.SET_TOKEN('FORMULA_VERS', l_formula_obj_updated.formula_header.formula_vers);
Line: 2034

        p_formula_obj => l_formula_obj_updated
        ,x_line_delete_tbl   => l_line_delete_tbl
        ,x_return_status => l_ret_status
        ,x_msg_count => l_msg_count
        ,x_msg_data => l_ret_msg
      );
Line: 2066

      p_input =>  l_formula_obj_updated
      ,p_line_delete_tbl => l_line_delete_tbl
      ,status_flag => l_status
      ,x_output => l_output
      ,x_return_status => l_ret_status
      ,x_msg_count => l_msg_count
      ,x_msg_data => l_ret_msg
    );