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_ICC_STRUCTURE_PVT dependencies on EGO_ICC_STRUCTURE_PVT

Line 1: PACKAGE BODY EGO_ICC_STRUCTURE_PVT AS

1: PACKAGE BODY EGO_ICC_STRUCTURE_PVT AS
2: /* $Header: egoistpb.pls 120.0.12010000.13 2009/09/10 19:45:00 sisankar ship $ */
3:
4: date_fmt varchar2(25) := 'yyyy/mm/dd hh24:mi:ss';
5: type item_revision_record is record

Line 1710: where icc_str_comp.from_object_revision_id = EGO_ICC_STRUCTURE_PVT.Get_Effective_Version(icc_str_comp.pk1_value,p_rev_date)

1706: and icc_structure.effectivity_control = 4
1707: and icc_structure.bill_sequence_id = icc_str_components.bill_sequence_id
1708: and nvl(icc_str_components.parent_bill_seq_id,icc_str_components.bill_sequence_id) = icc_structure.bill_sequence_id) icc_str_comp,
1709: mtl_system_items_vl msiv
1710: where icc_str_comp.from_object_revision_id = EGO_ICC_STRUCTURE_PVT.Get_Effective_Version(icc_str_comp.pk1_value,p_rev_date)
1711: and msiv.inventory_item_id = icc_str_comp.component_item_id
1712: and msiv.organization_id = p_organization_id;
1713:
1714: /* This PL/SQL table will be populated with ICC components for the effective version. */

Line 1990: if EGO_ICC_STRUCTURE_PVT.Compare_components(v_insert_comp_tbl(insert_comp_tbl_count).component_sequence_id,

1986: For insert_comp_tbl_count in 1..v_insert_comp_tbl.count loop
1987: l_item_comp_id := v_insert_comp_tbl(insert_comp_tbl_count).component_item_id;
1988: l_stmt_no := 250;
1989: if(v_icc_comp_tbl.exists(l_item_comp_id)) then
1990: if EGO_ICC_STRUCTURE_PVT.Compare_components(v_insert_comp_tbl(insert_comp_tbl_count).component_sequence_id,
1991: v_icc_comp_tbl(l_item_comp_id).component_sequence_id) = 0 then
1992: --Components with same attributes
1993: l_stmt_no := 260;
1994: If v_insert_comp_tbl(insert_comp_tbl_count).to_revision_id is null then

Line 2312: where icc_str_comp.from_object_revision_id = EGO_ICC_STRUCTURE_PVT.Get_Effective_Version(icc_str_comp.pk1_value,p_rev_date)

2308: and icc_structure.effectivity_control = 4
2309: and icc_structure.bill_sequence_id = icc_str_components.bill_sequence_id
2310: and nvl(icc_str_components.parent_bill_seq_id,icc_str_components.bill_sequence_id) = icc_structure.bill_sequence_id) icc_str_comp,
2311: mtl_system_items_vl msiv
2312: where icc_str_comp.from_object_revision_id = EGO_ICC_STRUCTURE_PVT.Get_Effective_Version(icc_str_comp.pk1_value,p_rev_date)
2313: and msiv.inventory_item_id = icc_str_comp.component_item_id
2314: and msiv.organization_id = p_organization_id;
2315:
2316: type component_record is record

Line 2603: and (p_rev_date between EGO_ICC_STRUCTURE_PVT.get_revision_start_date(bcb.from_end_item_rev_id) and

2599: bulk collect into v_item_comp_tbl
2600: from bom_components_b bcb
2601: where bcb.bill_sequence_id = l_item_bill_sequence_id
2602: and bcb.inherit_flag = 1
2603: and (p_rev_date between EGO_ICC_STRUCTURE_PVT.get_revision_start_date(bcb.from_end_item_rev_id) and
2604: EGO_ICC_STRUCTURE_PVT.get_revision_end_date(nvl(bcb.to_end_item_rev_id,-1)));
2605: exception
2606: when others then
2607: null;

Line 2604: EGO_ICC_STRUCTURE_PVT.get_revision_end_date(nvl(bcb.to_end_item_rev_id,-1)));

2600: from bom_components_b bcb
2601: where bcb.bill_sequence_id = l_item_bill_sequence_id
2602: and bcb.inherit_flag = 1
2603: and (p_rev_date between EGO_ICC_STRUCTURE_PVT.get_revision_start_date(bcb.from_end_item_rev_id) and
2604: EGO_ICC_STRUCTURE_PVT.get_revision_end_date(nvl(bcb.to_end_item_rev_id,-1)));
2605: exception
2606: when others then
2607: null;
2608: end;

Line 2618: EGO_ICC_STRUCTURE_PVT.Compare_components(v_item_comp_tbl(cntr).component_sequence_id,

2614: l_comp_id := v_item_comp_tbl(cntr).component_item_id;
2615: l_stmt_no := 250;
2616: -- Start: Process components existing in both ICC and Item structure with same attributes
2617: if v_icc_comp_tbl.exists(l_comp_id) and
2618: EGO_ICC_STRUCTURE_PVT.Compare_components(v_item_comp_tbl(cntr).component_sequence_id,
2619: v_icc_comp_tbl(l_comp_id).component_sequence_id) = 0 then
2620: /* If the component has same attributes as that in ICC component list, We do not need to process it. */
2621: l_stmt_no := 260;
2622: v_icc_comp_tbl(l_comp_id).is_component_present := 1;

Line 2986: and icc_str_components.from_object_revision_id = EGO_ICC_STRUCTURE_PVT.Get_Effective_Version(icc_structure.pk1_value,

2982: and icc_structure.assembly_type = 2
2983: and icc_structure.effectivity_control = 4
2984: and icc_structure.bill_sequence_id = icc_str_components.bill_sequence_id
2985: and nvl(icc_str_components.parent_bill_seq_id,icc_str_components.bill_sequence_id) = icc_structure.bill_sequence_id
2986: and icc_str_components.from_object_revision_id = EGO_ICC_STRUCTURE_PVT.Get_Effective_Version(icc_structure.pk1_value,
2987: revision.effectivity_date)
2988: and rownum = 1);
2989:
2990: exception

Line 3347: FND_MSG_PUB.Add_Exc_Msg('EGO_ICC_STRUCTURE_PVT','Validate_Base_attributes',sqlerrm(sqlcode));

3343: return l_val_failure;
3344:
3345: Exception
3346: when others then
3347: FND_MSG_PUB.Add_Exc_Msg('EGO_ICC_STRUCTURE_PVT','Validate_Base_attributes',sqlerrm(sqlcode));
3348: return 1;
3349: End Validate_Base_attributes;
3350:
3351: END EGO_ICC_STRUCTURE_PVT;

Line 3351: END EGO_ICC_STRUCTURE_PVT;

3347: FND_MSG_PUB.Add_Exc_Msg('EGO_ICC_STRUCTURE_PVT','Validate_Base_attributes',sqlerrm(sqlcode));
3348: return 1;
3349: End Validate_Base_attributes;
3350:
3351: END EGO_ICC_STRUCTURE_PVT;