eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MRP_WFS_FORM_FLOW_SCHEDULE dependencies on MRP_FLOW_SCHEDULE_UTIL

Line 277: l_flow_schedule_val_rec := MRP_Flow_Schedule_Util.Get_Values

273: x_end_item_unit_number := l_x_flow_schedule_rec.end_item_unit_number;
274: x_quantity_scrapped := l_x_flow_schedule_rec.quantity_scrapped;
275: -- Load display out parameters if any
276:
277: l_flow_schedule_val_rec := MRP_Flow_Schedule_Util.Get_Values
278: ( p_flow_schedule_rec => l_x_flow_schedule_rec
279: , p_old_flow_schedule_rec => l_p_old_flow_schedule_rec
280: );
281:

Line 487: IF p_attr_id = MRP_Flow_Schedule_Util.G_ALTERNATE_BOM_DESIGNATOR THEN

483: );
484:
485: l_old_flow_schedule_rec := l_flow_schedule_rec;
486:
487: IF p_attr_id = MRP_Flow_Schedule_Util.G_ALTERNATE_BOM_DESIGNATOR THEN
488: l_flow_schedule_rec.alternate_bom_designator := p_attr_value;
489: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_ALTERNATE_ROUTING_DESIG THEN
490: l_flow_schedule_rec.alternate_routing_desig := p_attr_value;
491: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_BOM_REVISION THEN

Line 489: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_ALTERNATE_ROUTING_DESIG THEN

485: l_old_flow_schedule_rec := l_flow_schedule_rec;
486:
487: IF p_attr_id = MRP_Flow_Schedule_Util.G_ALTERNATE_BOM_DESIGNATOR THEN
488: l_flow_schedule_rec.alternate_bom_designator := p_attr_value;
489: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_ALTERNATE_ROUTING_DESIG THEN
490: l_flow_schedule_rec.alternate_routing_desig := p_attr_value;
491: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_BOM_REVISION THEN
492: l_flow_schedule_rec.bom_revision := p_attr_value;
493: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_BOM_REVISION_DATE THEN

Line 491: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_BOM_REVISION THEN

487: IF p_attr_id = MRP_Flow_Schedule_Util.G_ALTERNATE_BOM_DESIGNATOR THEN
488: l_flow_schedule_rec.alternate_bom_designator := p_attr_value;
489: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_ALTERNATE_ROUTING_DESIG THEN
490: l_flow_schedule_rec.alternate_routing_desig := p_attr_value;
491: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_BOM_REVISION THEN
492: l_flow_schedule_rec.bom_revision := p_attr_value;
493: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_BOM_REVISION_DATE THEN
494: l_flow_schedule_rec.bom_revision_date := fnd_date.canonical_to_date(p_attr_value);
495: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_BUILD_SEQUENCE THEN

Line 493: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_BOM_REVISION_DATE THEN

489: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_ALTERNATE_ROUTING_DESIG THEN
490: l_flow_schedule_rec.alternate_routing_desig := p_attr_value;
491: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_BOM_REVISION THEN
492: l_flow_schedule_rec.bom_revision := p_attr_value;
493: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_BOM_REVISION_DATE THEN
494: l_flow_schedule_rec.bom_revision_date := fnd_date.canonical_to_date(p_attr_value);
495: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_BUILD_SEQUENCE THEN
496: l_flow_schedule_rec.build_sequence := TO_NUMBER(p_attr_value);
497: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_CLASS THEN

Line 495: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_BUILD_SEQUENCE THEN

491: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_BOM_REVISION THEN
492: l_flow_schedule_rec.bom_revision := p_attr_value;
493: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_BOM_REVISION_DATE THEN
494: l_flow_schedule_rec.bom_revision_date := fnd_date.canonical_to_date(p_attr_value);
495: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_BUILD_SEQUENCE THEN
496: l_flow_schedule_rec.build_sequence := TO_NUMBER(p_attr_value);
497: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_CLASS THEN
498: l_flow_schedule_rec.class_code := p_attr_value;
499: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_COMPLETION_LOCATOR THEN

Line 497: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_CLASS THEN

493: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_BOM_REVISION_DATE THEN
494: l_flow_schedule_rec.bom_revision_date := fnd_date.canonical_to_date(p_attr_value);
495: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_BUILD_SEQUENCE THEN
496: l_flow_schedule_rec.build_sequence := TO_NUMBER(p_attr_value);
497: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_CLASS THEN
498: l_flow_schedule_rec.class_code := p_attr_value;
499: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_COMPLETION_LOCATOR THEN
500: l_flow_schedule_rec.completion_locator_id := TO_NUMBER(p_attr_value);
501: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_COMPLETION_SUBINVENTORY THEN

Line 499: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_COMPLETION_LOCATOR THEN

495: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_BUILD_SEQUENCE THEN
496: l_flow_schedule_rec.build_sequence := TO_NUMBER(p_attr_value);
497: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_CLASS THEN
498: l_flow_schedule_rec.class_code := p_attr_value;
499: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_COMPLETION_LOCATOR THEN
500: l_flow_schedule_rec.completion_locator_id := TO_NUMBER(p_attr_value);
501: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_COMPLETION_SUBINVENTORY THEN
502: l_flow_schedule_rec.completion_subinventory := p_attr_value;
503: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_DATE_CLOSED THEN

