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.EGO_ODI_PUB dependencies on BOM_EXPLODER_PUB

Line 4935: /*Bom_exploder_pub.Exploder_Userexit(Org_Id => r.ITEM_ORG_ID,

4931: */
4932:
4933: --inserted
4934: --explosion_api originally utilized in H-MDM
4935: /*Bom_exploder_pub.Exploder_Userexit(Org_Id => r.ITEM_ORG_ID,
4936: rev_date => x_rev_date,
4937: order_by => l_ordered_by,
4938: Levels_To_Explode => l_levels_to_explode,
4939: alt_desg => r.structure_name,

Line 4955: Bom_exploder_pub.Exploder_Userexit(Org_Id => r.ITEM_ORG_ID,

4951: );
4952: */
4953:
4954: --New explosion API suggested by Bushan and Naveen for Item Service
4955: Bom_exploder_pub.Exploder_Userexit(Org_Id => r.ITEM_ORG_ID,
4956: rev_date => r.explosion_date,
4957: order_by => l_ordered_by,
4958: Levels_To_Explode => l_levels_to_explode,
4959: impl_flag => 1, /* 1 - Imp Only, 2 - imp and unimpl */

Line 4990: EXPLOSION_DATE = bom_exploder_pub.get_explosion_date,

4986: END IF;
4987:
4988: UPDATE BOM_ODI_WS_ENTITIES
4989: SET group_id = x_group_id,
4990: EXPLOSION_DATE = bom_exploder_pub.get_explosion_date,
4991: EXPLOSION_OPTION = bom_exploder_pub.get_explode_option,
4992: ITEM_REV_CODE = bom_exploder_pub.get_expl_end_item_rev_code,
4993: ITEM_UNIT_NUMBER = bom_exploder_pub.get_expl_unit_number
4994: WHERE session_id = r.session_id

Line 4991: EXPLOSION_OPTION = bom_exploder_pub.get_explode_option,

4987:
4988: UPDATE BOM_ODI_WS_ENTITIES
4989: SET group_id = x_group_id,
4990: EXPLOSION_DATE = bom_exploder_pub.get_explosion_date,
4991: EXPLOSION_OPTION = bom_exploder_pub.get_explode_option,
4992: ITEM_REV_CODE = bom_exploder_pub.get_expl_end_item_rev_code,
4993: ITEM_UNIT_NUMBER = bom_exploder_pub.get_expl_unit_number
4994: WHERE session_id = r.session_id
4995: AND odi_session_id = r.odi_session_id

Line 4992: ITEM_REV_CODE = bom_exploder_pub.get_expl_end_item_rev_code,

4988: UPDATE BOM_ODI_WS_ENTITIES
4989: SET group_id = x_group_id,
4990: EXPLOSION_DATE = bom_exploder_pub.get_explosion_date,
4991: EXPLOSION_OPTION = bom_exploder_pub.get_explode_option,
4992: ITEM_REV_CODE = bom_exploder_pub.get_expl_end_item_rev_code,
4993: ITEM_UNIT_NUMBER = bom_exploder_pub.get_expl_unit_number
4994: WHERE session_id = r.session_id
4995: AND odi_session_id = r.odi_session_id
4996: AND ITEM_ID = r.ITEM_ID

Line 4993: ITEM_UNIT_NUMBER = bom_exploder_pub.get_expl_unit_number

4989: SET group_id = x_group_id,
4990: EXPLOSION_DATE = bom_exploder_pub.get_explosion_date,
4991: EXPLOSION_OPTION = bom_exploder_pub.get_explode_option,
4992: ITEM_REV_CODE = bom_exploder_pub.get_expl_end_item_rev_code,
4993: ITEM_UNIT_NUMBER = bom_exploder_pub.get_expl_unit_number
4994: WHERE session_id = r.session_id
4995: AND odi_session_id = r.odi_session_id
4996: AND ITEM_ID = r.ITEM_ID
4997: AND ITEM_ORG_ID = r.ITEM_ORG_ID

Line 5010: values (p_session_id, 'bom_exploder_pub.get_explosion_date: ' || bom_exploder_pub.get_explosion_date);

5006: --delete, debugging only
5007: /*INSERT INTO emt_temp (Session_id, message)
5008: values (p_session_id, 'comp_rec.component_sequence_id: ' || comp_rec.component_sequence_id);
5009: INSERT INTO emt_temp (Session_id, message)
5010: values (p_session_id, 'bom_exploder_pub.get_explosion_date: ' || bom_exploder_pub.get_explosion_date);
5011: INSERT INTO emt_temp (Session_id, message)
5012: values (p_session_id, 'bom_exploder_pub.get_expl_end_item_rev_code: ' || bom_exploder_pub.get_expl_end_item_rev_code);
5013: INSERT INTO emt_temp (Session_id, message)
5014: values (p_session_id, 'comp_rec.comp_fixed_revision_id: ' || comp_rec.comp_fixed_revision_id);

Line 5012: values (p_session_id, 'bom_exploder_pub.get_expl_end_item_rev_code: ' || bom_exploder_pub.get_expl_end_item_rev_code);

5008: values (p_session_id, 'comp_rec.component_sequence_id: ' || comp_rec.component_sequence_id);
5009: INSERT INTO emt_temp (Session_id, message)
5010: values (p_session_id, 'bom_exploder_pub.get_explosion_date: ' || bom_exploder_pub.get_explosion_date);
5011: INSERT INTO emt_temp (Session_id, message)
5012: values (p_session_id, 'bom_exploder_pub.get_expl_end_item_rev_code: ' || bom_exploder_pub.get_expl_end_item_rev_code);
5013: INSERT INTO emt_temp (Session_id, message)
5014: values (p_session_id, 'comp_rec.comp_fixed_revision_id: ' || comp_rec.comp_fixed_revision_id);
5015: INSERT INTO emt_temp (Session_id, message)
5016: values (p_session_id, 'comp_rec.parent_comp_seq_id: ' || comp_rec.parent_comp_seq_id);

Line 5020: l_comp_rev := bom_exploder_pub.get_component_revision(comp_rec.component_sequence_id);

5016: values (p_session_id, 'comp_rec.parent_comp_seq_id: ' || comp_rec.parent_comp_seq_id);
5017: */
5018:
5019: IF comp_rec.component_sequence_id IS NOT NULL THEN
5020: l_comp_rev := bom_exploder_pub.get_component_revision(comp_rec.component_sequence_id);
5021: l_comp_rev_id := bom_exploder_pub.get_component_revision_id(comp_rec.component_sequence_id);
5022: l_comp_rev_label := bom_exploder_pub.get_component_revision_label(comp_rec.component_sequence_id);
5023: ELSE
5024: l_comp_rev := NULL;

Line 5021: l_comp_rev_id := bom_exploder_pub.get_component_revision_id(comp_rec.component_sequence_id);

5017: */
5018:
5019: IF comp_rec.component_sequence_id IS NOT NULL THEN
5020: l_comp_rev := bom_exploder_pub.get_component_revision(comp_rec.component_sequence_id);
5021: l_comp_rev_id := bom_exploder_pub.get_component_revision_id(comp_rec.component_sequence_id);
5022: l_comp_rev_label := bom_exploder_pub.get_component_revision_label(comp_rec.component_sequence_id);
5023: ELSE
5024: l_comp_rev := NULL;
5025: l_comp_rev_id :=NULL;

Line 5022: l_comp_rev_label := bom_exploder_pub.get_component_revision_label(comp_rec.component_sequence_id);

5018:
5019: IF comp_rec.component_sequence_id IS NOT NULL THEN
5020: l_comp_rev := bom_exploder_pub.get_component_revision(comp_rec.component_sequence_id);
5021: l_comp_rev_id := bom_exploder_pub.get_component_revision_id(comp_rec.component_sequence_id);
5022: l_comp_rev_label := bom_exploder_pub.get_component_revision_label(comp_rec.component_sequence_id);
5023: ELSE
5024: l_comp_rev := NULL;
5025: l_comp_rev_id :=NULL;
5026: l_comp_rev_label :=NULL;

Line 5030: l_comp_rev_high_date := bom_exploder_pub.get_revision_highdate(comp_rec.comp_fixed_revision_id);

5026: l_comp_rev_label :=NULL;
5027: END IF;
5028:
5029: IF comp_rec.comp_fixed_revision_id IS NOT NULL THEN
5030: l_comp_rev_high_date := bom_exploder_pub.get_revision_highdate(comp_rec.comp_fixed_revision_id);
5031: ELSE
5032: l_comp_rev_high_date :=NULL;
5033: END IF;
5034:

Line 5036: l_comp_parent_rev := bom_exploder_pub.get_component_revision(comp_rec.parent_comp_seq_id);

5032: l_comp_rev_high_date :=NULL;
5033: END IF;
5034:
5035: IF comp_rec.parent_comp_seq_id IS NOT NULL THEN
5036: l_comp_parent_rev := bom_exploder_pub.get_component_revision(comp_rec.parent_comp_seq_id);
5037: ELSE
5038: l_comp_parent_rev :=NULL;
5039: END IF;
5040: