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.

[Home] [Help]

APPS.GMP_BOM_ROUTING_PKG dependencies on MSC_ST_BOMS

Line 536: TYPE sr_instance_id IS TABLE OF msc_st_boms.sr_instance_id%TYPE INDEX BY BINARY_INTEGER;

532: /* bug: 6918852 Vpedarla created new global variabelt control precision in inventory uom conversion */
533: conv_precision INTEGER := 9 ;
534:
535: /* --------------------------- Global declarations ------------------------ */
536: TYPE sr_instance_id IS TABLE OF msc_st_boms.sr_instance_id%TYPE INDEX BY BINARY_INTEGER;
537: bom_sr_instance_id sr_instance_id;
538: bomc_sr_instance_id sr_instance_id;
539: pef_sr_instance_id sr_instance_id;
540: rtg_sr_instance_id sr_instance_id;

Line 550: TYPE organization_id IS TABLE OF msc_st_boms.organization_id%TYPE INDEX BY BINARY_INTEGER;

546: itm_mtq_sr_instance_id sr_instance_id;
547: /* NAMIT_CR */
548: opr_stpdep_sr_instance_id sr_instance_id;
549:
550: TYPE organization_id IS TABLE OF msc_st_boms.organization_id%TYPE INDEX BY BINARY_INTEGER;
551: bom_organization_id organization_id;
552: bomc_organization_id organization_id;
553: pef_organization_id organization_id;
554: rtg_organization_id organization_id;

Line 564: TYPE bill_sequence_id IS TABLE OF msc_st_boms.bill_sequence_id%TYPE INDEX BY BINARY_INTEGER;

560: opr_organization_id organization_id ;
561: or_organization_id organization_id ;
562: rs_organization_id organization_id ;
563:
564: TYPE bill_sequence_id IS TABLE OF msc_st_boms.bill_sequence_id%TYPE INDEX BY BINARY_INTEGER;
565: bom_bill_sequence_id bill_sequence_id;
566: bomc_bill_sequence_id bill_sequence_id;
567: pef_bill_sequence_id bill_sequence_id;
568: oc_bill_sequence_id bill_sequence_id;

Line 570: TYPE last_update_date IS TABLE OF msc_st_boms.last_update_date%TYPE INDEX BY BINARY_INTEGER;

566: bomc_bill_sequence_id bill_sequence_id;
567: pef_bill_sequence_id bill_sequence_id;
568: oc_bill_sequence_id bill_sequence_id;
569:
570: TYPE last_update_date IS TABLE OF msc_st_boms.last_update_date%TYPE INDEX BY BINARY_INTEGER;
571: bom_last_update_date last_update_date ;
572: bomc_last_update_date last_update_date ;
573: pef_last_update_date last_update_date ;
574: rtg_last_update_date last_update_date ;

Line 582: TYPE creation_date IS TABLE OF msc_st_boms.creation_date%TYPE INDEX BY BINARY_INTEGER;

578: itm_mtq_last_update_date last_update_date ; /* 7363807 */
579: rs_last_update_date last_update_date ;
580: oc_last_update_date last_update_date ;
581:
582: TYPE creation_date IS TABLE OF msc_st_boms.creation_date%TYPE INDEX BY BINARY_INTEGER;
583: bom_creation_date creation_date ;
584: bomc_creation_date creation_date ;
585: pef_creation_date creation_date ;
586: rtg_creation_date creation_date ;

Line 619: TYPE assembly_item_id IS TABLE OF msc_st_boms.assembly_item_id%TYPE

615: rtg_uom_code uom_code ;
616: or_uom_code uom_code ;
617: opr_uom_code uom_code ;
618:
619: TYPE assembly_item_id IS TABLE OF msc_st_boms.assembly_item_id%TYPE
620: INDEX BY BINARY_INTEGER;
621: bom_assembly_item_id assembly_item_id ;
622: rtg_assembly_item_id assembly_item_id ;
623:

Line 656: TYPE alternate_bom_designator IS TABLE OF msc_st_boms.alternate_bom_designator%TYPE