Line 501: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_COMPLETION_SUBINVENTORY THEN

497: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_CLASS THEN
498: l_flow_schedule_rec.class_code := p_attr_value;
499: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_COMPLETION_LOCATOR THEN
500: l_flow_schedule_rec.completion_locator_id := TO_NUMBER(p_attr_value);
501: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_COMPLETION_SUBINVENTORY THEN
502: l_flow_schedule_rec.completion_subinventory := p_attr_value;
503: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_DATE_CLOSED THEN
504: l_flow_schedule_rec.date_closed := fnd_date.canonical_to_date(p_attr_value);
505: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_DEMAND_CLASS THEN

Line 503: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_DATE_CLOSED THEN

499: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_COMPLETION_LOCATOR THEN
500: l_flow_schedule_rec.completion_locator_id := TO_NUMBER(p_attr_value);
501: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_COMPLETION_SUBINVENTORY THEN
502: l_flow_schedule_rec.completion_subinventory := p_attr_value;
503: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_DATE_CLOSED THEN
504: l_flow_schedule_rec.date_closed := fnd_date.canonical_to_date(p_attr_value);
505: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_DEMAND_CLASS THEN
506: l_flow_schedule_rec.demand_class := p_attr_value;
507: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_DEMAND_SOURCE_DELIVERY THEN

Line 505: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_DEMAND_CLASS THEN

501: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_COMPLETION_SUBINVENTORY THEN
502: l_flow_schedule_rec.completion_subinventory := p_attr_value;
503: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_DATE_CLOSED THEN
504: l_flow_schedule_rec.date_closed := fnd_date.canonical_to_date(p_attr_value);
505: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_DEMAND_CLASS THEN
506: l_flow_schedule_rec.demand_class := p_attr_value;
507: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_DEMAND_SOURCE_DELIVERY THEN
508: l_flow_schedule_rec.demand_source_delivery := p_attr_value;
509: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_DEMAND_SOURCE_HEADER THEN

Line 507: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_DEMAND_SOURCE_DELIVERY THEN

503: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_DATE_CLOSED THEN
504: l_flow_schedule_rec.date_closed := fnd_date.canonical_to_date(p_attr_value);
505: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_DEMAND_CLASS THEN
506: l_flow_schedule_rec.demand_class := p_attr_value;
507: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_DEMAND_SOURCE_DELIVERY THEN
508: l_flow_schedule_rec.demand_source_delivery := p_attr_value;
509: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_DEMAND_SOURCE_HEADER THEN
510: l_flow_schedule_rec.demand_source_header_id := TO_NUMBER(p_attr_value);
511: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_DEMAND_SOURCE_LINE THEN

Line 509: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_DEMAND_SOURCE_HEADER THEN

505: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_DEMAND_CLASS THEN
506: l_flow_schedule_rec.demand_class := p_attr_value;
507: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_DEMAND_SOURCE_DELIVERY THEN
508: l_flow_schedule_rec.demand_source_delivery := p_attr_value;
509: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_DEMAND_SOURCE_HEADER THEN
510: l_flow_schedule_rec.demand_source_header_id := TO_NUMBER(p_attr_value);
511: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_DEMAND_SOURCE_LINE THEN
512: l_flow_schedule_rec.demand_source_line := p_attr_value;
513: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_DEMAND_SOURCE_TYPE THEN

Line 511: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_DEMAND_SOURCE_LINE THEN

507: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_DEMAND_SOURCE_DELIVERY THEN
508: l_flow_schedule_rec.demand_source_delivery := p_attr_value;
509: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_DEMAND_SOURCE_HEADER THEN
510: l_flow_schedule_rec.demand_source_header_id := TO_NUMBER(p_attr_value);
511: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_DEMAND_SOURCE_LINE THEN
512: l_flow_schedule_rec.demand_source_line := p_attr_value;
513: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_DEMAND_SOURCE_TYPE THEN
514: l_flow_schedule_rec.demand_source_type := TO_NUMBER(p_attr_value);
515: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_LINE THEN

Line 513: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_DEMAND_SOURCE_TYPE THEN

509: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_DEMAND_SOURCE_HEADER THEN
510: l_flow_schedule_rec.demand_source_header_id := TO_NUMBER(p_attr_value);
511: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_DEMAND_SOURCE_LINE THEN
512: l_flow_schedule_rec.demand_source_line := p_attr_value;
513: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_DEMAND_SOURCE_TYPE THEN
514: l_flow_schedule_rec.demand_source_type := TO_NUMBER(p_attr_value);
515: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_LINE THEN
516: l_flow_schedule_rec.line_id := TO_NUMBER(p_attr_value);
517: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_MATERIAL_ACCOUNT THEN

Line 515: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_LINE THEN

