APPS.ENG_REVISED_ITEMS_PKG dependencies on ENG_REVISED_ITEMS

Line 1: PACKAGE BODY ENG_REVISED_ITEMS_PKG as

1: PACKAGE BODY ENG_REVISED_ITEMS_PKG as
2: /* $Header: engprvib.pls 120.7 2006/09/15 10:57:54 pdutta noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ENG_REVISED_ITEMS_PKG';
5:

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ENG_REVISED_ITEMS_PKG';

1: PACKAGE BODY ENG_REVISED_ITEMS_PKG as
2: /* $Header: engprvib.pls 120.7 2006/09/15 10:57:54 pdutta noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ENG_REVISED_ITEMS_PKG';
5:
6: FUNCTION Get_High_Rev_ECO (x_organization_id NUMBER,
7: x_revised_Item_id NUMBER,
8: x_new_item_revision VARCHAR2) RETURN VARCHAR2 IS

Line 10: cursor c1 is select change_notice from ENG_REVISED_ITEMS eri

6: FUNCTION Get_High_Rev_ECO (x_organization_id NUMBER,
7: x_revised_Item_id NUMBER,
8: x_new_item_revision VARCHAR2) RETURN VARCHAR2 IS
9: ECO VARCHAR2(10);
10: cursor c1 is select change_notice from ENG_REVISED_ITEMS eri
11: where eri.Organization_Id = x_organization_id
12: and eri.Revised_Item_Id = x_revised_item_id
13: and eri.New_Item_Revision = x_new_item_revision
14: and eri.Cancellation_Date is null;

Line 118: from ENG_REVISED_ITEMS eri

114: and bom2.alternate_bom_designator is not null))
115: or
116: (bom.alternate_bom_designator is not null
117: and not exists (select null
118: from ENG_REVISED_ITEMS eri
119: where eri.organization_id = bom.organization_id
120: and eri.bill_sequence_id = bom.bill_sequence_id
121: and eri.change_notice <> x_change_notice))
122: );

Line 146: from ENG_REVISED_ITEMS eri

142: and bom2.alternate_bom_designator is not null))
143: or
144: (bom.alternate_bom_designator is not null
145: and not exists (select null
146: from ENG_REVISED_ITEMS eri
147: where eri.organization_id = bom.organization_id
148: and eri.bill_sequence_id = bom.bill_sequence_id
149: and eri.change_notice <> x_change_notice))
150: );

Line 152: update ENG_REVISED_ITEMS

148: and eri.bill_sequence_id = bom.bill_sequence_id
149: and eri.change_notice <> x_change_notice))
150: );
151:
152: update ENG_REVISED_ITEMS
153: set bill_sequence_id = ''
154: where bill_sequence_id = x_bill_sequence_id
155: and organization_id = x_organization_id
156: and implementation_date is null

Line 599: , cp_revised_item_seq_id eng_revised_items.revised_item_sequence_id%TYPE

595: -- Cursor to Fetch all source bill's component changes that are being updated
596: -- by reschedule
597: CURSOR c_source_components(
598: cp_change_notice eng_engineering_changes.change_notice%TYPE
599: , cp_revised_item_seq_id eng_revised_items.revised_item_sequence_id%TYPE
600: , cp_bill_sequence_id bom_structures_b.bill_sequence_id%TYPE) IS
601: SELECT bcb.component_sequence_id
602: FROM bom_components_b bcb
603: WHERE bcb.CHANGE_NOTICE = cp_change_notice

Line 707: FROM eng_revised_items eri , mtl_system_items_vl msiv

703: AND organization_id = p_organization_id;
704:
705: CURSOR c_query_revised_item IS
706: SELECT eri.revised_item_sequence_id
707: FROM eng_revised_items eri , mtl_system_items_vl msiv
708: WHERE eri.change_id = p_change_id
709: AND eri.organization_id = p_organization_id
710: AND eri.revised_item_id = p_revised_item_id
711: AND eri.revised_item_id = msiv.inventory_item_id

Line 729: FROM eng_revised_items eri2

725: AND nvl(eri.new_item_revision_id, eri.current_item_revision_id)
726: = nvl(p_revision_id, nvl(eri.new_item_revision_id, eri.current_item_revision_id))
727: AND eri.scheduled_date IN
728: (SELECT eri2.scheduled_date
729: FROM eng_revised_items eri2
730: WHERE eri2.change_id = eri.change_id
731: AND eri2.organization_id = eri.organization_id
732: AND eri2.revised_item_id = eri.revised_item_id)
733: ORDER BY eri.scheduled_date DESC;

Line 843: FROM eng_revised_items

839:
840: CURSOR c_query_revised_item
841: IS
842: SELECT revised_item_sequence_id
843: FROM eng_revised_items
844: WHERE revised_item_id = p_revised_item_id
845: AND (p_effectivity_date IS NULL OR scheduled_date = p_effectivity_date)
846: AND bill_sequence_id = p_bill_sequence_id
847: AND NVL(from_end_item_unit_number, FND_API.G_MISS_CHAR)

Line 965: FROM eng_revised_items eri , mtl_system_items_vl msiv , bom_components_b bcb

961: -- 2: revised item status check
962: -- 3: common bom for src pending changes
963: CURSOR c_chk_rev_comp_editable IS
964: SELECT eri.revised_item_sequence_id
965: FROM eng_revised_items eri , mtl_system_items_vl msiv , bom_components_b bcb
966: WHERE eri.revised_item_sequence_id = bcb.revised_item_sequence_id
967: and bcb.component_sequence_id = p_component_sequence_id
968: AND eri.revised_item_id = msiv.inventory_item_id
969: AND eri.organization_id = msiv.organization_id

Line 1004: END ENG_REVISED_ITEMS_PKG ;

1000: CLOSE c_chk_rev_comp_editable;
1001: END IF;
1002: END Check_Rev_Comp_Editable;
1003:
1004: END ENG_REVISED_ITEMS_PKG ;