APPS.ENG_WORKFLOW_API_PKG dependencies on ENG_REVISED_ITEMS

Line 565: UPDATE eng_revised_items

561: approval_date = sysdate
562: WHERE organization_id = X_org_id
563: AND change_notice = X_change_notice;
564:
565: UPDATE eng_revised_items
566: SET status_type = 4 /* Set Rev Item Status = Scheduled */
567: ,status_code = 4 --Bug 3526627: Changes for 11.5.10, set the status_code also
568: WHERE change_notice = X_change_notice
569: AND organization_id = X_org_id

Line 769: UPDATE eng_revised_items

765: itemkey => itemkey,
766: actid => actid,
767: funcmode => funcmode,
768: result => X_eco_result);
769: UPDATE eng_revised_items
770: SET mrp_active = 1 /* Set MRP Active=Yes */
771: WHERE change_notice = X_change_notice
772: AND organization_id = X_org_id
773: AND status_type in (1, 4); /* Rev Item Status=Open or Scheduled */

Line 834: UPDATE eng_revised_items

830: itemkey => itemkey,
831: actid => actid,
832: funcmode => funcmode,
833: result => X_eco_result);
834: UPDATE eng_revised_items
835: SET mrp_active = 2 /* Set MRP Active=Yes */
836: WHERE change_notice = X_change_notice
837: AND organization_id = X_org_id
838: AND status_type in (1, 4); /* Rev Item Status=Open or Scheduled */