511: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_DEMAND_SOURCE_LINE THEN
512: l_flow_schedule_rec.demand_source_line := p_attr_value;
513: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_DEMAND_SOURCE_TYPE THEN
514: l_flow_schedule_rec.demand_source_type := TO_NUMBER(p_attr_value);
515: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_LINE THEN
516: l_flow_schedule_rec.line_id := TO_NUMBER(p_attr_value);
517: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_MATERIAL_ACCOUNT THEN
518: l_flow_schedule_rec.material_account := TO_NUMBER(p_attr_value);
519: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_MATERIAL_OVERHEAD_ACCOUNT THEN

Line 517: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_MATERIAL_ACCOUNT THEN

513: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_DEMAND_SOURCE_TYPE THEN
514: l_flow_schedule_rec.demand_source_type := TO_NUMBER(p_attr_value);
515: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_LINE THEN
516: l_flow_schedule_rec.line_id := TO_NUMBER(p_attr_value);
517: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_MATERIAL_ACCOUNT THEN
518: l_flow_schedule_rec.material_account := TO_NUMBER(p_attr_value);
519: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_MATERIAL_OVERHEAD_ACCOUNT THEN
520: l_flow_schedule_rec.material_overhead_account := TO_NUMBER(p_attr_value);
521: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_MATERIAL_VARIANCE_ACCOUNT THEN

Line 519: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_MATERIAL_OVERHEAD_ACCOUNT THEN

515: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_LINE THEN
516: l_flow_schedule_rec.line_id := TO_NUMBER(p_attr_value);
517: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_MATERIAL_ACCOUNT THEN
518: l_flow_schedule_rec.material_account := TO_NUMBER(p_attr_value);
519: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_MATERIAL_OVERHEAD_ACCOUNT THEN
520: l_flow_schedule_rec.material_overhead_account := TO_NUMBER(p_attr_value);
521: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_MATERIAL_VARIANCE_ACCOUNT THEN
522: l_flow_schedule_rec.material_variance_account := TO_NUMBER(p_attr_value);
523: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_MPS_NET_QUANTITY THEN

Line 521: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_MATERIAL_VARIANCE_ACCOUNT THEN

517: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_MATERIAL_ACCOUNT THEN
518: l_flow_schedule_rec.material_account := TO_NUMBER(p_attr_value);
519: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_MATERIAL_OVERHEAD_ACCOUNT THEN
520: l_flow_schedule_rec.material_overhead_account := TO_NUMBER(p_attr_value);
521: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_MATERIAL_VARIANCE_ACCOUNT THEN
522: l_flow_schedule_rec.material_variance_account := TO_NUMBER(p_attr_value);
523: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_MPS_NET_QUANTITY THEN
524: l_flow_schedule_rec.mps_net_quantity := TO_NUMBER(p_attr_value);
525: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_MPS_SCHEDULED_COMP_DATE THEN

Line 523: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_MPS_NET_QUANTITY THEN

519: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_MATERIAL_OVERHEAD_ACCOUNT THEN
520: l_flow_schedule_rec.material_overhead_account := TO_NUMBER(p_attr_value);
521: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_MATERIAL_VARIANCE_ACCOUNT THEN
522: l_flow_schedule_rec.material_variance_account := TO_NUMBER(p_attr_value);
523: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_MPS_NET_QUANTITY THEN
524: l_flow_schedule_rec.mps_net_quantity := TO_NUMBER(p_attr_value);
525: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_MPS_SCHEDULED_COMP_DATE THEN
526: l_flow_schedule_rec.mps_scheduled_comp_date := fnd_date.canonical_to_date(p_attr_value);
527: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_ORGANIZATION THEN

Line 525: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_MPS_SCHEDULED_COMP_DATE THEN

521: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_MATERIAL_VARIANCE_ACCOUNT THEN
522: l_flow_schedule_rec.material_variance_account := TO_NUMBER(p_attr_value);
523: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_MPS_NET_QUANTITY THEN
524: l_flow_schedule_rec.mps_net_quantity := TO_NUMBER(p_attr_value);
525: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_MPS_SCHEDULED_COMP_DATE THEN
526: l_flow_schedule_rec.mps_scheduled_comp_date := fnd_date.canonical_to_date(p_attr_value);
527: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_ORGANIZATION THEN
528: l_flow_schedule_rec.organization_id := TO_NUMBER(p_attr_value);
529: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_OUTSIDE_PROCESSING_ACCT THEN

Line 527: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_ORGANIZATION THEN

523: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_MPS_NET_QUANTITY THEN
524: l_flow_schedule_rec.mps_net_quantity := TO_NUMBER(p_attr_value);
525: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_MPS_SCHEDULED_COMP_DATE THEN
526: l_flow_schedule_rec.mps_scheduled_comp_date := fnd_date.canonical_to_date(p_attr_value);
527: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_ORGANIZATION THEN
528: l_flow_schedule_rec.organization_id := TO_NUMBER(p_attr_value);
529: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_OUTSIDE_PROCESSING_ACCT THEN
530: l_flow_schedule_rec.outside_processing_acct := TO_NUMBER(p_attr_value);
531: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_OUTSIDE_PROC_VAR_ACCT THEN

Line 529: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_OUTSIDE_PROCESSING_ACCT THEN

