DBA Data[Home] [Help]

APPS.INVPVALI dependencies on INVIDIT3

Line 608: OR (l_item_trans_type = 'CREATE' AND INVIDIT3.CHECK_NPR_CATALOG(l_item_catalog))

604:
605: --Revisions cannot be created for unapproved items.
606: --We allow only default revision
607: IF (l_item_trans_type = 'EXISTS' AND l_item_approved <> 'A')
608: OR (l_item_trans_type = 'CREATE' AND INVIDIT3.CHECK_NPR_CATALOG(l_item_catalog))
609: THEN
610: UPDATE mtl_item_revisions_interface
611: SET process_flag = l_process_flag_3
612: WHERE rowid = cr.rowid;

Line 952: OR (l_item_trans_type = 'CREATE' AND INVIDIT3.CHECK_NPR_CATALOG(l_item_catalog))

948: END IF;
949: ELSE
950: --Start: 3809876 :Unapproved item rev can have first phase ONLY.
951: IF (l_item_trans_type = 'EXISTS' AND l_item_approved <> 'A')
952: OR (l_item_trans_type = 'CREATE' AND INVIDIT3.CHECK_NPR_CATALOG(l_item_catalog))
953: THEN
954: IF cr.current_phase_id <> INV_EGO_REVISION_VALIDATE.Get_Initial_Lifecycle_Phase(nvl(cr.lifecycle_id, l_item_lifecycle_id))
955: THEN
956: update mtl_item_revisions_interface