APPS.ENG_REVISED_ITEM_UTIL dependencies on ENG_ENGINEERING_CHANGES

Line 186: UPDATE ENG_ENGINEERING_CHANGES

182: For X_NewStatus in CheckStatusEco loop
183:
184: -- Change ECO status to implemented.
185:
186: UPDATE ENG_ENGINEERING_CHANGES
187: SET IMPLEMENTATION_DATE = SYSDATE,
188: STATUS_TYPE = 6,
189: LAST_UPDATED_BY = p_user_id,
190: LAST_UPDATE_LOGIN = p_login

Line 210: UPDATE ENG_ENGINEERING_CHANGES

206: if (X_EcoStatus = 5) then
207:
208: -- Change ECO status to canceled.
209:
210: UPDATE ENG_ENGINEERING_CHANGES
211: SET CANCELLATION_DATE = SYSDATE,
212: STATUS_TYPE = 5,
213: LAST_UPDATED_BY = p_user_id,
214: LAST_UPDATE_LOGIN = p_login

Line 678: FROM eng_engineering_changes

674: BEGIN
675:
676: SELECT 1
677: INTO l_fetch_lifecycle
678: FROM eng_engineering_changes
679: WHERE nvl(plm_or_erp_change , 'PLM') = 'PLM'
680: AND change_notice = p_change_notice
681: AND organization_id = p_org_id;
682:

Line 2474: cp_change_notice eng_engineering_changes.change_notice%TYPE

2470: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
2471: -- Cursor to Fetch all source bill's component changes that are being updated
2472: -- by reschedule
2473: CURSOR c_source_components(
2474: cp_change_notice eng_engineering_changes.change_notice%TYPE
2475: , cp_revised_item_seq_id eng_revised_items.revised_item_sequence_id%TYPE
2476: , cp_bill_sequence_id bom_structures_b.bill_sequence_id%TYPE) IS
2477: SELECT bcb.component_sequence_id
2478: FROM bom_components_b bcb