525: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_MPS_SCHEDULED_COMP_DATE THEN
526: l_flow_schedule_rec.mps_scheduled_comp_date := fnd_date.canonical_to_date(p_attr_value);
527: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_ORGANIZATION THEN
528: l_flow_schedule_rec.organization_id := TO_NUMBER(p_attr_value);
529: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_OUTSIDE_PROCESSING_ACCT THEN
530: l_flow_schedule_rec.outside_processing_acct := TO_NUMBER(p_attr_value);
531: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_OUTSIDE_PROC_VAR_ACCT THEN
532: l_flow_schedule_rec.outside_proc_var_acct := TO_NUMBER(p_attr_value);
533: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_OVERHEAD_ACCOUNT THEN

Line 531: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_OUTSIDE_PROC_VAR_ACCT THEN

527: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_ORGANIZATION THEN
528: l_flow_schedule_rec.organization_id := TO_NUMBER(p_attr_value);
529: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_OUTSIDE_PROCESSING_ACCT THEN
530: l_flow_schedule_rec.outside_processing_acct := TO_NUMBER(p_attr_value);
531: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_OUTSIDE_PROC_VAR_ACCT THEN
532: l_flow_schedule_rec.outside_proc_var_acct := TO_NUMBER(p_attr_value);
533: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_OVERHEAD_ACCOUNT THEN
534: l_flow_schedule_rec.overhead_account := TO_NUMBER(p_attr_value);
535: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_OVERHEAD_VARIANCE_ACCOUNT THEN

Line 533: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_OVERHEAD_ACCOUNT THEN

529: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_OUTSIDE_PROCESSING_ACCT THEN
530: l_flow_schedule_rec.outside_processing_acct := TO_NUMBER(p_attr_value);
531: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_OUTSIDE_PROC_VAR_ACCT THEN
532: l_flow_schedule_rec.outside_proc_var_acct := TO_NUMBER(p_attr_value);
533: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_OVERHEAD_ACCOUNT THEN
534: l_flow_schedule_rec.overhead_account := TO_NUMBER(p_attr_value);
535: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_OVERHEAD_VARIANCE_ACCOUNT THEN
536: l_flow_schedule_rec.overhead_variance_account := TO_NUMBER(p_attr_value);
537: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_PLANNED_QUANTITY THEN

Line 535: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_OVERHEAD_VARIANCE_ACCOUNT THEN

531: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_OUTSIDE_PROC_VAR_ACCT THEN
532: l_flow_schedule_rec.outside_proc_var_acct := TO_NUMBER(p_attr_value);
533: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_OVERHEAD_ACCOUNT THEN
534: l_flow_schedule_rec.overhead_account := TO_NUMBER(p_attr_value);
535: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_OVERHEAD_VARIANCE_ACCOUNT THEN
536: l_flow_schedule_rec.overhead_variance_account := TO_NUMBER(p_attr_value);
537: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_PLANNED_QUANTITY THEN
538: l_flow_schedule_rec.planned_quantity := TO_NUMBER(p_attr_value);
539: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_PRIMARY_ITEM THEN

Line 537: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_PLANNED_QUANTITY THEN

533: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_OVERHEAD_ACCOUNT THEN
534: l_flow_schedule_rec.overhead_account := TO_NUMBER(p_attr_value);
535: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_OVERHEAD_VARIANCE_ACCOUNT THEN
536: l_flow_schedule_rec.overhead_variance_account := TO_NUMBER(p_attr_value);
537: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_PLANNED_QUANTITY THEN
538: l_flow_schedule_rec.planned_quantity := TO_NUMBER(p_attr_value);
539: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_PRIMARY_ITEM THEN
540: l_flow_schedule_rec.primary_item_id := TO_NUMBER(p_attr_value);
541: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_PROJECT THEN

Line 539: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_PRIMARY_ITEM THEN

535: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_OVERHEAD_VARIANCE_ACCOUNT THEN
536: l_flow_schedule_rec.overhead_variance_account := TO_NUMBER(p_attr_value);
537: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_PLANNED_QUANTITY THEN
538: l_flow_schedule_rec.planned_quantity := TO_NUMBER(p_attr_value);
539: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_PRIMARY_ITEM THEN
540: l_flow_schedule_rec.primary_item_id := TO_NUMBER(p_attr_value);
541: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_PROJECT THEN
542: l_flow_schedule_rec.project_id := TO_NUMBER(p_attr_value);
543: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_QUANTITY_COMPLETED THEN

Line 541: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_PROJECT THEN

537: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_PLANNED_QUANTITY THEN
538: l_flow_schedule_rec.planned_quantity := TO_NUMBER(p_attr_value);
539: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_PRIMARY_ITEM THEN
540: l_flow_schedule_rec.primary_item_id := TO_NUMBER(p_attr_value);
541: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_PROJECT THEN
542: l_flow_schedule_rec.project_id := TO_NUMBER(p_attr_value);
543: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_QUANTITY_COMPLETED THEN
544: l_flow_schedule_rec.quantity_completed := TO_NUMBER(p_attr_value);
545: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_REQUEST THEN

Line 543: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_QUANTITY_COMPLETED THEN

