APPS.EGO_UI_ITEM_PUB dependencies on MTL_PENDING_ITEM_STATUS

Line 1197: UPDATE MTL_PENDING_ITEM_STATUS SET LIFECYCLE_ID = P_LIFECYCLE_ID

1193: UPDATE MTL_SYSTEM_ITEMS_B SET INVENTORY_ITEM_STATUS_CODE = P_ITEM_STATUS
1194: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
1195: AND ORGANIZATION_ID = P_ORGANIZATION_ID;
1196:
1197: UPDATE MTL_PENDING_ITEM_STATUS SET LIFECYCLE_ID = P_LIFECYCLE_ID
1198: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
1199: AND ORGANIZATION_ID = P_ORGANIZATION_ID;
1200:
1201: UPDATE MTL_PENDING_ITEM_STATUS SET PHASE_ID = P_CURRENT_PHASE_ID

Line 1201: UPDATE MTL_PENDING_ITEM_STATUS SET PHASE_ID = P_CURRENT_PHASE_ID

1197: UPDATE MTL_PENDING_ITEM_STATUS SET LIFECYCLE_ID = P_LIFECYCLE_ID
1198: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
1199: AND ORGANIZATION_ID = P_ORGANIZATION_ID;
1200:
1201: UPDATE MTL_PENDING_ITEM_STATUS SET PHASE_ID = P_CURRENT_PHASE_ID
1202: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
1203: AND ORGANIZATION_ID = P_ORGANIZATION_ID;
1204:
1205: UPDATE MTL_PENDING_ITEM_STATUS SET STATUS_CODE = P_ITEM_STATUS

Line 1205: UPDATE MTL_PENDING_ITEM_STATUS SET STATUS_CODE = P_ITEM_STATUS

1201: UPDATE MTL_PENDING_ITEM_STATUS SET PHASE_ID = P_CURRENT_PHASE_ID
1202: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
1203: AND ORGANIZATION_ID = P_ORGANIZATION_ID;
1204:
1205: UPDATE MTL_PENDING_ITEM_STATUS SET STATUS_CODE = P_ITEM_STATUS
1206: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
1207: AND ORGANIZATION_ID = P_ORGANIZATION_ID;
1208: developer_debug ('::2960442::Create_Item_Lifecycle::end');
1209: COMMIT;

Line 1272: -- Insert a row to Mtl_Pending_Item_Status table with master organization id

1268: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID;
1269: ELSE
1270: L_CONTROL_LEVEL := EGO_UI_ITEM_PUB.Get_Item_Attr_Control_Level(P_ITEM_ATTRIBUTE => 'MTL_SYSTEM_ITEMS.INVENTORY_ITEM_STATUS_CODE');
1271:
1272: -- Insert a row to Mtl_Pending_Item_Status table with master organization id
1273: -- and pending_flag = N.
1274: INSERT INTO MTL_PENDING_ITEM_STATUS
1275: (
1276: INVENTORY_ITEM_ID,

Line 1274: INSERT INTO MTL_PENDING_ITEM_STATUS

1270: L_CONTROL_LEVEL := EGO_UI_ITEM_PUB.Get_Item_Attr_Control_Level(P_ITEM_ATTRIBUTE => 'MTL_SYSTEM_ITEMS.INVENTORY_ITEM_STATUS_CODE');
1271:
1272: -- Insert a row to Mtl_Pending_Item_Status table with master organization id
1273: -- and pending_flag = N.
1274: INSERT INTO MTL_PENDING_ITEM_STATUS
1275: (
1276: INVENTORY_ITEM_ID,
1277: ORGANIZATION_ID,
1278: EFFECTIVE_DATE,

Line 1321: INSERT INTO MTL_PENDING_ITEM_STATUS

1317: LOOP
1318: FETCH ego_item_assigned_org_csr INTO L_ITEM_ASSIGNED_ORG_REC;
1319: EXIT WHEN ego_item_assigned_org_csr%NOTFOUND;
1320:
1321: INSERT INTO MTL_PENDING_ITEM_STATUS
1322: (
1323: INVENTORY_ITEM_ID,
1324: ORGANIZATION_ID,
1325: EFFECTIVE_DATE,

Line 1366: INSERT INTO MTL_PENDING_ITEM_STATUS

1362: LOOP
1363: FETCH ego_item_assigned_org_csr INTO L_ITEM_ASSIGNED_ORG_REC;
1364: EXIT WHEN ego_item_assigned_org_csr%NOTFOUND;
1365:
1366: INSERT INTO MTL_PENDING_ITEM_STATUS
1367: (
1368: INVENTORY_ITEM_ID,
1369: ORGANIZATION_ID,
1370: EFFECTIVE_DATE,