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.10 2010/09/01 20:28:55 umajumde ship $ */
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.10 2010/09/01 20:28:55 umajumde ship $ */
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: -- Query to fetch unimplemented ECOs only

Line 120: from ENG_REVISED_ITEMS eri

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

Line 148: from ENG_REVISED_ITEMS eri

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

Line 154: update ENG_REVISED_ITEMS

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

Line 601: , cp_revised_item_seq_id eng_revised_items.revised_item_sequence_id%TYPE

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

Line 730: FROM eng_revised_items eri , mtl_system_items_vl msiv

726: AND organization_id = p_organization_id;
727:
728: CURSOR c_query_revised_item IS
729: SELECT eri.revised_item_sequence_id
730: FROM eng_revised_items eri , mtl_system_items_vl msiv
731: WHERE eri.change_id = p_change_id
732: AND eri.organization_id = p_organization_id
733: AND eri.revised_item_id = p_revised_item_id
734: AND eri.revised_item_id = msiv.inventory_item_id

Line 752: FROM eng_revised_items eri2

748: AND nvl(eri.new_item_revision_id, eri.current_item_revision_id)
749: = nvl(p_revision_id, nvl(eri.new_item_revision_id, eri.current_item_revision_id))
750: AND eri.scheduled_date IN
751: (SELECT eri2.scheduled_date
752: FROM eng_revised_items eri2
753: WHERE eri2.change_id = eri.change_id
754: AND eri2.organization_id = eri.organization_id
755: AND eri2.revised_item_id = eri.revised_item_id)
756: ORDER BY eri.scheduled_date DESC;

Line 866: FROM eng_revised_items

862:
863: CURSOR c_query_revised_item
864: IS
865: SELECT revised_item_sequence_id
866: FROM eng_revised_items
867: WHERE revised_item_id = p_revised_item_id
868: AND (p_effectivity_date IS NULL OR scheduled_date = p_effectivity_date)
869: AND bill_sequence_id = p_bill_sequence_id
870: AND NVL(from_end_item_unit_number, FND_API.G_MISS_CHAR)

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

984: -- 2: revised item status check
985: -- 3: common bom for src pending changes
986: CURSOR c_chk_rev_comp_editable IS
987: SELECT eri.revised_item_sequence_id
988: FROM eng_revised_items eri , mtl_system_items_vl msiv , bom_components_b bcb
989: WHERE eri.revised_item_sequence_id = bcb.revised_item_sequence_id
990: and bcb.component_sequence_id = p_component_sequence_id
991: AND eri.revised_item_id = msiv.inventory_item_id
992: AND eri.organization_id = msiv.organization_id

Line 1027: END ENG_REVISED_ITEMS_PKG ;

1023: CLOSE c_chk_rev_comp_editable;
1024: END IF;
1025: END Check_Rev_Comp_Editable;
1026:
1027: END ENG_REVISED_ITEMS_PKG ;