539: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_PRIMARY_ITEM THEN
540: l_flow_schedule_rec.primary_item_id := TO_NUMBER(p_attr_value);
541: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_PROJECT THEN
542: l_flow_schedule_rec.project_id := TO_NUMBER(p_attr_value);
543: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_QUANTITY_COMPLETED THEN
544: l_flow_schedule_rec.quantity_completed := TO_NUMBER(p_attr_value);
545: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_REQUEST THEN
546: l_flow_schedule_rec.request_id := TO_NUMBER(p_attr_value);
547: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_RESOURCE_ACCOUNT THEN

Line 545: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_REQUEST THEN

541: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_PROJECT THEN
542: l_flow_schedule_rec.project_id := TO_NUMBER(p_attr_value);
543: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_QUANTITY_COMPLETED THEN
544: l_flow_schedule_rec.quantity_completed := TO_NUMBER(p_attr_value);
545: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_REQUEST THEN
546: l_flow_schedule_rec.request_id := TO_NUMBER(p_attr_value);
547: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_RESOURCE_ACCOUNT THEN
548: l_flow_schedule_rec.resource_account := TO_NUMBER(p_attr_value);
549: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_RESOURCE_VARIANCE_ACCOUNT THEN

Line 547: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_RESOURCE_ACCOUNT THEN

543: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_QUANTITY_COMPLETED THEN
544: l_flow_schedule_rec.quantity_completed := TO_NUMBER(p_attr_value);
545: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_REQUEST THEN
546: l_flow_schedule_rec.request_id := TO_NUMBER(p_attr_value);
547: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_RESOURCE_ACCOUNT THEN
548: l_flow_schedule_rec.resource_account := TO_NUMBER(p_attr_value);
549: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_RESOURCE_VARIANCE_ACCOUNT THEN
550: l_flow_schedule_rec.resource_variance_account := TO_NUMBER(p_attr_value);
551: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_ROUTING_REVISION THEN

Line 549: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_RESOURCE_VARIANCE_ACCOUNT THEN

545: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_REQUEST THEN
546: l_flow_schedule_rec.request_id := TO_NUMBER(p_attr_value);
547: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_RESOURCE_ACCOUNT THEN
548: l_flow_schedule_rec.resource_account := TO_NUMBER(p_attr_value);
549: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_RESOURCE_VARIANCE_ACCOUNT THEN
550: l_flow_schedule_rec.resource_variance_account := TO_NUMBER(p_attr_value);
551: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_ROUTING_REVISION THEN
552: l_flow_schedule_rec.routing_revision := p_attr_value;
553: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_ROUTING_REVISION_DATE THEN

Line 551: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_ROUTING_REVISION THEN

547: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_RESOURCE_ACCOUNT THEN
548: l_flow_schedule_rec.resource_account := TO_NUMBER(p_attr_value);
549: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_RESOURCE_VARIANCE_ACCOUNT THEN
550: l_flow_schedule_rec.resource_variance_account := TO_NUMBER(p_attr_value);
551: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_ROUTING_REVISION THEN
552: l_flow_schedule_rec.routing_revision := p_attr_value;
553: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_ROUTING_REVISION_DATE THEN
554: l_flow_schedule_rec.routing_revision_date := fnd_date.canonical_to_date(p_attr_value);
555: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_SCHEDULED_COMPLETION_DATE THEN

Line 553: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_ROUTING_REVISION_DATE THEN

549: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_RESOURCE_VARIANCE_ACCOUNT THEN
550: l_flow_schedule_rec.resource_variance_account := TO_NUMBER(p_attr_value);
551: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_ROUTING_REVISION THEN
552: l_flow_schedule_rec.routing_revision := p_attr_value;
553: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_ROUTING_REVISION_DATE THEN
554: l_flow_schedule_rec.routing_revision_date := fnd_date.canonical_to_date(p_attr_value);
555: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_SCHEDULED_COMPLETION_DATE THEN
556: l_flow_schedule_rec.scheduled_completion_date := fnd_date.canonical_to_date(p_attr_value);
557: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_SCHEDULED THEN

Line 555: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_SCHEDULED_COMPLETION_DATE THEN

551: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_ROUTING_REVISION THEN
552: l_flow_schedule_rec.routing_revision := p_attr_value;
553: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_ROUTING_REVISION_DATE THEN
554: l_flow_schedule_rec.routing_revision_date := fnd_date.canonical_to_date(p_attr_value);
555: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_SCHEDULED_COMPLETION_DATE THEN
556: l_flow_schedule_rec.scheduled_completion_date := fnd_date.canonical_to_date(p_attr_value);
557: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_SCHEDULED THEN
558: l_flow_schedule_rec.scheduled_flag := TO_NUMBER(p_attr_value);
559: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_SCHEDULED_START_DATE THEN

Line 557: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_SCHEDULED THEN

553: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_ROUTING_REVISION_DATE THEN
554: l_flow_schedule_rec.routing_revision_date := fnd_date.canonical_to_date(p_attr_value);
555: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_SCHEDULED_COMPLETION_DATE THEN
556: l_flow_schedule_rec.scheduled_completion_date := fnd_date.canonical_to_date(p_attr_value);
557: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_SCHEDULED THEN
558: l_flow_schedule_rec.scheduled_flag := TO_NUMBER(p_attr_value);
559: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_SCHEDULED_START_DATE THEN
560: l_flow_schedule_rec.scheduled_start_date := fnd_date.canonical_to_date(p_attr_value);
561: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_SCHEDULE_GROUP THEN

