DBA Data[Home] [Help]

APPS.BOM_RTG_GLOBALS dependencies on ENG_ENGINEERING_CHANGES

Line 107: FROM eng_engineering_changes

103: -- Get Workflow Process name
104: l_process_name := BOM_Rtg_Globals.Get_Process_Name;
105: SELECT approval_status_type
106: INTO l_approval_status_type
107: FROM eng_engineering_changes
108: WHERE change_notice = p_change_notice
109: AND organization_id = p_organization_id;
110:
111: -- ECO w/ Process is Approved

Line 141: UPDATE eng_engineering_changes

137: IS
138: BEGIN
139: -- Set ECO to 'Not Submitted For Approval'
140:
141: UPDATE eng_engineering_changes
142: SET approval_status_type = 1,
143: approval_request_date = null,
144: approval_date = null,
145: last_update_date = SYSDATE,