652:
653: /* End of changes SGIDUGU - Seq Dep */
654:
655: /* ------------------------------- BOM declarations --------------------------- */
656: TYPE alternate_bom_designator IS TABLE OF msc_st_boms.alternate_bom_designator%TYPE
657: INDEX BY BINARY_INTEGER;
658: bom_alternate_bom_designator alternate_bom_designator ;
659:
660: TYPE specific_assembly_comment IS TABLE OF msc_st_boms.specific_assembly_comment%TYPE

Line 660: TYPE specific_assembly_comment IS TABLE OF msc_st_boms.specific_assembly_comment%TYPE

656: TYPE alternate_bom_designator IS TABLE OF msc_st_boms.alternate_bom_designator%TYPE
657: INDEX BY BINARY_INTEGER;
658: bom_alternate_bom_designator alternate_bom_designator ;
659:
660: TYPE specific_assembly_comment IS TABLE OF msc_st_boms.specific_assembly_comment%TYPE
661: INDEX BY BINARY_INTEGER;
662: bom_specific_assembly_comment specific_assembly_comment ;
663:
664: TYPE scaling_type IS TABLE OF msc_st_boms.scaling_type%TYPE

Line 664: TYPE scaling_type IS TABLE OF msc_st_boms.scaling_type%TYPE

660: TYPE specific_assembly_comment IS TABLE OF msc_st_boms.specific_assembly_comment%TYPE
661: INDEX BY BINARY_INTEGER;
662: bom_specific_assembly_comment specific_assembly_comment ;
663:
664: TYPE scaling_type IS TABLE OF msc_st_boms.scaling_type%TYPE
665: INDEX BY BINARY_INTEGER;
666: bom_scaling_type scaling_type ;
667:
668: TYPE assembly_quantity IS TABLE OF msc_st_boms.assembly_quantity%TYPE

Line 668: TYPE assembly_quantity IS TABLE OF msc_st_boms.assembly_quantity%TYPE

664: TYPE scaling_type IS TABLE OF msc_st_boms.scaling_type%TYPE
665: INDEX BY BINARY_INTEGER;
666: bom_scaling_type scaling_type ;
667:
668: TYPE assembly_quantity IS TABLE OF msc_st_boms.assembly_quantity%TYPE
669: INDEX BY BINARY_INTEGER;
670: bom_assembly_quantity assembly_quantity ;
671:
672: TYPE uom IS TABLE OF msc_st_boms.uom%TYPE INDEX BY BINARY_INTEGER;

Line 672: TYPE uom IS TABLE OF msc_st_boms.uom%TYPE INDEX BY BINARY_INTEGER;

668: TYPE assembly_quantity IS TABLE OF msc_st_boms.assembly_quantity%TYPE
669: INDEX BY BINARY_INTEGER;
670: bom_assembly_quantity assembly_quantity ;
671:
672: TYPE uom IS TABLE OF msc_st_boms.uom%TYPE INDEX BY BINARY_INTEGER;
673: bom_uom uom ;
674:
675: /* NAMIT_CR For Step Material Assoc */
676: TYPE seq_num IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 4060: log_message('Error writing to msc_st_boms: '||sqlerrm);

4056: -- bom_created_by(bom_index) := 0;
4057:
4058: EXCEPTION
4059: WHEN OTHERS THEN
4060: log_message('Error writing to msc_st_boms: '||sqlerrm);
4061: /* B3837959 MMK Issue, set return status to false */
4062: return_status := FALSE;
4063: END;
4064: primary_bom_written := 1 ;

Line 6102: INSERT INTO msc_st_boms (

6098: i := 1 ; /* B3837959 MMK Issue */
6099:
6100: IF bom_organization_id.FIRST > 0 THEN
6101: FORALL i IN bom_organization_id.FIRST..bom_organization_id.LAST
6102: INSERT INTO msc_st_boms (
6103: bill_sequence_id,
6104: sr_instance_id,
6105: organization_id,
6106: assembly_item_id,