Line 559: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_SCHEDULED_START_DATE THEN

555: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_SCHEDULED_COMPLETION_DATE THEN
556: l_flow_schedule_rec.scheduled_completion_date := fnd_date.canonical_to_date(p_attr_value);
557: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_SCHEDULED THEN
558: l_flow_schedule_rec.scheduled_flag := TO_NUMBER(p_attr_value);
559: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_SCHEDULED_START_DATE THEN
560: l_flow_schedule_rec.scheduled_start_date := fnd_date.canonical_to_date(p_attr_value);
561: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_SCHEDULE_GROUP THEN
562: l_flow_schedule_rec.schedule_group_id := TO_NUMBER(p_attr_value);
563: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_SCHEDULE_NUMBER THEN

Line 561: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_SCHEDULE_GROUP THEN

557: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_SCHEDULED THEN
558: l_flow_schedule_rec.scheduled_flag := TO_NUMBER(p_attr_value);
559: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_SCHEDULED_START_DATE THEN
560: l_flow_schedule_rec.scheduled_start_date := fnd_date.canonical_to_date(p_attr_value);
561: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_SCHEDULE_GROUP THEN
562: l_flow_schedule_rec.schedule_group_id := TO_NUMBER(p_attr_value);
563: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_SCHEDULE_NUMBER THEN
564: l_flow_schedule_rec.schedule_number := p_attr_value;
565: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_STATUS THEN

Line 563: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_SCHEDULE_NUMBER THEN

559: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_SCHEDULED_START_DATE THEN
560: l_flow_schedule_rec.scheduled_start_date := fnd_date.canonical_to_date(p_attr_value);
561: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_SCHEDULE_GROUP THEN
562: l_flow_schedule_rec.schedule_group_id := TO_NUMBER(p_attr_value);
563: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_SCHEDULE_NUMBER THEN
564: l_flow_schedule_rec.schedule_number := p_attr_value;
565: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_STATUS THEN
566: l_flow_schedule_rec.status := TO_NUMBER(p_attr_value);
567: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_STD_COST_ADJUSTMENT_ACCT THEN

Line 565: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_STATUS THEN

561: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_SCHEDULE_GROUP THEN
562: l_flow_schedule_rec.schedule_group_id := TO_NUMBER(p_attr_value);
563: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_SCHEDULE_NUMBER THEN
564: l_flow_schedule_rec.schedule_number := p_attr_value;
565: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_STATUS THEN
566: l_flow_schedule_rec.status := TO_NUMBER(p_attr_value);
567: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_STD_COST_ADJUSTMENT_ACCT THEN
568: l_flow_schedule_rec.std_cost_adjustment_acct := TO_NUMBER(p_attr_value);
569: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_TASK THEN

Line 567: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_STD_COST_ADJUSTMENT_ACCT THEN

563: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_SCHEDULE_NUMBER THEN
564: l_flow_schedule_rec.schedule_number := p_attr_value;
565: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_STATUS THEN
566: l_flow_schedule_rec.status := TO_NUMBER(p_attr_value);
567: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_STD_COST_ADJUSTMENT_ACCT THEN
568: l_flow_schedule_rec.std_cost_adjustment_acct := TO_NUMBER(p_attr_value);
569: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_TASK THEN
570: l_flow_schedule_rec.task_id := TO_NUMBER(p_attr_value);
571: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_WIP_ENTITY THEN

Line 569: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_TASK THEN

565: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_STATUS THEN
566: l_flow_schedule_rec.status := TO_NUMBER(p_attr_value);
567: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_STD_COST_ADJUSTMENT_ACCT THEN
568: l_flow_schedule_rec.std_cost_adjustment_acct := TO_NUMBER(p_attr_value);
569: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_TASK THEN
570: l_flow_schedule_rec.task_id := TO_NUMBER(p_attr_value);
571: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_WIP_ENTITY THEN
572: l_flow_schedule_rec.wip_entity_id := TO_NUMBER(p_attr_value);
573: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_END_ITEM_UNIT_NUMBER THEN

Line 571: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_WIP_ENTITY THEN

567: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_STD_COST_ADJUSTMENT_ACCT THEN
568: l_flow_schedule_rec.std_cost_adjustment_acct := TO_NUMBER(p_attr_value);
569: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_TASK THEN
570: l_flow_schedule_rec.task_id := TO_NUMBER(p_attr_value);
571: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_WIP_ENTITY THEN
572: l_flow_schedule_rec.wip_entity_id := TO_NUMBER(p_attr_value);
573: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_END_ITEM_UNIT_NUMBER THEN
574: l_flow_schedule_rec.end_item_unit_number:= p_attr_value;
575: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_QUANTITY_SCRAPPED THEN

Line 573: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_END_ITEM_UNIT_NUMBER THEN

