APPS.ENG_WORKFLOW_API_PKG dependencies on ENG_REVISED_ITEMS

Line 566: UPDATE eng_revised_items

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

Line 776: select revised_item_sequence_id from eng_revised_items

772: found_dup_rev_wo_comp NUMBER := 0;
773:
774: Cursor c_rev_items (c_change_notice VARCHAR2, c_org_id NUMBER)
775: IS
776: select revised_item_sequence_id from eng_revised_items
777: where change_notice = c_change_notice
778: and organization_id = c_org_id;
779:
780: Cursor c_dup_rev_items (c_rev_item_seq_id NUMBER, c_change_notice VARCHAR2, c_org_id NUMBER)

Line 783: from eng_revised_items eri, eng_revised_items eri1

779:
780: Cursor c_dup_rev_items (c_rev_item_seq_id NUMBER, c_change_notice VARCHAR2, c_org_id NUMBER)
781: IS
782: select eri1.revised_item_sequence_id
783: from eng_revised_items eri, eng_revised_items eri1
784: where eri.change_notice = c_change_notice
785: AND eri.organization_id = c_org_id
786: AND eri.revised_item_sequence_id = c_rev_item_seq_id
787: AND eri1.organization_id = c_org_id

Line 819: FROM eng_revised_items eri,

815:
816: /* --Changes from bug 7602108 which are merged in bug 9726856 */
817: SELECT COUNT(*)
818: INTO l_duplicate
819: FROM eng_revised_items eri,
820: eng_revised_items eri1
821: WHERE eri.change_notice = X_change_notice
822: AND eri.organization_id = X_org_id
823: AND eri1.organization_id = X_org_id

Line 820: eng_revised_items eri1

816: /* --Changes from bug 7602108 which are merged in bug 9726856 */
817: SELECT COUNT(*)
818: INTO l_duplicate
819: FROM eng_revised_items eri,
820: eng_revised_items eri1
821: WHERE eri.change_notice = X_change_notice
822: AND eri.organization_id = X_org_id
823: AND eri1.organization_id = X_org_id
824: AND eri1.revised_item_sequence_id <> eri.revised_item_sequence_id

Line 902: UPDATE eng_revised_items

898: if found_duplicate = 1 or found_dup_rev_wo_comp = 1 then
899: result := 'ERROR:DUPLICATE';
900: RETURN;
901: else
902: UPDATE eng_revised_items
903: SET mrp_active = 1 /* Set MRP Active=Yes */
904: WHERE change_notice = X_change_notice
905: AND organization_id = X_org_id
906: AND status_type in (1, 4); /* Rev Item Status=Open or Scheduled */

Line 913: UPDATE eng_revised_items

909: --changes for bug 9726856 end
910: --result := 'ERROR:DUPLICATE'; --error check outside is commented out
911: --RETURN;
912: else
913: UPDATE eng_revised_items
914: SET mrp_active = 1 /* Set MRP Active=Yes */
915: WHERE change_notice = X_change_notice
916: AND organization_id = X_org_id
917: AND status_type in (1, 4); /* Rev Item Status=Open or Scheduled */

Line 979: UPDATE eng_revised_items

975: itemkey => itemkey,
976: actid => actid,
977: funcmode => funcmode,
978: result => X_eco_result);
979: UPDATE eng_revised_items
980: SET mrp_active = 2 /* Set MRP Active=Yes */
981: WHERE change_notice = X_change_notice
982: AND organization_id = X_org_id
983: AND status_type in (1, 4); /* Rev Item Status=Open or Scheduled */