DBA Data[Home] [Help]

APPS.INVPVALI dependencies on INVIDIT3

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

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

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

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