569: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_TASK THEN
570: l_flow_schedule_rec.task_id := TO_NUMBER(p_attr_value);
571: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_WIP_ENTITY THEN
572: l_flow_schedule_rec.wip_entity_id := TO_NUMBER(p_attr_value);
573: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_END_ITEM_UNIT_NUMBER THEN
574: l_flow_schedule_rec.end_item_unit_number:= p_attr_value;
575: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_QUANTITY_SCRAPPED THEN
576: l_flow_schedule_rec.quantity_scrapped:= TO_NUMBER(p_attr_value);
577: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE1

Line 575: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_QUANTITY_SCRAPPED THEN

571: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_WIP_ENTITY THEN
572: l_flow_schedule_rec.wip_entity_id := TO_NUMBER(p_attr_value);
573: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_END_ITEM_UNIT_NUMBER THEN
574: l_flow_schedule_rec.end_item_unit_number:= p_attr_value;
575: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_QUANTITY_SCRAPPED THEN
576: l_flow_schedule_rec.quantity_scrapped:= TO_NUMBER(p_attr_value);
577: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE1
578: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE10
579: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE11

Line 577: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE1

573: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_END_ITEM_UNIT_NUMBER THEN
574: l_flow_schedule_rec.end_item_unit_number:= p_attr_value;
575: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_QUANTITY_SCRAPPED THEN
576: l_flow_schedule_rec.quantity_scrapped:= TO_NUMBER(p_attr_value);
577: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE1
578: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE10
579: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE11
580: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE12
581: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE13

Line 578: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE10

574: l_flow_schedule_rec.end_item_unit_number:= p_attr_value;
575: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_QUANTITY_SCRAPPED THEN
576: l_flow_schedule_rec.quantity_scrapped:= TO_NUMBER(p_attr_value);
577: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE1
578: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE10
579: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE11
580: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE12
581: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE13
582: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE14

Line 579: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE11

575: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_QUANTITY_SCRAPPED THEN
576: l_flow_schedule_rec.quantity_scrapped:= TO_NUMBER(p_attr_value);
577: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE1
578: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE10
579: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE11
580: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE12
581: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE13
582: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE14
583: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE15

Line 580: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE12

576: l_flow_schedule_rec.quantity_scrapped:= TO_NUMBER(p_attr_value);
577: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE1
578: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE10
579: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE11
580: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE12
581: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE13
582: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE14
583: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE15
584: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE2

Line 581: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE13

577: ELSIF p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE1
578: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE10
579: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE11
580: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE12
581: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE13
582: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE14
583: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE15
584: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE2
585: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE3

Line 582: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE14

578: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE10
579: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE11
580: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE12
581: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE13
582: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE14
583: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE15
584: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE2
585: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE3
586: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE4

Line 583: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE15

579: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE11
580: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE12
581: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE13
582: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE14
583: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE15
584: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE2
585: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE3
586: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE4
587: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE5

Line 584: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE2

580: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE12
581: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE13
582: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE14
583: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE15
584: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE2
585: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE3
586: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE4
587: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE5
588: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE6

Line 585: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE3

581: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE13
582: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE14
583: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE15
584: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE2
585: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE3
586: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE4
587: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE5
588: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE6
589: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE7

Line 586: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE4

582: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE14
583: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE15
584: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE2
585: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE3
586: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE4
587: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE5
588: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE6
589: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE7
590: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE8

Line 587: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE5

583: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE15
584: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE2
585: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE3
586: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE4
587: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE5
588: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE6
589: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE7
590: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE8
591: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE9

Line 588: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE6

584: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE2
585: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE3
586: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE4
587: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE5
588: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE6
589: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE7
590: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE8
591: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE9
592: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE_CATEGORY

Line 589: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE7

585: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE3
586: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE4
587: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE5
588: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE6
589: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE7
590: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE8
591: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE9
592: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE_CATEGORY
593: THEN

Line 590: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE8

586: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE4
587: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE5
588: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE6
589: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE7
590: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE8
591: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE9
592: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE_CATEGORY
593: THEN
594:

Line 591: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE9

587: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE5
588: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE6
589: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE7
590: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE8
591: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE9
592: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE_CATEGORY
593: THEN
594:
595: l_flow_schedule_rec.attribute1 := p_attribute1;

Line 592: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE_CATEGORY

588: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE6
589: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE7
590: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE8
591: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE9
592: OR p_attr_id = MRP_Flow_Schedule_Util.G_ATTRIBUTE_CATEGORY
593: THEN
594:
595: l_flow_schedule_rec.attribute1 := p_attribute1;
596: l_flow_schedule_rec.attribute10 := p_attribute10;

Line 733: l_flow_schedule_val_rec := MRP_Flow_Schedule_Util.Get_Values

729: x_quantity_scrapped := NULL;
730:
731: -- Load display out parameters if any
732:
733: l_flow_schedule_val_rec := MRP_Flow_Schedule_Util.Get_Values
734: ( p_flow_schedule_rec => l_x_flow_schedule_rec
735: , p_old_flow_schedule_rec => l_flow_schedule_rec
736: );
737:

Line 2430: g_flow_schedule_rec := MRP_Flow_Schedule_Util.Query_Row

2426: THEN
2427:
2428: -- Query row from DB
2429:
2430: g_flow_schedule_rec := MRP_Flow_Schedule_Util.Query_Row
2431: ( p_wip_entity_id => p_wip_entity_id
2432: );
2433:
2434: g_flow_schedule_rec.db_flag := FND_API.G_TRUE;

Line 2641: MRP_FLOW_SCHEDULE_UTIL.GET_FLOW_QUANTITY(SL1.LINE_ID,

2637: GREATEST((INV_DECIMALS_PUB.GET_PRIMARY_QUANTITY(SL1.SHIP_FROM_ORG_ID,
2638: SL1.INVENTORY_ITEM_ID,
2639: SL1.ORDER_QUANTITY_UOM,
2640: SL1.ORDERED_QUANTITY) -
2641: MRP_FLOW_SCHEDULE_UTIL.GET_FLOW_QUANTITY(SL1.LINE_ID,
2642: 2,
2643: TO_CHAR(NULL),
2644: MSI1.REPLENISH_TO_ORDER_FLAG) -
2645: MRP_FLOW_SCHEDULE_UTIL.GET_RESERVATION_QUANTITY(SL1.SHIP_FROM_ORG_ID,

Line 2645: MRP_FLOW_SCHEDULE_UTIL.GET_RESERVATION_QUANTITY(SL1.SHIP_FROM_ORG_ID,

2641: MRP_FLOW_SCHEDULE_UTIL.GET_FLOW_QUANTITY(SL1.LINE_ID,
2642: 2,
2643: TO_CHAR(NULL),
2644: MSI1.REPLENISH_TO_ORDER_FLAG) -
2645: MRP_FLOW_SCHEDULE_UTIL.GET_RESERVATION_QUANTITY(SL1.SHIP_FROM_ORG_ID,
2646: SL1.INVENTORY_ITEM_ID,
2647: SL1.LINE_ID,
2648: MSI1.REPLENISH_TO_ORDER_FLAG)),
2649: 0) order_quantity,

Line 2656: MRP_FLOW_SCHEDULE_UTIL.GET_ROUTING_DESIGNATOR(SL1.INVENTORY_ITEM_ID,

2652: sl1.demand_class_code demand_class,
2653: sl1.end_item_unit_number,
2654: msi1.replenish_to_order_flag,
2655: msi1.build_in_wip_flag,
2656: MRP_FLOW_SCHEDULE_UTIL.GET_ROUTING_DESIGNATOR(SL1.INVENTORY_ITEM_ID,
2657: SL1.SHIP_FROM_ORG_ID,
2658: WL.LINE_ID) alternate_routing_designator
2659: FROM
2660: OE_ORDER_LINES_ALL SL1,

Line 2673: mrp_flow_schedule_util.check_holds(sl2.header_id,

2669: null,
2670: 0,
2671: decode(sl2.ato_line_id,
2672: null,
2673: mrp_flow_schedule_util.check_holds(sl2.header_id,
2674: sl2.line_id,
2675: 'OEOL',
2676: 'LINE_SCHEDULING'),
2677: mrp_flow_schedule_util.check_holds(sl2.header_id,

Line 2677: mrp_flow_schedule_util.check_holds(sl2.header_id,

2673: mrp_flow_schedule_util.check_holds(sl2.header_id,
2674: sl2.line_id,
2675: 'OEOL',
2676: 'LINE_SCHEDULING'),
2677: mrp_flow_schedule_util.check_holds(sl2.header_id,
2678: sl2.line_id,
2679: null,
2680: null))) hold
2681: from oe_order_lines_all sl2) line_holds,

Line 2750: MRP_FLOW_SCHEDULE_UTIL.GET_FLOW_QUANTITY(TO_CHAR(MR1.TRANSACTION_ID),

2746: null demand_source_delivery,
2747: WL.LINE_ID,
2748: NVL(MR1.FIRM_DATE, MR1.NEW_SCHEDULE_DATE) order_date,
2749: GREATEST((NVL(MR1.FIRM_QUANTITY, MR1.NEW_ORDER_QUANTITY) -
2750: MRP_FLOW_SCHEDULE_UTIL.GET_FLOW_QUANTITY(TO_CHAR(MR1.TRANSACTION_ID),
2751: 100,
2752: NULL,
2753: NULL)),
2754: 0) order_quantity,

Line 2760: MRP_FLOW_SCHEDULE_UTIL.GET_ROUTING_DESIGNATOR(MR1.INVENTORY_ITEM_ID,

2756: MR1.TASK_ID,
2757: MR1.END_ITEM_UNIT_NUMBER,
2758: KFV.REPLENISH_TO_ORDER_FLAG,
2759: KFV.BUILD_IN_WIP_FLAG,
2760: MRP_FLOW_SCHEDULE_UTIL.GET_ROUTING_DESIGNATOR(MR1.INVENTORY_ITEM_ID,
2761: MR1.ORGANIZATION_ID,
2762: WL.LINE_ID) alternate_routing_designator
2763: FROM MTL_SYSTEM_ITEMS_B KFV,
2764: MRP_SYSTEM_ITEMS RSI1,